Re: Urgent : OCI Gurus : Please Help . . .

From: <szhan_at_csclub.uwaterloo.ca>
Date: Thu, 15 Jul 1999 12:59:20 GMT
Message-ID: <7mklv2$f1l$1@nnrp1.deja.com>

In article <378D2929.9CBD3F6C_at_stc.com>, Jet Long <jlong_at_stc.com> wrote:
> This is a multi-part message in MIME format.
> --------------B7F1557DD990B454B31F6016
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> szhan_at_csclub.uwaterloo.ca wrote:
>
> >
> > I thought we can directly call OSP (oracle stored proc)
> > from OCI without wrapping it with a layer of SQL statement.

> Do you remember which page in the OCI programming guide?

Jet, It was my misunderstanding about the OCI with OSP. I use the online guide which has a page long detail about dealing with OSP in OCI. It started with describing OSP.

Jet, you also mentioned about parse the statement. Why? The OCI guide for Oracle 8 never mentioned about that.

2) Parse the above SQL:

            oparse(hstmt, sql_smt, strlen(sql_stmt), 1, 2);
            (I am assuming that you are using defered mode)
3) Bind the arguments(input/output) to your host variables: obndra 4)
            Assign the values to the inputs (i.e. host variables)

Philip

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 15 1999 - 07:59:20 CDT