Re: Calling St. Procedure in UNIX script, How ?
From: Hendrie Kain <hendrie_at_henbel.com>
Date: Thu, 29 Nov 2001 10:16:49 +0100
Message-ID: <9u4ubu$pd9$1_at_reader08.wxs.nl>
/
EXIT
EOF
}
Date: Thu, 29 Nov 2001 10:16:49 +0100
Message-ID: <9u4ubu$pd9$1_at_reader08.wxs.nl>
This is a sample of a functionfrom a shell-script I once wrote:
insert_into_table()
{
${ORACLE_HOME}/bin/sqlplus -s username/password_at_database <<EOF | grep
ORA-00001 > err$$
DECLARE
t_retval NUMBER;
r_nf table_x%ROWTYPE;
BEGIN
r_nf.column_a := 'Text A'; r_nf.column_b := 'Text B'; r_nf.column_c := 'Text C'; t_retval := PACKAGE_NAME.PROCEDURE_NAME(r_nf);END;
/
EXIT
EOF
}
I hope this helps.....
Hendrie Kain
jane <janeyiu_at_optonline.net> schreef in berichtnieuws
sojN7.208$rS6.61809_at_news02.optonline.net...
> How does one call stored procedures in UNIX
> shell script (I'll take any flavor, thanks) and
> mostly, pass shell variables as parameters ?
>
> Thanks very much !
> jane yiu
>
>
Received on Thu Nov 29 2001 - 10:16:49 CET