File at UNIX Server

[fmsousa]

Hi,

I would like to know how can i execute a file that is under UNIX system, without using @path/file.sql

I used this package UTL_FILE.FOPEN but i haven't got any results...

Please if u know one way to do this, it would be great!!
Thanks in advance.

 

[lfoata]

I am not sure that what you need but you can call sqlplus from unix and pass the sql script as a parameter. If I remember correctly you can do like the following :

sqlplus userid/passwd < sqlscript.sql Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[fmsousa]

No, i'm using Forms Developer and i want to call a file that is in a UNIX Server.

I have used the following instruction:
UTL_FILE.FOPEN ('/path','filename','r')

but nothing....

Can u help me?
Thanks in advance.

 

[carp]

You still haven't mentioned what is in the file. A script? A parameter value? ????

If you are trying to run a script, you can't. However, you might be able to read the contents of the file into a character string, and then use dynamic SQL to get the command executed.