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-32135: Cannot assign FILEs

1 Answers  


PROC-00015: Failed to initialize the cluster registry successfully

1 Answers  


ORA-07550: sftopn: $CONNECT failure

1 Answers  


ORA-23605: invalid value "string" for STREAMS parameter string

1 Answers  


ORA-19628: invalid SCN range

1 Answers  


NNC-00418: name "string" cannot be modified because it has children

1 Answers  


ORA-01343: LogMiner encountered corruption in the logstream

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


ORA-16098: inaccessible standby database forced shutdown to protect primary

1 Answers  


PLS-00647: attribute by name "string" conflicts with method by same name

1 Answers  


TNS-00524: Current operation is still in progress

1 Answers  


RMAN-06086: offline files may only be skipped in a datafile backup set

1 Answers  


Categories