PLS-00215: String length constraints must be in range (1 ..
32767)

Answers were Sorted based on User's Feedback



PLS-00215: String length constraints must be in range (1 .. 32767)..

Answer / udayabhaskar

i dont know .but its important for me

Is This Answer Correct ?    0 Yes 0 No

PLS-00215: String length constraints must be in range (1 .. 32767)..

Answer / guest

Cause: When a character variable was declared, a length
outside the legal range was specified. For example, the
following declarations are illegal: flag CHAR(0); --
illegal; zero length name VARCHAR2(-10); -- illegal;
negative length

Action: Change the length constraint, making sure that it
lies in the range 1 .. 32767.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13908: Invalid combination of metrics id and object type parameters.

1 Answers  


PLS-00551: character set ANY_CS is only allowed on a subprogram parameter

1 Answers  


ORA-29543: Java command string not yet implemented

1 Answers  


ORA-16595: NetSlave process string failed to terminate

1 Answers  


ORA-06037: NETDNT: connect failed, node unreachable

1 Answers  






ORA-38958: Source platform string is in different byte order than target platform string

1 Answers  


ORA-08003: sequence string.NEXTVAL exceeds internal limits

1 Answers  


NNL-00525: Shows or sets the server's default-forwarding status

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


PCC-00014: Undeclared SQL Identifier "string" at line number in file string

1 Answers  


RMAN-06547: tablespace SYSTEM cannot be excluded from whole database backup

1 Answers  


ORA-39097: Data Pump job encountered unexpected error string

1 Answers  


Categories