Re: How to execute pl/sql commands stored in a file

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 3 Nov 2004 14:18:00 -0800
Message-ID: <4b5394b2.0411031418.703734e5@posting.google.com>

gmooron_at_yahoo.fr (Gmooron) wrote in message news:<3f784b0f.0411020606.6b5eda1f_at_posting.google.com>...
> Hello
>
> Well, i hope someone could help me ...
> I have some pl/sql commands stored in a .sql file (creation of tables,
> procedures ...)
> And I have to do a pro*c program that execute these commands ...
> How can I do ?
> I've tried "exec sql start file.sql" but I cannot compile ...
>
> Thank you for your help and excuse my English ???
>
> (I know that a solution is to include all these commands in my pro*c
> file but I'd like to keep them in the .sql file if possible ...)

another question to be asked is: why do you want to run DDL commands (e.g. CREATE TABLE, CREATE PROCEDURE, etc.) from an application? It is not the best idea for maintenance. Are you trying to emulate some other DBMS?

ed Received on Wed Nov 03 2004 - 16:18:00 CST