Board index » delphi » ref cursor input output parameter

Kevin Allred

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

ref cursor input output parameter

hello,

I am using Delphi 4 with Oracle 7.2.3.
I need to pass a stored proc a ref cursor for input which will in turn
be supplied with some additional data that I need.  I know how to
retrieve a cursor that the stored proc creates, but how do I create one
so that I can pass it to the stored proc.

Thanks, Kevin

 
Jucimar Junio

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ref cursor input output parameter


BDE50 (D4) has problems with Oracle using stored procedures with REF cursor

To configure your BDE50 to woks with D4 and Oracle 7.3:

DLL32 = SQLORA32.DLL (Don't use OCI.DLL)
VENDOR INIT = ORA73.DLL <- Use it !
...
NET PROTOCOL = TNS (Don't uses TCP/IP)
...
SCHEMA CACHE DIR = 'C:\TEMP' or other
SCHEMA CACHE DIR = 32
...
SQLQRYMODE = SERVER
SERVER NAME = DESENV.WORLD (Connect string to Oracle)

Kevin Allred escreveu na mensagem <362EBCF9.FA275...@sisna.com>...

Quote
>hello,

>I am using Delphi 4 with Oracle 7.2.3.
>I need to pass a stored proc a ref cursor for input which will in turn
>be supplied with some additional data that I need.  I know how to
>retrieve a cursor that the stored proc creates, but how do I create one
>so that I can pass it to the stored proc.

>Thanks, Kevin

Kevin Allre

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ref cursor input output parameter


I have been successful using ref cursors to retrieve data from stored
procs, but in this case I need to pass a cursor as input to a stored
proc, filled with samples that will be logged into a lab system.  The
stored proc will return the lab id for each sample.  I assume I have to
create and load the cursor prior to calling the stored proc.  How do I
do this?

Thanks,
Kevin

Quote
Jucimar Junior wrote:
> BDE50 (D4) has problems with Oracle using stored procedures with REF
> cursor

> To configure your BDE50 to woks with D4 and Oracle 7.3:

> DLL32 = SQLORA32.DLL (Don't use OCI.DLL)
> VENDOR INIT = ORA73.DLL <- Use it !
> ...
> NET PROTOCOL = TNS (Don't uses TCP/IP)
> ...
> SCHEMA CACHE DIR = 'C:\TEMP' or other
> SCHEMA CACHE DIR = 32
> ...
> SQLQRYMODE = SERVER
> SERVER NAME = DESENV.WORLD (Connect string to Oracle)

> Kevin Allred escreveu na mensagem <362EBCF9.FA275...@sisna.com>...
> >hello,

> >I am using Delphi 4 with Oracle 7.2.3.
> >I need to pass a stored proc a ref cursor for input which will in
> turn
> >be supplied with some additional data that I need.  I know how to
> >retrieve a cursor that the stored proc creates, but how do I create
> one
> >so that I can pass it to the stored proc.

> >Thanks, Kevin

Paul Glaiste

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ref cursor input output parameter


Sorry for interrupting here but ...
I am trying to send and/or get row data from a stored procedure also.  When
I
click on Params in design view I get an access violation.  I am using
Oracle 8.0.4 though.  
Any ideas??  It is possible??

Jucimar Junior <jjun...@fucapi.br> wrote in article
<70n4pn$k...@forums.borland.com>...

Quote
> BDE50 (D4) has problems with Oracle using stored procedures with REF
cursor

> To configure your BDE50 to woks with D4 and Oracle 7.3:

> DLL32 = SQLORA32.DLL (Don't use OCI.DLL)
> VENDOR INIT = ORA73.DLL <- Use it !
> ...
> NET PROTOCOL = TNS (Don't uses TCP/IP)
> ...
> SCHEMA CACHE DIR = 'C:\TEMP' or other
> SCHEMA CACHE DIR = 32
> ...
> SQLQRYMODE = SERVER
> SERVER NAME = DESENV.WORLD (Connect string to Oracle)

> Kevin Allred escreveu na mensagem <362EBCF9.FA275...@sisna.com>...
> >hello,

> >I am using Delphi 4 with Oracle 7.2.3.
> >I need to pass a stored proc a ref cursor for input which will in turn
> >be supplied with some additional data that I need.  I know how to
> >retrieve a cursor that the stored proc creates, but how do I create one
> >so that I can pass it to the stored proc.

> >Thanks, Kevin

tomsc..

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:ref cursor input output parameter


On 27 Oct 1998 09:19:21 GMT, "Paul Glaister"

Quote
<pglais...@trinitech.co.uk> wrote:
>Sorry for interrupting here but ...
>I am trying to send and/or get row data from a stored procedure also.  When
>I
>click on Params in design view I get an access violation.  I am using
>Oracle 8.0.4 though.  
>Any ideas??  It is possible??

I reported a bug to Inprise with the Params editor about two months
ago. If you use more than 10 variables, Delphi 4 will crash totally,
if you are using Win95. If you're using NT, Delphi just disappears.

The only way around this that I found was to create the params in
code. It's not very difficult.

Other Threads

1. Oracle 8.1.7 and packaged stored procedure parameters (REF CURSORS)

2. Passing (input/output) parameters to a procedure

3. Delphi and ORACLE REF CURSOR

4. Using TADOStoredProc to get Oracle Ref Cursor

5. Oracle REF CURSOR, ADO, and DELPHI

6. ADO Express and Oracle REF CURSORS

7. Oracle and Ref Cursor

8. Oracle Ref Cursor and ADO Express

9. Oracle Ref Cursor and ADO

10. HELP. Returning REF CURSOR from Oracle Stored Procedure