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

ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-12677: Authentication service not supported by database link

1 Answers  


PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed for "string"

1 Answers  


ORA-15008: cannot drop system template

1 Answers  


ORA-29292: file rename operation failed

1 Answers  


ORA-39077: unable to subscribe agent string to queue "string"

1 Answers  


DRG-11524: primary key value is missing

1 Answers  


ORA-15123: ASM file name 'string' contains an invalid incarnation number

1 Answers  


ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index

1 Answers  


ORA-37006: (AWLISTALL04) number writers

1 Answers  


RMAN-06078: the controlfile is older than datafile string

1 Answers  


ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP

1 Answers  


Categories