Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: dynamic sql

Re: dynamic sql

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/02/07
Message-ID: <5ddrbs$9m0@shadow.CSUFresno.EDU>#1/1

In article <5dc8ci$ju2$1_at_proxy01.iafrica.com>, Denver Schouw <Denver.Schouw_at_Baps.com> wrote:
>hi
>
>if the 'parsed statement' in dbms_sql.parse is a function call that returns a
>value,how do i retreive this value?

You need to use:

  dbms_sql.bind_variable
  dbms_sql.execute
  dbms_sql.variable_value

Steve Cosner Received on Fri Feb 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US