Running sql script from stored procedure

2001-08-16 Thread Ranganath K
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

Re: Running sql script from stored procedure

2001-08-16 Thread Igor Neyman
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: