problems with debugger

[jmueller]

Currently I am testing a pl/sql package. Testing
in SQL*Plus I receive the correct result sets, using the PL/SQL Developer with the same values I sometimes get empty result sets.
I am using trial-version 5.1.3.704.
Is there anybody with the same problems?

 

[Marco Kalter]

I can only imagine that:

1. The procedure is called with different parameter values or types.

2. You are using a different Oracle user.

3. SQL*Plus and PL/SQL Developer are on different PC's, or in different Oracle Homes on the same PC, and these 2 configurations have a different NLS settings.

4. The result relies on a package state (global variables) that are sometimes different or reset after a disconnect.

------------------
Marco Kalter
Allround Automations

 

[aotte]

When I get those problems, it is because I am doing things in multiple windows, I have multi session on, and forgot do a commit in one of the windows(=sessions).

Hope this helps.

------------------
Hakuna Matata,

Arnoud.