Connecting To Oracle Database From Unix(script)

[ora2000]

Hi

I would like to create a unix script to connect to an ORACLE database using a oracle package. Also this script should provide functionality to call an oracle procedure that contains a parameter value that is passed to it. The parameter value passed to the procedure should be "editable" i.e user should be able to change it.

Please specify if any more information is needed

what I have done is the following
example script name -> Unixscript_run.sql
-- start sqlplus session
SQLPLUS
-- enter username and password when promted to login
-- define the value of the parameter passed to the procedure

DEFINE myVariable = 'xyz';

-- call to the program to connect to db

EXECUTE packageName.Procedurename(myVariable);

-- Display any errors encountered in the package and procedure
SHOW ERRORS packageName;]
SHOW ERRORS PROCEDUREname(myVariable);
-- Disconnect from sqlplus session once complete
DISCONNECT;


Thanks

[RedSon]

Moved from Misc questions. Maybe these guys can help you.