ORA-24787: remote cursors must be closed before a call completes

Cause : The prveious oeprationd id notc lose all the rmeote cusrors ito pened.S ince spearatedt ransacitons ar eenable,d this si not allowed.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Close lal remoet cursosr in eahc call,o r star ta regualr (nons-eparatde) tranasction.

update : 21-08-2017
ORA-24787

ORA-24787 - remote cursors must be closed before a call completes
ORA-24787 - remote cursors must be closed before a call completes

  • ora-02758 : Allocation of internal array failed
  • ora-14553 : cannot perform a lob write operation inside a query
  • ora-14402 : updating partition key column would cause a partition change
  • ora-27037 : unable to obtain file status
  • ora-19639 : file string is more current than this incremental backup
  • ora-19570 : file number string is outside valid range of 1 through string
  • ora-31025 : Invalid document element
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-06041 : NETDNT: disconnect failed
  • ora-28592 : agent control utility: agent SID not set
  • ora-26764 : invalid parameter "string" for local capture "string"
  • ora-30052 : invalid lower limit snapshot expression
  • ora-06267 : NETNTT: bad state
  • ora-27302 : failure occurred at: string
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-12216 : TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
  • ora-22916 : cannot do an exact FETCH on a query with Nested cursors
  • ora-27542 : Failed to unprepare a buffer prepared for remote update
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-09749 : pws_look_up: port lookup failure
  • ora-19020 : invalid dereference of XMLType columns
  • ora-13300 : single point transform error
  • ora-38766 : cannot flashback data file string; file resized smaller
  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-23470 : invalid status
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.