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
akull82
Messages: 3
Registered: May 2007
Junior Member
Hi,

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 ?

Thx,
Andre
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"

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8784259916366
http://sheikyerbouti.developpez.com/collections/collections.htm
http://www.oracle-base.com/articles/10g/DmlErrorLogging_10gR2.php
Previous Topic: Function & Procedure
Next Topic: coalesce puzzle
Goto Forum:
  


Current Time: Fri Dec 09 04:02:12 CST 2016

Total time taken to generate the page: 0.06693 seconds