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

There is a small example on my website of using the dbms_sql package with a
'dbms_sql.varchar2s' input which is actually an array of varchar2(256) declared as a type in the dbms_sql package.

I forget which version of Oracle this first appeared in, but I don't think it was in the very early versions of 7.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Martin Anderson wrote in message ...
>
>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
>
Received on Thu Jun 10 1999 - 13:30:43 CDT