This is what I wanted to do….
I need to call a simple sql file from a procedure. (
Create or replace procedure call_sql as
For i in 1..100000
If mod(i,1000)=0 then
Inside file1, I have Sql plus commands to spool to file in OS.
Is it possible.If so then how