hi..

i want to know how to run a file (.sql) inside a pl/sql block statement..

eg: begin
<some command to run sql file> <filename>
end;

i have used execute immediate.. but it executes only one-SQL statement..

pls advice as soon as possible..
regds,
loki