cursor and external stored procedure - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access cursor and external stored procedure

Print Thread

cursor and external stored procedure #6169 03/10/04 12:17 AM
Joined: Nov 2003 Posts: 8 D David Best OP Member
OP David Best Member D Joined: Nov 2003 Posts: 8	We have DOA 4.0.3 Is there a way to return a cursor from an external stored procedure? TIA

Re: cursor and external stored procedure #6170 03/10/04 09:45 PM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	Are you writing the external stored procedure using DOA, or do you want to call the external stored procedure from DOA? Marco Kalter Allround Automations

Re: cursor and external stored procedure #6171 03/10/04 11:06 PM
Joined: Nov 2002 Posts: 12 K koadam Member
koadam Member K Joined: Nov 2002 Posts: 12	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.

Re: cursor and external stored procedure #6172 03/10/04 11:30 PM
Joined: Nov 2003 Posts: 8 D David Best OP Member
OP David Best Member D Joined: Nov 2003 Posts: 8	The external stored procedure is written in Delphi using DOA and is called from pl/sql.

Re: cursor and external stored procedure #6173 03/11/04 10:35 PM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	Unfortunately this is currently not supported. You can only pass scalar data types such as strings, numbers, and dates. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.118s Queries: 14 (0.051s) Memory: 2.5110 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-28 23:10:17 UTC
Valid HTML 5 and Valid CSS