PLS-00491: numeric literal required



PLS-00491: numeric literal required..

Answer / guest

Cause: A constant or variable was used where a numeric
literal is required. For example, the code might look like
my_ename VARCHAR2(max_len); instead of my_ename
VARCHAR2(15); When specifying the maximum length of a
VARCHAR2 variable, an integer literal must be used.

Action: Replace the identifier with a numeric literal.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore

1 Answers  


PLS-00560: character set mismatch

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  


PLS-00320: the declaration of the type of this expression is incomplete or malformed

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  






ORA-03129: the next piece to be inserted is required

1 Answers  


ORA-31122: The string operator has incorrect RHS value

1 Answers  


ORA-01906: BACKUP keyword expected

1 Answers  


ORA-31035: Could not bind locked resource to path string/string

1 Answers  


ORA-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  


PLS-00491: numeric literal required

1 Answers  


ORA-26091: requested direct path operation not supported

1 Answers  


Categories