cursor and external stored procedure

[David Best]

We have DOA 4.0.3

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

TIA

 

[Marco Kalter]

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

 

[koadam]

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.

 

[David Best]

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

 

[Marco Kalter]

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