How can I
1. Write a prepared query and
2. Set values at run time and
3. Execute that query for different values.
LOOP
...
...
sql := INSERT INTO MYTABLE VALUES(?, ?);
..
--EXECUTE (sql);
END LOOP;
Regards
Dinesh Pandey
----------------------------------------------------------------------------
------
Dinesh Pandey
Sr. Software Engineer
Second Foundation (India) Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O) 0172-2639202, Extn: 233