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


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

LPX-00104: element "~S" is not declared in the DTD

1 Answers  


NNO-00051: domain count number exceeds maximum of number, first number will be loaded

1 Answers  


TNS-01022: Alias string

1 Answers  


ORA-02724: osnpbr: cannot send break message to orapop

1 Answers  


ORA-26034: Column string does not exist in stream

1 Answers  






PCC-00012: Not in a declare section at line number in file string

1 Answers  


ORA-28132: Merge into syntax does not support security policies.

2 Answers  


NZE-28844: No wallet present

1 Answers  


ORA-16567: Data Guard broker internal parser error at "string"

1 Answers  


RMAN-06123: operation not supported without the recovery catalog or mounted controlfile

1 Answers  


ORA-09814: Unable to expand file name

1 Answers  


ORA-01409: NOSORT option may not be used; rows are not in ascending order

1 Answers  






Categories