Re: Newbie: Creating Stored Procedures

From: <karsten_schmidt8891_at_my-deja.com>
Date: Tue, 09 Nov 1999 16:38:58 GMT
Message-ID: <809imr$427$1@nnrp1.deja.com>

Hi Juan,

 not that different from sqlplus:

(in pseudocode)
to create the procedure:

 build create statement in a char[]; // (just like in sqlplus, no

                                     // trailing '/' though)

 open cursor;
 parse statement;
 execute statement;
 close cursor;

 to execute your procedure:

 build an anonymous block like:
 "Begin; my_proc(:bindvar); End;"

 open cursor;
 parse statement;
 bind variables; // also for out-parameters. make sure, you have enough

                 // memory allocated.

 execute statement;
 close cursor;

HTH
 Karsten

In article <8074ee$bga$1_at_nnrp1.deja.com>,   juancr_at_my-deja.com wrote:
>
>
> How do I create/execute a stored procedure using the OCI??? Any hints
> on how to do that.
>
> Thanks in advance,
>
> Juan C. Rivera
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 09 1999 - 10:38:58 CST