Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting text of SQL-Satement (ProC)
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
![]() |
![]() |