Cursor fetch null but its query works on SQL Worksheet
Hi all,
I am tracing my application using PYUPIP tool. I have a cursor which receives two (2) parameters and its body uses also one (1) global variable.
I am printing the parameters just before the cursor is opened so I certify that I am passing not null values etc.
I print the result of fetching the cursor into two local variables. This is because my cursor returns to values. After printing them, the result is NULL for both of them.
If execute the body of my cursor in SQL Worksheet, and I pass to it the SAME parameters that I printed before, I get the results as I expected.
Is this a normal behaviour or am I doing something wrong??
Regards