[SQL] Prepared query ?

[Dinesh Pandey]

How can I Write a prepared query and Set values at run time and 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