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


PLS-00455: cursor 'string' cannot be used in dynamic SQL
OPEN statement



PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement..

Answer / guest

Cause: dynamicly OPEN a REF CURSOR that has RETURN type.
However, only REF CURSOR without RETURN type can be OPEN'ed
by an embebded dynamic OPEN statement.

Action: define a REF CURSOR without return type, and use it
in the statement.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


ORA-24431: Statement does not exist in the cache

1 Answers  


ORA-16794: Database Guard is ON for primary database

1 Answers  


ORA-12404: invalid privilege string: string

1 Answers  


ORA-16724: the intended state for the database has been set to OFFLINE

1 Answers  


ORA-01873: the leading precision of the interval is too small

1 Answers  


NNL-00806: Queries received, type RELATED-INFO: number

1 Answers  


LPX-00125: duplicate entity "~S" (ignored)

1 Answers  


PCC-00065: Userid required, but not specified.

1 Answers  


ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

1 Answers  


Categories