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

NZE-28829: no cipher type specified

1 Answers  


ORA-23368: name string cannot be null or the empty string

1 Answers  


ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

1 Answers  


ORA-01279: db_files too large

1 Answers  


DRG-50936: query word string is too complex for index

1 Answers  






ORA-36684: (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object

1 Answers  


LFI-01514: ftell() failed in string

1 Answers  


ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero

1 Answers  


RMAN-06717: number of source files (string) and destination files (string) does not match

1 Answers  


ORA-01933: cannot create a stored object using privileges from a role

1 Answers  


ORA-01110: data file string: 'string'

1 Answers  


ORA-32022: parameter value longer than string characters

1 Answers  


Categories