PCC-00137: Invalid use of SQL cursor host variable



PCC-00137: Invalid use of SQL cursor host variable..

Answer / guest

Cause: A SQL_CURSOR variable was used in an INTO or WHERE
clause. SQL_CURSOR variables can be used only where ordinary
cursor identifiers would be used or, in a PL/SQL block,
where a cursor would normally be used.

Action: Remove the SQL cursor variable reference from the
INTO clause or WHERE clause, or use a host variable of
another type in the INTO or WHERE clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32736: Hang analysis aborted due to wrong message type

1 Answers  


ORA-12710: CREATE CONTROLFILE character set is not known

1 Answers   Orange,


TNS-01158: Internal connection limit reached, preventing dispatcher from connecting

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


ORA-00235: controlfile fixed table inconsistent due to concurrent update

1 Answers  


PLS-00622: range constraints must be between -2147483647 and 2147483647

1 Answers  


PCC-00039: Unable to open input file "string"

1 Answers  


ORA-01673: data file string has not been identified

1 Answers  


ORA-06781: TLI Driver: error reading negotation string

1 Answers  


SQL*Loader-00504: Error skipping records in file (string)

1 Answers  


PCC-02434: FOR clause not permitted in any LOB statement

1 Answers  


NNO-00117: line string: missing data type, data ignored

1 Answers  


Categories