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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting text of SQL-Satement (ProC)

Re: Getting text of SQL-Satement (ProC)

From: <tjmxyz_at_my-deja.com>
Date: Thu, 30 Sep 1999 07:21:14 GMT
Message-ID: <7sv314$g7k$1@nnrp1.deja.com>


Use the ALL_SOURCE View...
eg..
SELECT TEXT FROM ALL_SOURCE WHERE NAME='FOO'; In article <37F20BFC.EE2953E7_at_fun.de>,
  Thomas Rieffel <thomasr_at_fun.de> wrote:
> This is a multi-part message in MIME format.
> --------------99D97607D9B9423DCEDE2C4F
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> Hallo,
>
> I´m running Oracle8.05 on Solaris and I want to use the function
> sqlgls(char *sqlstm, size_t *stmlen, size_t *sqlfc);
> to get the text of the SQL-Function, that I send with ProC to Oracle.
>
> What library must I link to my programm that it works or is there an
> other way to get the Text of the Statement ?
>
> Thanks,
>
> Thomas Rieffel
> --------------99D97607D9B9423DCEDE2C4F
> Content-Type: text/x-vcard; charset=us-ascii;
> name="thomasr.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Thomas Rieffel
> Content-Disposition: attachment;
> filename="thomasr.vcf"
>
> begin:vcard
> n:Rieffel;Thomas
> tel;fax:+49 721 96448-22
> tel;work:+49 721 964480
> x-mozilla-html:FALSE
> adr:;;;;;;
> version:2.1
> email;internet:Thomasr_at_fun.de
> fn:Thomas Rieffel
> end:vcard
>
> --------------99D97607D9B9423DCEDE2C4F--
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 02:21:14 CDT

Original text of this message

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