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

shaoyongw over 9 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

0 Eduardo Fuentes
Appian Employee
over 9 years ago

I don't think the current code of the plug-in supports cursors as output parameters. See forum.appian.com/.../e-191910
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shaoyongw over 9 years ago

Yes, the testing shows that the cursor is not supported. This is a sample from the instructions document. Where can I find recipes for using this plugin?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

The only documentation the author has created is forum.appian.com/.../o

What RDBMS are you using?
Are you saying this is the result of following one of the examples from that PDF?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shaoyongw over 9 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