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

PCB-00579: Invalid ARRAYLEN length variable type for "string"

1 Answers  


ORA-23300: %s

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  


RMAN-05512: tablespace string cannot be skipped from duplication

1 Answers  


ORA-12014: table 'string' does not contain a primary key constraint

1 Answers  






ORA-19710: unsupported character set string

1 Answers  


ORA-32622: illegal multi-cell reference

1 Answers  


PCB-00237: Declaration of "string" cannot have a level number greater than 48

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


ORA-12540: TNS:internal limit restriction exceeded

1 Answers  


ORA-13761: invalid filter

1 Answers  


PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

1 Answers  


Categories