Hi,
In a PLSQL Varchar variable declaration, we can go upto varchar2
(4000) whereas in a table declaration, it can be upto varchar2
(2000).
For your information...
Regards
Rajagopal Venkataramany
On Sat, 15 Jul 2000 13:43:57 -0800, ORACLE-L_at_fatcity.com wrote:
> Thank Srini, you're right.
> =20
> -----Original Message-----
> [mailto:srinivasan.kandallu_at_wipro.com]
> Sent: Saturday, July 15, 2000 12:14 PM
> To: Multiple recipients of list ORACLE-L
> =20
> =20
> Hi Jorge,
> =09U have confused PL/SQL varchar2 datatype with Oracle VARCHAR2
> column
> datatype.
> You can store upto 32K characters in a PL/SQL varchar2 variable!
> =20
> Srini
> =20
> =20
> -----Original Message-----
> Alves
> Sent: Friday, July 14, 2000 8:26 PM
> To: Multiple recipients of list ORACLE-L
> =20
> =20
> Hi all,
> =20
> 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 acce=
pt
> this. I supose for this case, i might create another type base on a tabl=
e
> 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.
> =20
> =20
> Thank you in advance,
> =20
> =20
> Jorge Alves.
> =20
> --
> Author: Jorge Luiz Alves
> INET: jalves_at_mdic.gov.br
> =20
> 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
> --=20
> Author: Srinivasan Subramanian kandallu
> INET: srinivasan.kandallu_at_wipro.com
> =20
> 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).
> --
> Author: Jorge Luiz Alves
> INET: jalves_at_mdic.gov.br
> =20
> 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).
Regards
Rajagopal Venkataramany
Received on Sun Jul 16 2000 - 21:26:17 CDT
