Home -> Usenet -> comp.databases.oracle -> Re: How to run a *.sql file from Pro*C ?

Re: How to run a *.sql file from Pro*C ?

From: Scott Urman <surman_at_oracle.com>
Date: 1996/01/19
Message-ID: <4donfe$rcd_at_inet-nntp-gw-1.us.oracle.com>#1/1 







In article <4djljd$pl7_at_athos.cc.bellcore.com>, jagdeep_at_base.bellcore.com (Jagdeep Shiruru) writes:


|> Hi,

|> 

|> I have a file abc.sql which I run from the SQL prompt as 'start abc.sql'

|> I need to run this file from a Pro*C function. How do I do that ?

|> Any help is appreciated. Thanks

|> 

|> Jagdeep


|> jagdeep_at_base.bellcore.com




Well, you could do a system call to sqlplus:
system("sqlplus user/password _at_abc");



But a better solution would be to take the SQL in abc.sql and make it into an
actual Pro*C program with EXEC SQL in front of the statements.
Received on Fri Jan 19 1996 - 00:00:00 CET












Original text of this message