Oracle on UNIX - How to connect via command line ???

[Doug]

Environment information:
* Oracle version: 10 g
* Operating system: UNIX

Good evening.

My problem is the following: I have a SQL file that I set myself up. This file works perfectly, but I need to automate this activity.

My client has Oracle installed on a UNIX server.
As I do not manjo anything UNIX I decided to ask you: You can create a bat (with CTZ) on UNIX, it connects to the bank and calls the script via the command line.

If it were in Windows, it would be + or - so:

Select all

#------------------------------------------  
# Interface Automatizada do MasterSaf  
#------------------------------------------  
 
echo Iniciando Processo na Instancia Local  
 
sqlplus doug@local  
@c:\temp\Bat.sql  
quit  
 
echo Finalizando Processo na Instancia Local 

Any idea of ??how to call this bat.sql On UNIX.

ABS ...

[gilbertoca]

Environment information:
* Oracle version: 10 g
* Operating system: UNIX

Good evening.

My problem is the following: I have a SQL file that I set myself up. This file works perfectly, but I need to automate this activity.

My client has Oracle installed on a UNIX server.
How Unix Nothing I decided to ask you: You can create a BAT (with CTZ) on UNIX, it connects to the bank and calls the script via the command line.

If it were in Windows, it would be + or - so:

Select all

#------------------------------------------  
# Interface Automatizada do MasterSaf  
#------------------------------------------  
 
echo Iniciando Processo na Instancia Local  
 
sqlplus doug@local  
@c:\temp\Bat.sql  
quit  
 
echo Finalizando Processo na Instancia Local 

Any idea of ??how to call this bat.sql On UNIX.

ABS ...

If only this script would be thus:

Select all

#------------------------------------------  
# Interface Automatizada do MasterSaf  
#------------------------------------------  
 
echo Iniciando Processo na Instancia Local  
 
sqlplus doug@local  
@/home/usuario/temp/Bat.sql  
quit  
 
echo Finalizando Processo na Instancia Local 

The only difference is how to locate the file.
Detail, need to be the user who installed Oracle, as it contains the environment settings required to run any Oracle torque.

Gilberto

[Doug]

Thanks Gilberto. I'll be going to the code for the test consultant.

grateful.