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

IMG-00546: invalid page number specified

1 Answers  


ORA-24311: memory initialization failed

1 Answers  


ORA-16209: Logical standby dictionary build failed to complete.

1 Answers  


NNO-00300: no listen addresses specified, at least one is required

1 Answers  


ORA-26027: unique index string.string partition string initially in unusable state

0 Answers   MeritTrack,


ORA-32101: cannot create OCI Environment

1 Answers  


SQL-02111: Heap consistency error

1 Answers  


TNS-01107: A valid trace level was not specified

1 Answers  


ORA-24808: streaming of lob data is not allowed when using lob buffering

1 Answers  


ORA-25127: RELY not allowed in NOT NULL constraint

1 Answers  


ORA-28101: policy already exists

1 Answers  


PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE

1 Answers  


Categories