Oracle Cursor as output

Venkat_Reddy2 · February 9, 2017, 7:45pm

Hi,

I am calling a Oracle function using JDBC StoredProcedureWithSignature adapter service that returns a Oracle REF Cursor. I see output field type is generated as ‘Document’. But when I run the service, I get empty output. Is there any step I am missing?

I can run this function from SQL clients and it just returns 1 string (XML). I do not know the column name that it will return.

Topic		Replies	Views
Handling Oracle reference cursor as output of JDBC adapter service Knowledge base webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards , JDBC-Oracle-Reference-Cursor , REF-CURSOR , Stored-Procedure-with-signature	0	1204	November 11, 2021
Oracle Cursor as input webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	4	5669	April 2, 2021
StoredProcedureWithSignature and cursors webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	670	April 2, 2021
Adapter Service and Cursors webMethods , Integration-Server-and-ESB , Flow-and-Java-services	6	1986	April 2, 2021
Oracle stored procedure call which returns PL/SQL TABLE data webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	2	3607	April 2, 2021

Oracle Cursor as output

Related topics