Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-08529: proxy file handle=string

1 Answers  


ORA-06117: NETTCP: unable to create ORASRV: quota exceeded

1 Answers  


ORA-08179: concurrency check failed

1 Answers  


RMAN-10018: error cleaning up channel context

1 Answers  


ORA-01928: GRANT option not granted for all privileges

1 Answers  






ORA-02723: osnpui: cannot send break signal

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


ORA-00364: cannot write header to new log member

1 Answers  


ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

1 Answers  


ORA-31691: The worker received message number string from the MCP, which is invalid.

1 Answers  


NPL-00305: unsupported ASN.1 "UNIV" type string

1 Answers  


ORA-12052: cannot fast refresh materialized view string.string

1 Answers  






Categories