
March 11th, 2004, 05:50 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
insert problem in oracle
Hi everyone!!
I am doing a project using designer 6i and web pl/sql,I am facing few problem as I have written a procedure which in a for loop calls another procedure to insert into a table,I am trying to insert two fields into a table but whats happening is its insert only few records and its skipping like if I say insert 5 /10 records,the number of records to insert will be know from number of checkboxes the user as checked,
out of 5 /10 it inserts only 3/8 or won't insert any,if I check it by giving a alert message it works fine,the for loop is in javascript function.
basically I feel it is needing some time to insert,
I am want to know is it problem anywhere or is oracle takes time to insert just 1 or 2 records
I tried to insert into a dummy table in a for loop, I observed few records were skipped
can anybody tell me the reason for this
and solution to my problem
|