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-12636: Packet send failed

2 Answers  


TNS-01405: Host: string

1 Answers  


DRG-11847: Revalidation Failed

1 Answers  


ORA-25214: cannot specify delay or expiration for enqueue to exception queue

1 Answers  


ORA-28583: remote references are not permitted during agent callbacks

1 Answers  






ORA-28292: No Domain Policy registered for Kerberos based authentication

1 Answers  


ORA-04030: out of process memory when trying to allocate string bytes (string,string)

1 Answers  


ORA-38952: Source database not 10.0.0.0 compatible

1 Answers  


QSM-02081: mv log does not have all necessary columns

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


DRG-11304: function-based indexes are not supported by this indextype

1 Answers  


TNS-01180: Missing listener object string in Directory Server

1 Answers  


Categories