Recent content by lparker

Thanks - I changed it to use DBA_ instead of ALL_ and all issues have been resolved.

Hi, Could you please let me know how I can change the query in release 9. It is causing issues when we connect and I cannot disable the query from running anymore. select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema)...

I am having the exact problem. When using version 9 and connecting, it runs this query even though I have selected to use DBA_views where available. This sorted the same issue in version 8, but does not seem to work in version 9. The query is this: select s.synonym_name as object_name...

I am sorry - we held some variables within the session that caused the new parameter settings to not being used. Debugging through it will create a new session and hence any package variables will be lost.

I have a set of PL/SQL calls that has some input parameters, that I am calling through the Test Window. 1. Set parameter to value 1 2. Execute PL/SQL by pressing Execute (F8). 3. Data returned as expected. 4. Change parameter to value 2 5. Execute PL/SQL by pressing Execute (F8). 6. Data...

We are using version 8 on Oracle 11g. Could you please let us know when the issue of using dbms_xplan.display_cursor will be resolved. Thanks Lise

Hi, After upgrading to 11.1.0.7 we have also upgraded our IDE to 8.0.4. The server/client s/w has also been upgraded to 11.1.0.7, so all interfaces are certified. I assume that PL/SQL Dev 8.0.4 is also certified against 11g. We are hitting several issues, however one of the main ones at the...

Hi, We are encountering the same problem after upgrading from 6 to 8.0.4. Database version is the same (11.1). Thanks Lise