Can we use a ref cursor as an i/p parameter for executing the stored procedure t

anagha_abhyankar over 10 years ago

Can we use a ref cursor as an i/p parameter for executing the stored procedure through Appian?...

Discussion posts and replies are publicly visible

Parents

0 Patty Isecke
Appian Employee
over 10 years ago

Would you be able to use the Query Database Smart Service (forum.appian.com/.../Query_Database_Smart_Service.html), which supports create, insert, select, update and delete SQL statements.

Is this post also related to forum.appian.com/.../e-116162 ?

If so, this is likely because one of the values you are inserting is null. if you do not tell the jdbc type, it uses the default jdbc type which is
Types.UNKNOWN (1111). Please verify the data that you are trying to insert/update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Patty Isecke
Appian Employee
over 10 years ago

Would you be able to use the Query Database Smart Service (forum.appian.com/.../Query_Database_Smart_Service.html), which supports create, insert, select, update and delete SQL statements.

Is this post also related to forum.appian.com/.../e-116162 ?

If so, this is likely because one of the values you are inserting is null. if you do not tell the jdbc type, it uses the default jdbc type which is
Types.UNKNOWN (1111). Please verify the data that you are trying to insert/update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data