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

["George Jansen" <GJANSEN@aflcio.org>]

Might I suggest that rather than testing with SQL*Plus you use the
utPLSQL packages, freely available from SourceForge, to test your
function? If the error shows up only after some number of loops, you
probably want to automate your tests.

Even if there is a Brio bug and your functions are blameless, getting
to know utPLSQL is worth the trouble:

http://oracle.oreilly.com/utplsql/

>>> calebrun@yahoo.com 05/06/03 05:36PM >>>

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

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