Re: PL/SQL - Parsing a dynamic cursor > 2000 chars...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 10 Jun 1999 18:33:21 GMT
Message-ID: <377101d9.26436073@newshost.us.oracle.com>

A copy of this was sent to sooty70_at_hotmail.com (Martin Anderson) (if that email address didn't require changing) On Thu, 10 Jun 1999 10:06:45 -0800, you wrote:

>Hi folks,
>
>I'm up *that* creek right now and I need some of your help.
>
>I wish to code a DBMS_SQL.PARSE statement that uses multiple
>strings totalling more than 2000 bytes. I read something about
>this in the dbmssql.sql file re: the PL/SQL statement table(?)
>but have no clue how to do it. I also looked through all the docs
>
>I have and the App Dev Guide gives examples but none like this.
>
>Thanks for your help,
>
>Martin
>
>
>
> -**** Posted from RemarQ, http://www.remarq.com/?c ****-
> Search and Read Usenet Discussions in your Browser

see

http://www.deja.com/[ST_rn=ps]/getdoc.xp?AN=320687760&fmt=text

btw: the limit is 32k not 2,000 bytes...

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jun 10 1999 - 13:33:21 CDT