[sqr-users] Pb to get oracle func. value after some loops

[Charles-Albert Lebrun <calebrun@yahoo.com>]

Sorry ! I forgot to mention that I'm using Brio v6.1.3 and 6.2.1. Both give 
same result.

-------------------------------------

Hello all,

I'm new to the list so I don't know if this has been mentioned before. I try to 
search, but did
not get proper result.

I have a Brio SQR program that prepare some data in a seperate table (ment for 
later export).
This process has a loop that scan data and update a temporary table that will 
be read bu another
software. During this process I'm calling some Oracle 8i (8.1.5) stored 
procedures to compute some
stuff and store it.

After a number of loops/records in the main cursor, one of the Oracle 
proc/func. call I issue does
not return the proper values. 

At the beginning it was a procedure with two return param : the value I need + 
a status flag.
After some loops the OUT param. of the stored procedure were not updated 
anymore.

I changed it to a function, and it gave the same bad result.

If I try to call the proc. or func. with the same parameters from Oracle tools 
(such as SQLPLUS),
it works well ! The original stored procedure is an old one used for years on 
several sites, so I
am pretty confident that it is not the culprit... But... When I replace the 
content of the proc.
and makes it return a constant value, it works (i.e. that value is correctly 
returned to Brio).

If anyone has an advice for that case, I will be thankful.

Have a nice day, 

Charly

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users