SQL Non-Query with Oracle REF CURSOR Out Parameter

Sean McClurkan

January 13, 2016 15:31

Essentials 4.4.2 HTML5 2.5.2

 

I'm trying to call a stored procedure on an Oracle database using the SQL Non-Query activity.  The stored procedure takes a comma-delimited string of Property ID's and returns a REF CURSOR through an OUT Parameter.

 

When testing at the database, it functions as expected and returns a collection of permit records for the specified Property ID's.  In the workflow, I have defined an IN argument of type String for the list of Property ID's, and an OUT parameter defined as type DataTable.

 

When executed, the workflow returns an error :   'Parameter 'ar_folder_result': Value is too large to bind.' in activity '1.76: SqlNonQuery'. Parameter 'ar_folder_result': Value is too large to bind.

 

There are 133 records returned by the procedure at the database.  Any ideas how to troubleshoot or resolve this error?  Is there any clarifying documentation on how the SQL Non-Query activity sees an Oracle REF CURSOR returning from the database, or how to define the OUT parameter to receive/interpret a REF CURSOR?

0

• 

  Permanently deleted user

  January 19, 2016 03:44

  I'm having similar issues with the non-query and query tools in the HTML5 2.5.3 viewer. It doesn't like to have ANY parameters and will raise an error if any are included. Works in Silverlight though. I think I'll post a question about it.

  0

Please sign in to leave a comment.