unix script ti connect to an oracle database and call a stored procedure

[istruttorenuoto]

hi to everbody
i need to write a unix script to do a sqlplus connection (using user id and password) to an oracle database and call a stored procedure.

how could i do it?

thanks to all

[milonov]

hi!

you can execute script like:

sqlplus user/password@databasename @command_file

where command_file contans smth like:

select your_prosedure() from dual;
exit

With Best Regards,
Michael Milonov
http://www.snotratech.com

[istruttorenuoto]

thanks

so, to connect i use:
sqlplus user/password@databasename @command_file
and to call the stored procedure i use:
select your_prosedure() from dual;
?

[milonov]

yep, correct

end exit to leave sqlplus

With Best Regards,
Michael Milonov
http://www.snotratech.com

thanks

so, to connect i use:
sqlplus user/password@databasename @command_file
and to call the stored procedure i use:
select your_prosedure() from dual;
?

[istruttorenuoto]

thanks
i will try now