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


PCB-00557: USING clause can only be used on a PREPAREd
dynamic statement



PCB-00557: USING clause can only be used on a PREPAREd dynamic statement..

Answer / guest

Cause: A severe semantics error occurred because the USING
clause was used with the OPEN cursor statement and the
cursor declaration is not for a PREPAREd statement. The
correct sequence of statements should be like: EXEC SQL
prepare sv from :sel_stmt END-EXEC. EXEC SQL declare csv
cursor for sv END-EXEC. EXEC SQL open csv USING :hv1, :hv2
END-EXEC.

Action: Use the prepare statement for the sql statement and
use that in the declare cursor statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00404: Convert file not found: 'string'

1 Answers  


ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers  


RMAN-06478: WARNING: datafile copy 'string' cannot be found on disk

1 Answers  


ORA-30349: specified dimension hierarchy does not exist

1 Answers  


RMAN-08016: channel string: starting datafile backupset restore

1 Answers  






ORA-07237: slemcl: invalid file handle, seals do not match.

1 Answers  


RMAN-06082: datafilecopy tag string is ambiguous

1 Answers  


RMAN-12001: could not open channel string

1 Answers  


ORA-13604: The specified parameter string cannot be fetched as a SQL table.

1 Answers  


ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

1 Answers  


RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


ORA-02464: Cluster definition can not be both HASH and INDEX

1 Answers  






Categories