Hello,
I have a Program that connects to an Oracle
Database and also makes
OBDC connections to different AS400 databases. The
program verifies the
integrity of data in a report Table against AS400
database.
Any bogus lines in the report table is deleted. At
the end
the first lines in each section is updated to set
the
qty to match the number of lines in that section.
I am
using bind_param_in_out and it is not
decrementing
the value. I don't get any errors and results show
that 1 row is being updated. I have set level 9
trace and also attaching the script. The set of
statements
that does not result in any updates is st4. If I
take the statements related to st4 alone and run it
in a
seperate script it works. Any ideas?
WAREHOUSE
VARCHAR2(3)
BUSINESS_UNIT
VARCHAR2(2)
RUN_ID NUMBER(8)
SECTION_NUM NUMBER(2)
LINE_NUM NUMBER(6)
QTY NUMBER(6)
EXCEPTION_TYPE
VARCHAR2(230)
EXCEPTION_ELEMENT
VARCHAR2(50)
EXCESS
VARCHAR2(50)
Thanks,
Ravi
__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
