Passing Unix Params to a Stored Procedure

From: Roy Martin <rmartin_at_bfsec.bt.co.uk>
Date: Mon, 6 Jan 2003 13:38:32 -0000
Message-ID: <avc19d$623$1@pheidippides.axion.bt.co.uk>

need to pass Unix parameters to a stored procedure (called in proc.sql)

I call proc.sql like so (I've ommited the sql logon info etc):

@proc.sql $1 $2 $3

Within proc.sql I call the stored procedure:

my_proc('&1', '&2', '&3');

However this doesn't pick up the parameters passed from the Unix script. Am I correct in thinking that &1 etc is the correct way to bind parameters? Whenever I run proc.sql from the sql prompt, I get prompted to enter the three values and the script executes correctly.

TIA Received on Mon Jan 06 2003 - 07:38:32 CST