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

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 23:13:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.