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-38472: VARCHAR representation of the data item is too long.

1 Answers  


SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion

1 Answers  


TNS-12676: Server received internal error from client

1 Answers  


ORA-19322: An error occurred while reading from host (string): port (string)

1 Answers  


ORA-00150: duplicate transaction ID

1 Answers  






ORA-23477: unable to alter propagation mode for object group "string"."string"

1 Answers  


ORA-12450: LOB datatype disabled in LBAC initialization file

1 Answers  


ORA-26724: only SYS is allowed to set the Capture or Apply user to SYS.

1 Answers  


ORA-22630: attribute [string] is null or it is not well-formed

1 Answers  


ORA-01352: tablespace given for Logminer spill does not exist

1 Answers  


PCB-00105: Included file name "string" exceeds name limit of number characters

1 Answers  


NNL-00011: no server with name "string" exists

1 Answers  


Categories