Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PCC-02445: USING clause valid only on a PREPAREd dynamic
statement



PCC-02445: USING clause valid only on a PREPAREd dynamic statement..

Answer / guest

Cause: The USING clause was used with an OPEN cursor
statement where the cursor declaration was not for a
PREPAREd statement. The correct sequence of statements
should be as follows EXEC SQL PREPARE s FROM :stmt; EXEC SQL
DECLARE c CURSOR FOR s; EXEC SQL OPEN c USING ...;

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

QSM-01105: no primary key or row id in MV, string, is found for table, string

1 Answers  


NZE-28783: invalid parameter

1 Answers  


ORA-02752: osnfsmmap: illegal shared memory address

1 Answers  


ORA-40271: no statistically significant features were found

1 Answers  


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

1 Answers  


NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 Answers  


ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

1 Answers  


ORA-29321: too many datafiles added since the point-in-time

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


ORA-38954: Cross platform transport is not supported between source platform identifier string and target platform identifier string

1 Answers  


QSM-01126: query rewritten with set operator materialized view, string

1 Answers  


ORA-31512: name cannot contain double quotation marks

1 Answers  


Categories