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

DRG-50923: could not rewrite PL/SQL for execution

1 Answers  


ORA-01782: UNRECOVERABLE cannot be specified for a cluster or clustered table

1 Answers  


ORA-35578: (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF <cursor name> syntax

1 Answers  


ORA-25129: cannot modify constraint (string) - no such constraint

1 Answers  


ORA-38504: this operator not allowed with the configured attribute set

1 Answers  






ORA-16808: unable to resolve the full path name

1 Answers  


RMAN-08182: channel string: validation complete, elapsed time: string

1 Answers  


SQL*Loader-00253: DB2 partition number has no significance -- ignored

1 Answers  


ORA-06407: NETCMN: unable to set up break handling environment

1 Answers  


PLS-01713: The constraints on these types do not match

1 Answers  


ORA-13292: incorrect ARC_TOLERANCE specification

1 Answers  


ORA-29336: Internal error [string] [string] from DBMS_PLUGTS

1 Answers  


Categories