这是indexloc提供的服务,不要输入任何密码
Skip to content

ErrorORA-24374 when inserting or deleting data #15

@hasan3ysf

Description

@hasan3ysf

Hi..
I tried the below code as INSERT INTO sql statement, it was executed, and added, but the program gave the error below and the DART app had been stopped, and single statement after this line had been executed.

same thing happened when I replaced this statement by "DELETE" SQL statement.

  var resultset = oracleConnection.select("INSERT INTO myVendors (vendor_id, vCode, vName,vEmail) values (6,'205','hasan','hasan@hasan-test.com')");
  resultset.next();

Unhandled exception:
Uncaught Error: ORA-24374: define not done before fetch or execute and fetch

Stack Trace:
#0 _OracleResultset.next (package:oracledart/oracledart_synchronous_extension.dart:103:44)
#1 main. (file:///D:/fonixAgile/production/server/web/insert.dart:16:21)
#2 _RootZone.runUnary (dart:async/zone.dart:1082)
#3 _Future._propagateToListeners.handleValueCallback (dart:async/future_impl.dart:488)
#4 _Future._propagateToListeners (dart:async/future_impl.dart:571)
#5 _Future._complete (dart:async/future_impl.dart:317)
#6 Future.Future. (dart:async/future.dart:118)
#7 Timer._createTimer. (dart:async-patch/timer_patch.dart:12)
#8 _handleTimeout (dart:io/timer_impl.dart:292)
#9 _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:122)
#0 _rootHandleUncaughtError. (dart:async/zone.dart:820)
#1 _asyncRunCallbackLoop (dart:async/schedule_microtask.dart:41)
#2 _asyncRunCallback (dart:async/schedule_microtask.dart:48)
#3 _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:126)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions