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-24803: illegal parameter value in lob read function

1 Answers  


AMD-00124: dimension #string: analytic workspace GID variable not specified

1 Answers  


CLSR-00530: Can not get user name

1 Answers  


TNS-01108: Listener password prompt failed

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  






KUP-04019: illegal length found for VAR record in file string

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


ORA-00228: length of alternate controlfile name exceeds maximum of string

1 Answers  


IMG-00551: invalid quantize method specified

1 Answers  


ORA-12718: operation requires connection as SYS

1 Answers  


ORA-22813: operand value exceeds system limits

1 Answers  


TNS-00258: Number of Failed Requests : number

1 Answers  


Categories