Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-12024: materialized view log on "string"."string" does not have primary key columns

1 Answers  


ORA-13114: [string]_NODE$ table does not exist

1 Answers  


ORA-25286: Invalid number of elements in the message properties array

1 Answers  


NID-00308: Control File string - dbid changed

1 Answers  


ORA-31435: an error occurred during the purge operation

1 Answers  






PCC-02322: found undefined identifier

1 Answers  


SQL*Loader-00303: Non-hex character encountered where hex char expected

1 Answers  


ORA-16724: the intended state for the database has been set to OFFLINE

1 Answers  


ORA-21501: program could not allocate memory

1 Answers  


ORA-07496: sppst: lm_post failed.

1 Answers  


ORA-07595: sppid: $GETJPIW failure

1 Answers  


ORA-09344: spsig: error signalling thread

1 Answers  






Categories