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...


SQL-02117: Invalid SQL Cursor usage: trying to OPEN an
OPENed cursor



SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor..

Answer / guest

Cause: An attempt was made to OPEN a cursor that was already
OPENed with MODE={ANSI|ANSI14|ANSI13}. An open cursor can be
re-OPENed only when MODE=ORACLE.

Action: When MODE={ANSI|ANSI14|ANSI13}, verify that a cursor
is not already OPENed before trying to OPEN it. Specify
MODE=ORACLE if an OPENed cursor is to be re-OPENed.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23603: STREAMS enqueue aborted due to low SGA

1 Answers  


ORA-28180: multiple authentication methods provided by proxy

1 Answers  


ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers  


PCC-02319: expression type does not match usage

1 Answers  


ORA-18004: outline already exists

1 Answers  


PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object

1 Answers  


ORA-38712: Corrupt flashback log record header: block string, offset string.

1 Answers  


TNS-01008: version [<listener_name>] : get the version information of the listener

1 Answers  


DRG-12604: execution of user datastore procedure has failed

1 Answers  


ORA-40262: NMF: number of features not between [1, string]

1 Answers  


ORA-21522: attempted to use an invalid connection in OCI (object mode only)

1 Answers  


Categories