OCCI / Win2K / Stored Proc with OUT param of %ROWTYPE

From: Jim West <Jim_at_jameswest.com>
Date: Thu, 07 Nov 2002 13:59:00 -0700
Message-ID: <60llsu4fq4nepc602v2n0c7nf4a7iu77m0_at_4ax.com>



I need some help /guidance.

I have a stored procedure with a signature of:

PROCEDURE myProc (var1 IN number, var2 OUT myTable%ROWTYPE)

In code my SQL statement:

stmtHndl->setSQL ( "BEGIN myProc(:var1,:var2); END;" );

Help needed:

What should the stmtHndl->registerOutParam ( 2, ... ) call look like? Is this even the right thing to do here?

Also, which execute method should I use? stmtHndl->execute() or stmtHndl->executeQuery() ??

Thanx for any and all help. Received on Thu Nov 07 2002 - 21:59:00 CET

Original text of this message