bug????

M

maxl

Member²
Hi, i'm using version version 6.0.1.848 on NT4wks.
When i click on "packages and bodies"->"edit spec & body" i'm able to see the source code but the contents windos is empty (the one that should list then procedures and windows names).
do you know why????
 
unfortunately for security reasons i can't send you the code. We discovered that the problem exists only on few clients, may be that some local configuration can affect this feature?
(clients are NTwks 4.0)
 
It may be a client specific issue, but as far as we know this works okay on all Windows versions. I assume this is not a general code contents problem on these clients, but only for specific packages?
 
To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:
Code: 
"C:\Program Files\PLSQL Developer\plsqldev.exe" debug
Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.
 
here the debug informations.
Hi...

PL/SQL Developer 6.0.3.893 07.19058 - Unlimited user license
C:\Programmi\PLSQL Developer\plsqldev.exe

21/10/2004 17.34.27 Application started
21/10/2004 17.34.27 SortPreferenceSets
21/10/2004 17.34.27 - Default SLR05
21/10/2004 17.34.27 - System Default
21/10/2004 17.34.30 Oracle Error: Session.DynamicQuery
ORA-00942: table or view does not exist
At line 1, position 29
select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
21/10/2004 17.34.30 Oracle Error: Session.
ORA-00942: table or view does not exist
At line 2, position 5
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
21/10/2004 17.34.30 SetSessionAction starts: Main session
21/10/2004 17.34.30 SetSessionAction ends
21/10/2004 17.34.30 ExecuteConnectScript starts
21/10/2004 17.34.30 ExecuteConnectScript ends
20041021 17.34.30 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\ORANT
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: C:\ORANT\bin\oci.dll
20041021 17.34.32 SortPreferenceSets
20041021 17.34.32 - Default SLR05
20041021 17.34.32 - System Default
20041021 17.34.33 Create TChildListForm
20041021 17.34.33 Create TTestForm
20041021 17.34.33 Create TProcEditForm
20041021 17.34.33 ProcEditForm.GetTabNames
20041021 17.34.33 + Gp_pkg_Check_Vincoli
20041021 17.34.33 + Gp_pkg_Check_Vincoli
20041021 17.34.33 ProcEditForm.GetTabNames done
20041021 17.34.33 UpdateContents(Clear)
20041021 17.34.33 Source = CREATE OR REPLACE PACKAGE Gp_pkg_Check_Vincoli IS
20041021 17.34.33 UpdatingContents: Thread Started
20041021 17.34.34 ContentsThread: Execute
20041021 17.34.34 ContentsThread: Analyze
20041021 17.34.34 ContentsThread: Invalid/Clear
20041021 17.34.34 ContentsThread: Suspend started
20041021 17.34.34 ContentsUpdated
20041021 17.34.34 ContentsUpdated: Invalid
20041021 17.34.34 ContentsUpdated: Refresh Code Contents
20041021 17.34.43 AddPlugInPopups Start 0
20041021 17.34.43 AddPlugInPopups End
20041021 17.34.46 Create TProcEditForm
20041021 17.34.46 ProcEditForm.GetTabNames
20041021 17.34.46 + GP_PKG_EC
20041021 17.34.46 ProcEditForm.GetTabNames done
20041021 17.34.46 UpdateContents(Clear)
20041021 17.34.46 Source = create or replace package GP_PKG_EC is
20041021 17.34.46 UpdatingContents: Thread Started
20041021 17.34.46 ContentsThread: Execute
20041021 17.34.46 ContentsThread: Analyze
20041021 17.34.46 ContentsThread: Invalid/Clear
20041021 17.34.46 ContentsThread: Suspend started
20041021 17.34.47 ProcEditForm.GetTabNames
20041021 17.34.47 + GP_PKG_EC
20041021 17.34.47 + GP_PKG_EC
20041021 17.34.47 ProcEditForm.GetTabNames done
20041021 17.34.47 UpdateContents(Clear)
20041021 17.34.47 Source = create or replace package body GP_PKG_EC is
20041021 17.34.47 UpdatingContents: Thread Started
20041021 17.34.47 ContentsThread: Resume
20041021 17.34.47 ContentsThread: Analyze
20041021 17.34.47 ContentsThread: Invalid/Clear
20041021 17.34.47 ContentsThread: Suspend started
20041021 17.34.47 ContentsUpdated
20041021 17.34.47 ContentsUpdated: Invalid
20041021 17.34.47 ContentsUpdated: Refresh Code Contents
20041021 17.34.47 ContentsUpdated
20041021 17.34.47 ContentsUpdated: Invalid
20041021 17.34.47 ContentsUpdated: Refresh Code Contents
20041021 17.34.50 Destroying TProcEditForm
20041021 17.34.50 ContentsThread: Resume
20041021 17.34.50 Destroyed TProcEditForm
20041021 17.34.50 Destroying TProcEditForm
20041021 17.34.50 ContentsThread: Resume
20041021 17.34.50 Destroyed TProcEditForm
20041021 17.34.52 Destroying TTestForm
20041021 17.34.52 Destroyed TTestForm
20041021 17.34.53 MainForm Closing
20041021 17.34.53 MainForm Closed
20041021 17.34.53 Destroying TChildListForm
20041021 17.34.53 Destroyed TChildListForm
20041021 17.34.53 MainForm Destroying
20041021 17.34.53 MainForm Destroyed
20041021 17.34.53 Finalization HTMLUnit
20041021 17.34.53 Finalization HTMLUnit done
20041021 17.34.53 Finalization PLSCommon
20041021 17.34.53 Finalization PLSCommon done
20041021 17.34.53 Finalization DBObjectUnit
20041021 17.34.53 Finalization DBObjectUnit done
20041021 17.34.53 Finalization RepUnit
20041021 17.34.53 Finalization RepUnit done
20041021 17.34.53 Finalization ReportCommon
20041021 17.34.53 Finalization ReportCommon done
20041021 17.34.53 Finalization PlanUnit
20041021 17.34.53 Finalization PlanUnit done
20041021 17.34.53 Finalization StatUnit
20041021 17.34.53 Finalization StatUnit done
20041021 17.34.53 Finalization DBNamesUnit
20041021 17.34.53 Finalization DBNamesUnit done
20041021 17.34.53 Finalization RowExportUnit
20041021 17.34.53 Finalization RowExportUnit done
20041021 17.34.53 Finalization TotalRecallUnit
20041021 17.34.53 Finalization TotalRecallUnit done
20041021 17.34.53 Finalization MacroUnit
20041021 17.34.53 Finalization MacroUnit done
 
For complete info i send also a debug file for a client where things are ok

PL/SQL Developer 6.0.1.848 07.19058 - Unlimited user license
C:\Programmi\plsql developer\PLSQLDev.exe

22/10/04 8.28.18 Application started
22/10/04 8.28.18 SortPreferenceSets
22/10/04 8.28.18 - Default BSE73
22/10/04 8.28.18 - System Default
22/10/04 8.28.23 Oracle Error: Session.
ORA-00942: table or view does not exist
At line 2, position 5
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
22/10/04 8.28.23 SetSessionAction starts: Main session
22/10/04 8.28.23 SetSessionAction ends
22/10/04 8.28.23 ExecuteConnectScript starts
22/10/04 8.28.23 ExecuteConnectScript ends
22/10/04 8.28.24 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\ORANT
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: C:\ORANT\bin\oci.dll
22/10/04 8.28.24 SortPreferenceSets
22/10/04 8.28.24 - Default BSE73
22/10/04 8.28.24 - System Default
22/10/04 8.28.24 Oracle Error: Session.DynamicQuery
ORA-00942: table or view does not exist
At line 1, position 29
select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
22/10/04 8.28.25 Create TChildListForm
22/10/04 8.28.34 AddPlugInPopups Start 0
22/10/04 8.28.34 AddPlugInPopups End
22/10/04 8.28.41 AddPlugInPopups Start 0
22/10/04 8.28.41 AddPlugInPopups End
22/10/04 8.28.43 Create TProcEditForm
22/10/04 8.28.43 ProcEditForm.GetTabNames
22/10/04 8.28.43 + GP_PKG_EC
22/10/04 8.28.43 ProcEditForm.GetTabNames done
22/10/04 8.28.43 UpdateContents(Clear)
22/10/04 8.28.43 Source = create or replace package GP_PKG_EC is
22/10/04 8.28.43 UpdatingContents: Thread Started
22/10/04 8.28.43 ContentsThread: Execute
22/10/04 8.28.43 ContentsThread: Analyze
22/10/04 8.28.43 ContentsThread: Valid
22/10/04 8.28.43 ContentsThread: Suspend started
22/10/04 8.28.43 ProcEditForm.GetTabNames
22/10/04 8.28.43 + GP_PKG_EC
22/10/04 8.28.43 + GP_PKG_EC
22/10/04 8.28.43 ProcEditForm.GetTabNames done
22/10/04 8.28.43 UpdateContents(Clear)
22/10/04 8.28.43 Source = create or replace package body GP_PKG_EC is
22/10/04 8.28.43 UpdatingContents: Thread Started
22/10/04 8.28.43 ContentsThread: Resume
22/10/04 8.28.43 ContentsThread: Analyze
22/10/04 8.28.44 ContentsUpdated
22/10/04 8.28.44 ContentsUpdated: Valid
22/10/04 8.28.44 ContentsUpdated: Refresh Code Contents
22/10/04 8.28.44 ContentsThread: Valid
22/10/04 8.28.44 ContentsThread: Suspend started
22/10/04 8.28.44 ContentsUpdated
22/10/04 8.28.44 ContentsUpdated: Valid
22/10/04 8.28.44 ContentsUpdated: Refresh Code Contents
22/10/04 8.28.45 Destroying TProcEditForm
22/10/04 8.28.45 ContentsThread: Resume
22/10/04 8.28.45 Destroyed TProcEditForm
22/10/04 8.28.46 MainForm Closing
22/10/04 8.28.46 MainForm Closed
22/10/04 8.28.46 Destroying TChildListForm
22/10/04 8.28.46 Destroyed TChildListForm
22/10/04 8.28.46 MainForm Destroying
22/10/04 8.28.46 MainForm Destroyed
22/10/04 8.28.46 Finalization PLSCommon
22/10/04 8.28.46 Finalization PLSCommon done
22/10/04 8.28.46 Finalization HTMLUnit
22/10/04 8.28.46 Finalization HTMLUnit done
22/10/04 8.28.46 Finalization DBObjectUnit
22/10/04 8.28.46 Finalization DBObjectUnit done
22/10/04 8.28.46 Finalization DBNamesUnit
22/10/04 8.28.46 Finalization DBNamesUnit done
22/10/04 8.28.46 Finalization PlanUnit
22/10/04 8.28.46 Finalization PlanUnit done
22/10/04 8.28.46 Finalization RepUnit
22/10/04 8.28.46 Finalization RepUnit done
22/10/04 8.28.46 Finalization ReportCommon
22/10/04 8.28.46 Finalization ReportCommon done
22/10/04 8.28.46 Finalization MacroUnit
22/10/04 8.28.46 Finalization MacroUnit done
22/10/04 8.28.46 Finalization TotalRecallUnit
22/10/04 8.28.46 Finalization TotalRecallUnit done
22/10/04 8.28.46 Finalization RowExportUnit
22/10/04 8.28.46 Finalization RowExportUnit done
22/10/04 8.28.46 Finalization StatUnit
22/10/04 8.28.46 Finalization StatUnit done
 
Can you send me an e-mail with these results? I will then send you a test version to analyze this problem further.
 
Well, apparently the following error occurs while parsing the PL/SQL text:

System Error. Code: 1009.
The configuration registry database is corrupt

We're not quite sure yet what this could mean, but we're looking into this.
 
Hi,

I know this is an old post but we're experiencing exactly the same problem.

We're using version 6.0.3.893, also on NT4. Some pc's with this configuration show the Code Contents for all packages and some don't show the Code Contents for any package.

Is there a solution available for this version of PSD?

Thanks in advance!
 
Unless the preferences are incorrectly setup for syntax highlighting, I do not have any real clues as to what might cause this.
 
You must log in or register to reply here.

Similar threads

G
  • Discussion Discussion
Editing a procedure from a package and showing the focus on another procedure
Replies
1
Views
171
Marco Kalter
Marco Kalter
B
  • Discussion Discussion
Saving package spec and body
Replies
3
Views
430
Marco Kalter
Marco Kalter
S
  • Discussion Discussion
Beautifier bug OPEN SYS_REFCURSOR
Replies
1
Views
275
Marco Kalter
Marco Kalter
K
  • Discussion Discussion
menu shortcuts
Replies
2
Views
404
kovi75
K
Z
  • Discussion Discussion
"Previous SQL" and "Next SQL" functionality enhancement?
Replies
2
Views
359
Megar
M
Back
Top