Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-25234: NEXT_TRANSACTION navigation option invalid for queue table string.string

1 Answers  


ORA-24057: cannot define subscriber with rule for queue string

1 Answers  


ORA-09968: scumnt: unable to lock file

1 Answers  


ORA-33460: (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.

1 Answers  


ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

1 Answers  






NNL-00035: File string or nested IFILEs not found.

1 Answers  


PCB-00303: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL

1 Answers  


DRG-11802: Switching Protocols

1 Answers  


CLSR-00522: Resource string is not registered

1 Answers  


NNO-00272: line string; invalid DIT/DN

1 Answers  


ORA-14513: partitioning column may not be of object datatype

1 Answers  


ORA-22309: attribute with name "string" already exists

1 Answers  






Categories