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

ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause

1 Answers  


ORA-16585: illegal operation on a primary site

1 Answers  


NZE-28865: SSL connection closed

1 Answers  


ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  


PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used

1 Answers  






NNO-00334: region load failure: ROS admin_region type number unsupported

1 Answers  


ORA-12638: Credential retrieval failed

1 Answers  


ORA-16030: session specific change requires a LOG_ARCHIVE_DEST_n destination

1 Answers  


ORA-10566: Test recovery has used all the memory it can use

1 Answers  


TNS-01076: Opened trace file: string

1 Answers  


ORA-19773: must specify change tracking file name

1 Answers  


ORA-28271: No permission to read user entry in LDAP directory service.

1 Answers  


Categories