I have to run a procedure in one go with different value passed to it in multiple session.
I was doing a small POC on same, but i see the below behave weird, first time it created 5 job and inserted data to table 5 records , but when i again ran the same block the job where in dba_jobs table and never inserted the data .
I saw the inconsistent behaviour.
Can you guide me the best way to achieve the below
create table log_t ( a number, b varchar2(100), c varchar2(1000), d number);
create or replace procedure pr_test(a number)
insert into log_t(a) values ( 1);
v_session_no number := 5;
for i in 1..v_session_no loop
[Updated on: Fri, 29 November 2013 10:31]
Report message to a moderator