PLS-00330: invalid use of type name or subtype name



PLS-00330: invalid use of type name or subtype name..

Answer / guest

Cause: A datatype or subtype specifier was mistakenly used
in place of a constant, variable, or expression. For
example, the code might look like IF emp_count > number THEN
... -- illegal; NUMBER is a datatype specifier

Action: Replace the datatype or subtype specifier with a
valid constant, variable, or expression.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00206: Status Information for Interchange string:

1 Answers  


ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED

1 Answers  


ORA-29890: specified primary operator does not have an index context

1 Answers  


ORA-12168: TNS:Unable to contact LDAP Directory Server

1 Answers  


ORA-12088: cannot online redefine table "string"."string" with unsupported datatype

1 Answers  






DRG-10845: column string is not indexed

1 Answers  


ORA-29812: incorrect object name specified

1 Answers  


ORA-12661: Protocol authentication to be used

1 Answers  


TNS-04003: Syntax Error.

1 Answers  


ORA-26672: timeout occurred while stopping STREAMS process string

1 Answers  


ORA-16951: Too many bind variables supplied for this SQL statement.

1 Answers  


ORA-26575: remote database does not support replication parallel propagation

1 Answers  


Categories