Hi,
I have a problem for a DB2 trigger that take records from a table and put them into another one.
I need to do a choice when i copy from a table to another. I made my trigger and it works but it's not perfect. So i need help to make it better.
Here is my trigger:
CREATE TRIGGER SAPR3.TR1_P_SGQ 0400I AFTER INSERT ON SAPR3.SGQ0400I
REFERENCING NEW ROW AS NEW FOR EACH ROW MODE DB2SQL...
istruttorenuoto
Last Activity: Feb 20 '07, 12:06 PM
Joined: Oct 24 '06
Location:
-
IF statement as SELECT's argument for a DB2 Trigger
-
HELP!! errors managing. i need help.
hi to everybody!!
i wrote i script from Unix's Bourne shell that connects to an Oracle DataBase and calls a Stored Procedure. Now i'd like to insert some more commands for error managing.
here's my scritp:
stty istrip
stty erase ^H
export ORACLE_BASE=/product/oracle
export ORACLE_HOME=$OR ACLE_BASE/product/9.2.6
export PATH=$ORACLE_HO ME/bin:/usr/ccs/bin:/bin:/usr/bin:/usr/local/bin:/usr/ucb:/tibcosv/dtsgvemi/S2T/scripts... -
istruttorenuoto started a topic how manage errors in Unix's scripts for oracle connection and procedure's callsin Oraclehow manage errors in Unix's scripts for oracle connection and procedure's calls
hi to everybody!
could anyone tell me if there's a link to find documentation about managing errors in unix's scripts to connect to an oracle database and call stored procedures?
thank you -
problem to call a stored procedure from unix using a script
hi!
I have some problems to call a stored procedure from an Unix Script.
Here's the script
stty istrip
stty erase ^H
export ORACLE_BASE=/product/oracle
export ORACLE_HOME=$OR ACLE_BASE/product/9.2.6
export PATH=$ORACLE_HO ME/bin:/usr/ccs/bin:/bin:/usr/bin:/usr/local/bin:/usr/ucb
sqlplus user/password@(DESCR IPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = IP_ADDRESS)(POR T... -
thanks
so, to connect i use:
sqlplus user/password@databa sename @command_file
and to call the stored procedure i use:
select your_prosedure( ) from dual;
?Leave a comment:
-
istruttorenuoto started a topic unix script ti connect to an oracle database and call a stored procedurein Oracleunix script ti connect to an oracle database and call a stored procedure
hi to everbody
i need to write a unix script to do a sqlplus connection (using user id and password) to an oracle database and call a stored procedure.
how could i do it?
thanks to all
No activity results to display
Leave a comment: