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-22916: cannot do an exact FETCH on a query with Nested cursors

1 Answers  


ORA-19831: incompatible string.string.string DBMS_BACKUP_RESTORE package: string.string.string required

1 Answers  


LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


ORA-25443: duplicate column value for table alias: string, column number: string

1 Answers  


ORA-24407: connection pool already exists

1 Answers  






NZE-29005: The certificate is invalid.

1 Answers  


ORA-13198: Spatial error: string

1 Answers  


ORA-01568: cannot set space quota on PUBLIC

1 Answers  


LPX-00007: unexpected end-of-file encountered

1 Answers  


ORA-01251: Unknown File Header Version read for file number string

1 Answers  


NNL-00239: Resetting of statistic counters is now disabled

1 Answers  


ORA-06570: shared pool object does not exist, cannot be pinned

1 Answers  


Categories