Home » SQL & PL/SQL » SQL & PL/SQL » DATATYPE HAVING STRING LENGTH MORE THAN 50000
DATATYPE HAVING STRING LENGTH MORE THAN 50000 [message #407006] Mon, 08 June 2009 02:57 Go to next message
arjunyadav
Messages: 15
Registered: September 2008
Junior Member
Hi All,
I am using an out variable P_error_messgae of varchar2 in my procedure.
But in this variable I am assigning error messages having length more than 50000 charecters.Oracle is giving error that String length constraints must be n range(1....32767)

What is other datatype in which I can assign the error messages having length charecters more than 50000.


Thanks
Arjun
Re: DATATYPE HAVING STRING LENGTH MORE THAN 50000 [message #407014 is a reply to message #407006] Mon, 08 June 2009 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not post your title in UPPER case.
Please read OraFAQ Forum Guide

Database SQL Reference
Chapter 2 Basic Elements of Oracle SQL
Section Datatypes
Paragrah CLOB Datatype

Regards
Michel
Re: DATATYPE HAVING STRING LENGTH MORE THAN 50000 [message #407015 is a reply to message #407006] Mon, 08 June 2009 03:06 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database PL/SQL User's Guide and Reference
Chapter 3 PL/SQL Datatypes
Section Overview of Predefined PL/SQL Datatypes
Paragraph PL/SQL LOB Types

Regards
Michel
Previous Topic: grant unlimited tablespace
Next Topic: Scheduler not running for users other than sys
Goto Forum:
  


Current Time: Mon Dec 05 10:49:22 CST 2016

Total time taken to generate the page: 0.12192 seconds