Dear DBA Gurus,
I have a .sql file which contains a series of insert statements. I want to
call this .sql file and run it from a stored procedure. Is it possible? If
so, how?
Please post your answers to me directly as I am not receiving messages
directly from the list rather
Use UTL_FILE to read your .sql file, and then execute your sql-statements
using dynamic sql (DBMS_SQL or 'EXECUTE IMMEDIATE').
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: