RE: DBMS_SQL

Hi Jorge,

        U have confused PL/SQL varchar2 datatype with Oracle VARCHAR2 column datatype.
You can store upto 32K characters in a PL/SQL varchar2 variable!

Srini

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jorge Luiz Alves
Sent: Friday, July 14, 2000 8:26 PM
To: Multiple recipients of list ORACLE-L Subject: DBMS_SQL

Hi all,

Iīm facing a problem with dbms_sql in release 8.0.4. Iīve to parse a statement that are longer than 4000 characters, so varchar2 canīt accept this. I supose for this case, i might create another type base on a table type, but i donīt know how to use this way. Please, Could someone tell me if this is correct way and give a short example.

Thank you in advance,

Jorge Alves.

--
Author: Jorge Luiz Alves
  INET: jalves_at_mdic.gov.br

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).