Re: run a script in a PRO*C procedure !

From: <steyaert_at_my-deja.com>
Date: Mon, 24 Jan 2000 20:46:22 GMT
Message-ID: <86idms$l9$1@nnrp1.deja.com>

Not as far as I know. If you are on a Unix based system, you could:

system("sqlplus oracle/oracle1 < script");

On other operating systems, something similar may be available. Lastly, you could read through the script as a sub-routine, every time you get to a ; end the string, and EXEC SQL EXECUTE :cmd;

Terry Steyaert
steyaert_at_my-deja.com

In article <86hv9t$u52$1_at_minus.oleane.net>, "Olivier BRUZEAUX" <obruzeau_at_telecom.capgemini.fr> wrote:
>
> Is it possible to run a sql script (script.sql) from a PROC*C
procedure
> (file.pc):
>
> Example:
> EXEC SQL "I want to run script.sql"
>
> Thanks,
>
> Olivier
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 14:46:22 CST