cursor and external stored procedure - Allround Automations forums

We have DOA 4.0.3

Is there a way to return a cursor from an external stored procedure?

TIA

Are you writing the external stored procedure using DOA, or do you want to call the external stored procedure from DOA?

Hi,
A'm also interested in the above question.
I want to write the external function/procedure with doa, returning a cursor. The client-side will be delphi applications using DOA and ODAC components.
B.

The external stored procedure is written in Delphi using DOA and is called from pl/sql.

Unfortunately this is currently not supported. You can only pass scalar data types such as strings, numbers, and dates.