#cursors

ORA-10270: Debug shared cursors

文档解释ORA-10270:DebugsharedcursorsCause:EnablesdebuggingcodeinsharedcursormanagementmodulesAction:NoneORA-10270:Debugsharedcursors由于系统故障,Oracle数据库无法记录调试版本的共享游标。官方...
IT技术学习 ·2023-07-27

ORA-28554: pass-through SQL: out of cursors

文档解释ORA-28554:pass-throughSQL:outofcursorsCause:Themaximumnumberofopencursorshasbeenexceeded.Action:Closeopencursorsbyusingthepass-throughSQLCLOSE_CURSORfunctio...

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

文档解释ORA-22916:cannotdoanexactFETCHonaquerywithNestedcursorsCause:ExactFETCHonaquerywasspecifiedwhichisnotallowedifthequeryreturnsanycursors.Action:Donotuseanexa...
IT技术学习 ·2023-07-26

ORA-16950: Remote mapped cursors are not supported by this feature.

文档解释ORA-16950:Remotemappedcursorsarenotsupportedbythisfeature.Cause:Thiscursorisaremotemappedcursorwhichcouldnotbeprocessedlocally.Action:Trytoprocessthisstatem...

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

文档解释ORA-24787:remotecursorsmustbeclosedbeforeacallcompletesCause:Thepreviousoperationdidnotclosealltheremotecursorsitopened.Sinceseparatedtransactionsareenabled...

ORA-01042: detaching a session with open cursors not allowed

文档解释ORA-01042:detachingasessionwithopencursorsnotallowedCause:Anattemptwasmadetodetachaseesionwhichhadopencursors.Action:Closeallthecursorsbeforedetachingtheses...

设置open_cursors参数

1、进入终端,输入命令:sqlplus/nolog2、输入命令:conn/assysdba3、输入命令:altersystemsetopen_cursors=1000scope=memory...
代码星球 ·2020-05-23

ora-01000 maximum open cursors exceeded

根本原因在于你打开的cursors(游标),超出了数据库规定的最大值1、通过命令查看数据库限定的最大值:在oracle终端下:sqlplus/nolog2、conn/assysdba;3、showparameteropen_cursor;得到最大值,默认是300解决方法:你在打...