Home » SQL & PL/SQL » SQL & PL/SQL » dbms_sql and save exception
dbms_sql and save exception [message #240044] Thu, 24 May 2007 00:35 Go to next message
Messages: 3
Registered: May 2007
Junior Member

i try to execute an dynamic insert stmt via dbms_sql. the stmt binds an array for bulk operation.
  v_hdl := Dbms_Sql.open_cursor;
  Dbms_Sql.parse( v_hdl, 'insert into cust.andre_forall_test(id) values ( :id ) returning rowid into :r', Dbms_Sql.native );
  Dbms_Sql.BIND_ARRAY( v_hdl, ':id',  v_ids);
  DBMS_SQL.BIND_ARRAY ( v_hdl, ':r', v_row_ids );

  v_ret_val := Dbms_Sql.EXECUTE( v_hdl );

  DBMS_SQL.VARIABLE_VALUE ( v_hdl, ':r', v_row_ids );

Is there any solution to catch all occured exception after the complete array is processed, like the save exception clausel in an forall operation ?

Re: dbms_sql and save exception [message #241512 is a reply to message #240044] Tue, 29 May 2007 17:03 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Search for "exceptions"

Previous Topic: Function & Procedure
Next Topic: coalesce puzzle
Goto Forum:

Current Time: Mon Oct 24 15:15:27 CDT 2016

Total time taken to generate the page: 0.09801 seconds