Describe in command window does not work without SELECT privileges

[Aviga]

Hello,

The end of the title is merely an assumption.

It seems that when I have SELECT ANY DICTIONARY privilege (and SELECT_CATALOG_ROLE role), I cannot do a describe from the command window on tables that I cannot select.

However, the describe window does work on the very same object.

Thanks for your help,

Aviga

 

[Jeff_1947]

This may be related to the problem with not using dba views in all PSD modules. See topic "Compare objects with only select_catalog_role on target user"

--jeff

 

[Marco Kalter]

You will need to enable the "Use DBA views if available" preference (Tools > Preferences > Oracle / Options). That should fix it.

 

[Jeff_1947]

"Use DBA Views" is enabled but still does not work as is the case with the compare module.

 

[Marco Kalter]

You mean the describe command in the Command Window? That should always work fine.

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Documents and Settings\\Application Data).

 

[Jeff_1947]

Hi Marco,

I have sent you a debug.txt file. It looks like the dbms_utility.name_resolve procedure does use dba views but just sees tables with select permission.

 

[Marco Kalter]

I don't think we received it. Can you send it again?

 

[Jeff_1947]

Here it is

PL/SQL Developer
Version 8.0.3.1510
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2,097,152 kB (692,100 available)
Paging file : 4,194,304 kB (2,864,984 available)
Virtual memory : 2,097,024 kB (2,031,072 available)

Parameters
P:\PLSQL Developer\plsqldev.exe
queryhints
DebugSQL

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

23-Apr-2010 14:31:50 Application started
23-Apr-2010 14:31:50 InitPreferences
23-Apr-2010 14:31:50 Load P:\PLSQL Developer\Preferences\Default = 0
23-Apr-2010 14:31:50 PreferenceSet.Load P:\PLSQL Developer\Preferences\Default\Default.ini
23-Apr-2010 14:31:50 PreferenceSet.Load OK
23-Apr-2010 14:31:50 Determine LocalPrefPath
23-Apr-2010 14:31:50 [1]: P:\PLSQL Developer\Preferences
23-Apr-2010 14:31:50 LocalPrefPath: P:\PLSQL Developer\Preferences\harkness
23-Apr-2010 14:31:50 Load P:\PLSQL Developer\Preferences\harkness = 0
23-Apr-2010 14:31:50 PreferenceSet.Load P:\PLSQL Developer\Preferences\harkness\default.ini
23-Apr-2010 14:31:50 PreferenceSet.Load OK
23-Apr-2010 14:31:50 PreferenceSet.Load P:\PLSQL Developer\Preferences\harkness\user.prefs
23-Apr-2010 14:31:50 PreferenceSet.Load OK
23-Apr-2010 14:31:50 InitPreferences end
23-Apr-2010 14:31:50 SortPreferenceSets
23-Apr-2010 14:31:50 - Default harkness
23-Apr-2010 14:31:50 - System Default
23-Apr-2010 14:31:50 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
23-Apr-2010 14:31:50 ReadString OK
23-Apr-2010 14:31:50 pfReadRegistry: "C:\Program Files\PLSQL Developer\PLSQLDev.exe" "%1"
23-Apr-2010 14:31:50 LoadPreferences
23-Apr-2010 14:31:50 LoadPreferences searching for default
23-Apr-2010 14:31:50 P:\PLSQL Developer\Preferences\harkness\default.ini
23-Apr-2010 14:31:50 LoadPreferences NewPref := nil
23-Apr-2010 14:31:50 LoadPreferences
23-Apr-2010 14:31:50 LoadPreferences Reading preferences
23-Apr-2010 14:31:50 LoadPreferences ReadPosition
23-Apr-2010 14:31:50 LoadPreferences ToolsBrowserItemClick(nil)
23-Apr-2010 14:31:50 LoadPreferences CreateBrowserFilters...
23-Apr-2010 14:31:50 LoadPreferences Files
23-Apr-2010 14:31:50 LoadPreferences Logon
23-Apr-2010 14:31:50 LoadPreferences Buttons
23-Apr-2010 14:31:50 LoadPreferences Printer
23-Apr-2010 14:31:50 LoadPreferences FileBrowserFolders
23-Apr-2010 14:31:50 LoadPreferences BrowserFolders
23-Apr-2010 14:31:50 LoadPreferences
23-Apr-2010 14:31:50 LoadPreferences end
23-Apr-2010 14:31:50 MacroLibFilename: P:\plsqldev\harkness.lib
23-Apr-2010 14:31:50 FormCreate Logon.Execute
23-Apr-2010 14:31:55 TOracleSession PLSQLDevForm.Session Start Session.LogOn as ddlsuser@rwhse
23-Apr-2010 14:31:55 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
23-Apr-2010 14:31:55 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
23-Apr-2010 14:31:55 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
23-Apr-2010 14:31:55 TOracleQuery Query End (1 record processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleSession PLSQLDevForm.Session End
Duration = 0.172
23-Apr-2010 14:31:55 FormCreate Session.Connected
23-Apr-2010 14:31:55 FormCreate Logon.Executed -1
23-Apr-2010 14:31:55 FormCreate TDBNames.Make
23-Apr-2010 14:31:55 FormCreate SessionChanged
23-Apr-2010 14:31:55 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
23-Apr-2010 14:31:55 TOracleQuery Query End (5 records processed)
Duration = 0.016
23-Apr-2010 14:31:55 SessionChanged SetDBAViews
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Execute
SQL = select null from all_synonyms where 1=0
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End (0 records processed)
Duration = 0.031
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End (0 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.015
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
23-Apr-2010 14:31:55 TOracleQuery PLSQLDevForm.DynamicQuery End (35 records processed)
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.032
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.063
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.032
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.047
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
23-Apr-2010 14:31:55 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:55 TOracleQuery $02C9C010 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.032
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.047
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.046
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.031
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.032
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.031
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.031
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_scheduler_jobs where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.125
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_scheduler_program_args where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.063
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_scheduler_job_args where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.016
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_scheduler_wingroup_members where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Describe
SQL = select * from sys.dba_scheduler_windows where rownum < 1
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0.015
23-Apr-2010 14:31:56 SessionChanged Authorizations.Load
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
23-Apr-2010 14:31:56 SessionChanged EnableAuthorizedMenus
23-Apr-2010 14:31:56 ExecuteConnectScript starts
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End
Duration = 0
23-Apr-2010 14:31:56 ExecuteConnectScript ends
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
23-Apr-2010 14:31:56 TOracleQuery $02C9C170 End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 TOracleSession $02CDCD90 Start Session.LogOn as ddlsuser@rwhse
23-Apr-2010 14:31:56 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
23-Apr-2010 14:31:56 TOracleQuery Query End (1 record processed)
Duration = 0.016
23-Apr-2010 14:31:56 TOracleSession $02CDCD90 End
Duration = 0.094
23-Apr-2010 14:31:56 SetSessionAction starts: Main session
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 Start Query.Execute
SQL = select null from dual
23-Apr-2010 14:31:56 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
23-Apr-2010 14:31:56 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
23-Apr-2010 14:31:56 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C2D0 Start Query.Execute
SQL = select object_name, object_type
from sys.all_objects o
where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = DDLSUSER
23-Apr-2010 14:31:56 TOracleQuery $02C9C010 End
Duration = 0.015
23-Apr-2010 14:31:56 SetSessionAction ends
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 SessionChanged LoadRecentObjects
23-Apr-2010 14:31:56 SessionChanged Notify children
23-Apr-2010 14:31:56 SessionChanged Logoff secondary sessions
23-Apr-2010 14:31:56 SessionChanged SessionMode = smMulti
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select /*+rule*/ value from v$nls_parameters where parameter = 'NLS_DATE_FORMAT'
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 SessionChanged EnableChildFunctions
23-Apr-2010 14:31:56 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home2
OracleHomeDir: C:\oracle\product\10.2.0\client_2
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_2\bin\oci.dll
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
23-Apr-2010 14:31:56 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
23-Apr-2010 14:31:56 TOracleQuery $02C9C2D0 End (0 records processed)
Duration = 0.063
23-Apr-2010 14:31:56 TOracleQuery $02C9C2D0 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = DDLSUSER
23-Apr-2010 14:31:56 PlugIn Exception: "Favorites v2.1" OnCreate
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.782
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.015
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 SortPreferenceSets
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.078
23-Apr-2010 14:31:57 - Default harkness
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 - System Default
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C010 Start Query.Execute
SQL = select null from all_synonyms where 1=0
23-Apr-2010 14:31:57 TOracleQuery $02C9C010 End (0 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C010 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
23-Apr-2010 14:31:57 TOracleQuery $02C9C010 End (0 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.031
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.047
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.031
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.015
23-Apr-2010 14:31:57 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:31:57 FormActivate start
23-Apr-2010 14:31:58 FormActivate end
23-Apr-2010 14:31:58 WMUpdatePopups starts
23-Apr-2010 14:31:58 LoadFileList: C:\DOCUME~1\harkness\LOCALS~1\Temp\PLS-Recovery\*.cfg
23-Apr-2010 14:31:58 LoadFileList 4 items
23-Apr-2010 14:31:58 LoadFileList DateSort
23-Apr-2010 14:31:58 GetCrashList: 2825000.cfg
23-Apr-2010 14:31:58 GetCrashList: 3410034.cfg
23-Apr-2010 14:31:58 GetCrashList: 18875204.cfg
23-Apr-2010 14:31:58 GetCrashList: 2754298.cfg
23-Apr-2010 14:31:58 LoadDesktop starts
23-Apr-2010 14:31:58 DoUpdateChildList
23-Apr-2010 14:31:58 LoadDesktop ends
23-Apr-2010 14:31:58 WMUpdatePopups ends
23-Apr-2010 14:31:59 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 1.844
23-Apr-2010 14:31:59 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:00 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.828
23-Apr-2010 14:32:00 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:03 ExecuteTemplateByName: PROGRAM UNITS\&Program Window
23-Apr-2010 14:32:03 ExecuteTemplate: P:\PLSQL Developer\Template\PROGRAM UNITS\&Program Window.tpl
23-Apr-2010 14:32:03 Path: P:\PLSQL Developer\Template\PROGRAM UNITS\&Program Window.tpl
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 4.297
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.015
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:04 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.015
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.015
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.016
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (100 records processed)
Duration = 0.063
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 Start Query.Next for up to 100 records
23-Apr-2010 14:32:05 TOracleQuery $02C9C2D0 End (13 records processed)
Duration = 0.281
23-Apr-2010 14:32:05 TOracleSession $02CDCD90 Start Session.LogOff
23-Apr-2010 14:32:05 TOracleSession $02CDCD90 End
Duration = 0
23-Apr-2010 14:32:05 Create TCommandForm Start
23-Apr-2010 14:32:05 Create TCommandForm Inherited
23-Apr-2010 14:32:05 Create TCommandForm SetupMainFont
23-Apr-2010 14:32:05 Create TCommandForm Activate
23-Apr-2010 14:32:05 Create TCommandForm Activate done
23-Apr-2010 14:32:05 Create TCommandForm UpdateWindowList
23-Apr-2010 14:32:05 UpdateChildList [timer]
23-Apr-2010 14:32:05 Create TCommandForm Positioning
23-Apr-2010 14:32:05 Create TCommandForm Finished
23-Apr-2010 14:32:05 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
23-Apr-2010 14:32:05 TOracleQuery Query End (5 records processed)
Duration = 0
23-Apr-2010 14:32:05 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
23-Apr-2010 14:32:05 TOracleQuery Query End (5 records processed)
Duration = 0
23-Apr-2010 14:32:05 NavigationBookmarks.EnableButtons(Rebuild)
23-Apr-2010 14:32:05 NavigationBookmarks: Backward=0, Forward=0
23-Apr-2010 14:32:05 ExecuteTemplateByName: Default\Command Window
23-Apr-2010 14:32:05 ExecuteTemplate: P:\PLSQL Developer\Template\Default\Command Window.tpl
23-Apr-2010 14:32:05 Path: P:\PLSQL Developer\Template\Default\Command Window.tpl
23-Apr-2010 14:32:05 NavigationBookmarks.EnableButtons(Rebuild)
23-Apr-2010 14:32:05 NavigationBookmarks: Backward=0, Forward=0
23-Apr-2010 14:32:05 InterpretLine starts: -- Autostart Command Window script
23-Apr-2010 14:32:05 InterpretLine ends
23-Apr-2010 14:32:05 InterpretLine starts: set sqlprompt [connection]
23-Apr-2010 14:32:05 InterpretLine ends
23-Apr-2010 14:32:05 NavigationBookmarks.EnableButtons(Rebuild)
23-Apr-2010 14:32:05 NavigationBookmarks: Backward=0, Forward=0
23-Apr-2010 14:32:05 DoUpdateChildList
23-Apr-2010 14:32:21 TOracleQuery $02C9BEB0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
23-Apr-2010 14:32:21 TOracleQuery $02C9BEB0 End (1 record processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.ResolveSymbolQuery2 Start Query.Execute
SQL = declare
c integer := 0;
p1 varchar2(500);
p2 varchar2(500);
expr varchar2(500);
dblink varchar2(500);
part1_type integer;
object_number integer;
dp integer;
begin
bject_type := null;
bject_owner := null;
bject_name := null;
:sub_object := null;
expr := art1;
if art2 is not null then expr := expr || '.' || art2; end if;
if art3 is not null then expr := expr || '.' || art3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => bject_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then bject_type := 'INDEX'; end if;
if part1_type = 2 then bject_type := 'TABLE'; end if;
if part1_type = 4 then bject_type := 'VIEW'; end if;
if part1_type = 5 then bject_type := 'SYNONYM'; end if;
if part1_type = 6 then bject_type := 'SEQUENCE'; end if;
if part1_type = 7 then bject_type := 'PROCEDURE'; end if;
if part1_type = 8 then bject_type := 'FUNCTION'; end if;
if part1_type = 9 then bject_type := 'PACKAGE'; end if;
if part1_type = 12 then bject_type := 'TRIGGER'; end if;
if part1_type = 13 then bject_type := 'TYPE'; end if;
if part1_type = 28 then bject_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then bject_type := 'JAVA CLASS'; end if;
if bject_type is null then
select object_type into bject_type
from sys.dba_objects
where object_id = object_number;
end if;
exception
when others then null;
end;
c := c + 1;
if c > 9 then
dp := instr(expr, '.', -1);
if dp > 0 then
if :sub_object is not null then
:sub_object := '.' || :sub_object;
end if;
:sub_object := upper(substr(expr, dp + 1)) || :sub_object;
expr := substr(expr, 1, dp - 1);
c := 0;
end if;
end if;
exit when object_type is not null) or (c > 9);
end loop;
if bject_type is not null then
if p1 is null then
bject_name := p2;
elsif p2 is null then
bject_name := p1;
if bject_name = art1 and art2 is not null then
:sub_object := art2;
end if;
if bject_name = art2 and art3 is not null then
:sub_object := art3;
end if;
else
bject_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if art2 is null and art3 is null then
select 'USER', null, art1
into bject_type, bject_owner, bject_name
from sys.dba_users u
where u.username = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if art2 is null and art3 is null and :deep != 0 then
select 'ROLE', null, art1
into bject_type, bject_owner, bject_name
from sys.session_roles r
where r.role = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if art2 is null then
select constraint_type, owner, constraint_name
into bject_type, bject_owner, bject_name
from sys.dba_constraints c
where c.constraint_name = art1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, art3
into bject_type, bject_owner, bject_name, :sub_object
from sys.dba_constraints c
where c.constraint_name = art2
and c.owner = art1
and rownum = 1;
end if;
if bject_type = 'P' then
bject_type := 'PRIMARY KEY';
end if;
if bject_type = 'U' then
bject_type := 'UNIQUE KEY';
end if;
if bject_type = 'R' then
bject_type := 'FOREIGN KEY';
end if;
if bject_type = 'C' then
bject_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
ART1 = APPPNLADMIN
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =
:SUB_OBJECT = Null
ART3 =
EEP = 0
:CUR_SCHEMA = DDLSUSER
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.ResolveSymbolQuery2 End
Duration = 0.047
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Execute
SQL = select /*+rule*/ object_name synonym_name, object_name, owner object_owner, status, object_type
from sys.dba_objects o
where o.owner = bject_owner
and o.object_type in ('TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SEQUENCE', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE')
and o.object_name not like 'BIN$%'

order by o.object_type, o.object_name
:OBJECT_OWNER = APPPNLADMIN
:OBJECT_TYPE = 'TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SEQUENCE', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE'
:EXTRA_CONDITION = Null
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0.031
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0.016
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (25 records processed)
Duration = 0
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery Start Query.Next for up to 25 records
23-Apr-2010 14:32:21 TOracleQuery PLSQLDevForm.UserObjectsQuery End (14 records processed)
Duration = 0
23-Apr-2010 14:32:42 InterpretLine starts: desc apppnladmin.pnl_position
23-Apr-2010 14:32:42 TOracleQuery $02C9BEB0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
23-Apr-2010 14:32:42 TOracleQuery $02C9BEB0 End (1 record processed)
Duration = 0
23-Apr-2010 14:32:42 TOracleQuery PLSQLDevForm.ResolveSymbolQuery2 Start Query.Execute
SQL = declare
c integer := 0;
p1 varchar2(500);
p2 varchar2(500);
expr varchar2(500);
dblink varchar2(500);
part1_type integer;
object_number integer;
dp integer;
begin
bject_type := null;
bject_owner := null;
bject_name := null;
:sub_object := null;
expr := art1;
if art2 is not null then expr := expr || '.' || art2; end if;
if art3 is not null then expr := expr || '.' || art3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => bject_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then bject_type := 'INDEX'; end if;
if part1_type = 2 then bject_type := 'TABLE'; end if;
if part1_type = 4 then bject_type := 'VIEW'; end if;
if part1_type = 5 then bject_type := 'SYNONYM'; end if;
if part1_type = 6 then bject_type := 'SEQUENCE'; end if;
if part1_type = 7 then bject_type := 'PROCEDURE'; end if;
if part1_type = 8 then bject_type := 'FUNCTION'; end if;
if part1_type = 9 then bject_type := 'PACKAGE'; end if;
if part1_type = 12 then bject_type := 'TRIGGER'; end if;
if part1_type = 13 then bject_type := 'TYPE'; end if;
if part1_type = 28 then bject_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then bject_type := 'JAVA CLASS'; end if;
if bject_type is null then
select object_type into bject_type
from sys.dba_objects
where object_id = object_number;
end if;
exception
when others then null;
end;
c := c + 1;
if c > 9 then
dp := instr(expr, '.', -1);
if dp > 0 then
if :sub_object is not null then
:sub_object := '.' || :sub_object;
end if;
:sub_object := upper(substr(expr, dp + 1)) || :sub_object;
expr := substr(expr, 1, dp - 1);
c := 0;
end if;
end if;
exit when object_type is not null) or (c > 9);
end loop;
if bject_type is not null then
if p1 is null then
bject_name := p2;
elsif p2 is null then
bject_name := p1;
if bject_name = art1 and art2 is not null then
:sub_object := art2;
end if;
if bject_name = art2 and art3 is not null then
:sub_object := art3;
end if;
else
bject_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if art2 is null and art3 is null then
select 'USER', null, art1
into bject_type, bject_owner, bject_name
from sys.dba_users u
where u.username = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if art2 is null and art3 is null and :deep != 0 then
select 'ROLE', null, art1
into bject_type, bject_owner, bject_name
from sys.session_roles r
where r.role = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if art2 is null then
select constraint_type, owner, constraint_name
into bject_type, bject_owner, bject_name
from sys.dba_constraints c
where c.constraint_name = art1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, art3
into bject_type, bject_owner, bject_name, :sub_object
from sys.dba_constraints c
where c.constraint_name = art2
and c.owner = art1
and rownum = 1;
end if;
if bject_type = 'P' then
bject_type := 'PRIMARY KEY';
end if;
if bject_type = 'U' then
bject_type := 'UNIQUE KEY';
end if;
if bject_type = 'R' then
bject_type := 'FOREIGN KEY';
end if;
if bject_type = 'C' then
bject_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
ART1 = APPPNLADMIN
:OBJECT_TYPE = USER
:OBJECT_OWNER = Null
:OBJECT_NAME = APPPNLADMIN
ART2 = PNL_POSITION
:SUB_OBJECT = Null
ART3 =
EEP = 0
:CUR_SCHEMA = DDLSUSER
23-Apr-2010 14:32:42 TOracleQuery PLSQLDevForm.ResolveSymbolQuery2 End
Duration = 0
23-Apr-2010 14:32:42 InterpretLine ends
23-Apr-2010 14:32:42 NavigationBookmarks.EnableButtons(Rebuild)
23-Apr-2010 14:32:42 NavigationBookmarks: Backward=0, Forward=0

 

[Marco Kalter]

Thanks. We'll check it out.

 

[Aviga]

Thank you both,

Sorry for my silence on this thread, but I just realized that though I had asked to be notified by email for my watched topics, my email address was incorrect.

Regards,

Avigael