sql - How to get ROWID when inserting into table using FORALL and RETURNING -


i rowid of inserted record using returning clause forall insert statement (bulk insert) pl/sql table of records (associative array of records). believe, problem in using table of records in forall , bulk collect together.

see example:

create table test2 (num number); set serveroutput on  declare   type r_rec record (num number, row_id rowid); --  type t_rid table of rowid index binary_integer;   type t_tab table of r_rec index binary_integer;   v_tab     t_tab;   --v_rid     t_rid; begin   v_tab(1).num := 1.11;   v_tab(2).num := 2.22;   v_tab(3).num := 3.33;   --   forall in v_tab.first..v_tab.last     insert test2 (num)     values (v_tab(i).num)     returning rowid bulk collect v_tab(i).row_id   ;   in v_tab.first..v_tab.last   loop      dbms_output.put_line('num/rowid : ' || v_tab(i).num || '/' || v_tab(i).row_id);   end loop; end; /

it raises error: pls-00437: forall bulk index cannot used in returning clause problem here? need pl/sql table returning rowids?

do need pl/sql table returning rowids?

yes ..you can try below: need collection hold return of rowids since "forall bulk index cannot used in returning clause"

declare   type r_rec record (num number, row_id rowid);    type t_tab table of r_rec index binary_integer;   v_tab     t_tab;    type r_rw table of rowid index pls_integer;    v_rw r_rw;  begin   v_tab(1).num := 1.11;    v_tab(2).num := 2.22;    v_tab(3).num := 3.33;    --   forall in v_tab.first..v_tab.last     insert test2 (num)     values (v_tab(i).num)     returning rowid bulk collect v_rw;    in v_tab.first..v_tab.last   loop      dbms_output.put_line('num/rowid : ' || v_tab(i).num || '/' ||v_rw(i));   end loop;  end; /

Comments

Post a Comment

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

hi i'm using ngfor create set of 3 slides while starting in middle i'm guaranteed able slide left or right on start. when slide right can simple listen reachedend , push slide array i'm looping. but have problem adding slide beginning. if same above , use e.g. array.unshift() or spread add item beginning, view think it's on position 0 , snaps view new slide. the code below work animates slide change index 1. slide = [0,1,2] //example loop slidechanged(event) { if(this.slides.isbeginning()){ this.slide = [this.slide[0]-1, ...this.slide]; this.slides.update(); this.slides.slideto(1) } } <ion-slides [initialslide]="1" (ionslidedidchange)="slidechanged($event)"> <ion-slide *ngfor="let item of slide"> <h1>slide {{item}}</h1> </ion-slide> </ion-slides> any appreciated! you can using ionslidenextend , ionslideprevend events slides . please...
Read more

Add a dynamic header in angular 2 http provider -

i have http interceptor built via tutorial https://scotch.io/@kashyapmukkamala/using-http-interceptor-with-angular2 the problem need have dynamic header changes automatically once changes 'mode' in app. service able tell interceptor change header, or have interceptor pull header (which string)from service each request. able throwing away patch method, call http.patch('new header string') set header string. call in service controls 'mode' setting. wondering if there way interceptor pull recent value service each request or if can add method http provider via interceptor? i've tried call service in interceptor each request returns undefined. because creating new instance of service or copying value before service fired , loaded/changed data. i don't want pass header string every http provider call because defeats purpose of having interceptor, id able set once changes or have provider fetch service before makes request. tl;dr : need add autom...
Read more

minify - Minimizing css files -

i want know how css files can minimized. currently, using external sites css minifier compress css files. however, after removing whitespaces, comments, etc, file sizes reduced 10-15%. how frameworks bootstrap manage make minimized versions kilobytes. as example, css is: body { background-color: #ff0; } the reduction goes 28 bytes 22 bytes other css files have lot more characters still smaller this. actually minifying code means it's remove thing code white space characters new line characters comments block delimiters it reduces amount of code has transferred on web , speed site load fastly.but unreadable format.
Read more