There are two PARSE procedures .... once is with a VARCHAR2 statement which
effectively limits you to 2000 bytes limit (lower in multi-byte char set).
If you need a larger space, use the PARSE statement with VARCHAR2S
parameter, this will allow you a pretty large statement. Now you may ask
"What is VARCHAR2S?", well it is basically a pl/sql table of varchar2(256),
i.e. you'd build your SQL as a chunk of 256 bytes and assign them to a row
of this pl/sql table. It works pretty well, I have been using it for some
time now. More details are in the $ORACLE_HOME/rdbms/admin/dbmssql.sql file
or in Application Developer's Guide or in one of the many books on the
market.
Please note that when you use PARSE with a pl/sql table, the syntax is
slightly different.
Received on Tue May 30 2000 - 10:13:01 CDT
