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-12025: materialized view log on "string"."string" already has primary keys

1 Answers  


LPX-00237: invalid condition section keyword, must be INCLUDE or IGNORE

1 Answers  


ORA-12558: TNS:protocol adapter not loaded

1 Answers  


NID-00504: LOGFILE Output Log (NONE)

1 Answers  


ORA-39039: Schema expression "string" contains no valid schemas.

1 Answers  






PLS-00320: the declaration of the type of this expression is incomplete or malformed

1 Answers  


ORA-01764: new update value of join is not guaranteed to be unique

1 Answers  


ORA-01140: cannot end online backup - all files are offline or readonly

1 Answers  


TNS-00034: INTCTL: internal NR error

1 Answers  


ORA-26090: row is in partial state

1 Answers  


NZE-29249: an unrecognized state was passed to a cryptographic function

1 Answers  


ORA-24081: compatible parameter needs to be string or greater

1 Answers  


Categories