PLS-00125: type name expected



PLS-00125: type name expected..

Answer / guest

Cause: When a constant or variable was declared, its
datatype was not specified. For example, the code might look
like pi CONSTANT := 3.14159; -- should be CONSTANT REAL :=
3.14159 Every constant and variable must have a datatype,
which specifies a storage format, constraints, and valid
range of values.

Action: Supply the type name

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01080: error in shutting down ORACLE

1 Answers  


ORA-01676: standby file name convert of 'string' exceeds maximum length of string

1 Answers  


PLS-00604: aggregate function is not allowed here

1 Answers  


ORA-27037: unable to obtain file status

1 Answers  


ORA-16181: SGA specified for Logical Standby is too large

1 Answers  






ORA-29393: user string does not exist or is not logged on

1 Answers  


ORA-23496: can not change disabled status for "string" and "string"

1 Answers  


ORA-23384: replication parallel push string argument out of range

1 Answers  


ORA-06265: NETNTT: break protocol error

1 Answers  


NID-00104: Need to specify TARGET connection parameter in command line

1 Answers  


ORA-32020: SID=* clause needed to modify this parameter

1 Answers  


PCC-00036: No input file name specified

1 Answers  


Categories