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

LSX-00156: type is final and no derivations are allowed

1 Answers  


ORA-13418: null or invalid parameter(s) for set functions

1 Answers  


ORA-16644: apply instance not available

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


ORA-00476: RECO process terminated with error

1 Answers  






ORA-30186: '' must be followed by four hexdecimal characters or another ''

1 Answers  


ORA-37000: (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.

1 Answers  


DRG-50916: last document string is less than first document

1 Answers  


NNO-00712: warning: group string cache checkpoint failed

1 Answers  


ORA-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.

1 Answers  


ORA-26507: null master connection

1 Answers  


ORA-02220: invalid MINEXTENTS storage option value

1 Answers  


Categories