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@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 - 03:16:49 CST