RE: DBMS_SQL

Thank Srini, you're right.

-----Original Message-----
From: Srinivasan Subramanian kandallu
[mailto:srinivasan.kandallu_at_wipro.com]
Sent: Saturday, July 15, 2000 12:14 PM
To: Multiple recipients of list ORACLE-L Subject: 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-----
Alves
Sent: Friday, July 14, 2000 8:26 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I=B4m facing a problem with dbms_sql in release 8.0.4. I=B4ve to parse = a
statement that are longer than 4000 characters, so varchar2 can=B4t = accept
this. I supose for this case, i might create another type base on a = table
type, but i don=B4t 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).

--=20
Author: Srinivasan Subramanian kandallu
  INET: srinivasan.kandallu_at_wipro.com

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).