Hi there.
How do I make the DB connection see the parameter variables passed to the unix script ? The code snippet below isn't working properly.
sqlplus << EOF
user1@db1/pass1
BEGIN
PACKAGE1.perform_updates($1,$2,$3);
END;
EOF
Thanks in advance,
Abrahao.
sqlplus user1@db1/pass1 << EOF
BEGIN
PACKAGE1.perform_updates($1,$2,$3);
END;
/
EOF
Assuming your PL/SQL works - did you try it? - I added a slash, because it could not have worked without it.
:o
the slash was the problem, now the variables are getting into the package.
thanks!