I got an error when using fn!executestoredprocedure. The cursor is not recognize

shaoyongw over 8 years ago

I got an error when using fn!executestoredprocedure. The cursor is not recognized as output datatype. I referred the sample from forum.appian.com/.../summary

Any idea how to map the returned data to cdt?

08:47:57,954 INFO [stdout] (http-/0.0.0.0:8080-27) 2016-03-14 08:47:57,954 [http-/0.0.0.0:8080-27] DEBUG com.appiancorp.ps.function.ExecuteStoredProcedureFunction - PIM.PKG_GENERATION.GET_CATEGORY registering output PO_CATEGORY_CURSOR
08:47:57,962 INFO [stdout] (http-/0.0.0.0:8080-27) 2016-03-14 08:47:57,962 [http-/0.0.0.0:8080-27] DEBUG com.appiancorp.ps.function.ExecuteStoredProcedureFunction - The datatype -10 for output parameter PO_CATEGORY_CURSOR + is not supported.

Discussion posts and replies are publicly visible

Parents

0 shaoyongw over 8 years ago

It is oracle. Yes, you can see the SP "sp_ListBooks" is using the SYS_REFCURSOR as out type.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 shaoyongw over 8 years ago

It is oracle. Yes, you can see the SP "sp_ListBooks" is using the SYS_REFCURSOR as out type.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data