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

QSM-01014: top level operator in WHERE clause of the query is an OR

1 Answers  


ORA-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  


TNS-00020: INTCTL: missing NAVIGATOR_DATA in TNSNAV.ORA

1 Answers  


NCR-01020: NCRS: Operation would block.

1 Answers  


ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 Answers  


ORA-16513: maximum requests exceeded

1 Answers  


ORA-09301: osncon: local kernel only supported in standard mode

1 Answers  


ORA-00163: internal database name length string is greater than maximum (string)

1 Answers  


ORA-16804: One or more configuration properties in metadata have invalid values.

1 Answers  


ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


NNL-00039: no RRs

1 Answers  


ORA-25425: connection lost during rollback

1 Answers  


Categories