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

PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  


ORA-28291: No Kerberos Principal Value found.

1 Answers  


ORA-08111: a partitioned index may not be coalesced as a whole

1 Answers  


ORA-02718: osnprs: reset protocol error

1 Answers  


DRG-11730: relation does not exist

1 Answers  






EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


ORA-27453: %s is an invalid job or program argument name.

1 Answers  


ORA-28233: double encryption not supported

1 Answers  


NZE-29153: RSA self-test failure

1 Answers  


PCC-00001: Unable to open file string

1 Answers  


NNL-00227: Request-processing delay is currently disabled

1 Answers  


ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string

1 Answers  


Categories