Hi Marco...
This is the content of file debug.sql tnks for your help.
PL/SQL Developer 7.0.3.1123 01.26367 - 5 user license
C:\Archivos de programa\PLSQL Developer\plsqldev.exe
18/12/2007 11:55:14 a.m. Application started
18/12/2007 11:55:14 a.m. InitPreferences
18/12/2007 11:55:14 a.m. Load C:\Archivos de programa\PLSQL Developer\Preferences\Default = 0
18/12/2007 11:55:14 a.m. PreferenceSet.Load C:\Archivos de programa\PLSQL Developer\Preferences\Default\Default.ini
18/12/2007 11:55:14 a.m. PreferenceSet.Load OK
18/12/2007 11:55:14 a.m. Load C:\Archivos de programa\PLSQL Developer\Preferences\manuelga = 0
18/12/2007 11:55:14 a.m. PreferenceSet.Load C:\Archivos de programa\PLSQL Developer\Preferences\manuelga\default.ini
18/12/2007 11:55:14 a.m. PreferenceSet.Load OK
18/12/2007 11:55:14 a.m. PreferenceSet.Load C:\Archivos de programa\PLSQL Developer\Preferences\manuelga\user.prefs
18/12/2007 11:55:14 a.m. PreferenceSet.Load OK
18/12/2007 11:55:14 a.m. InitPreferences end
18/12/2007 11:55:14 a.m. SortPreferenceSets
18/12/2007 11:55:14 a.m. - Default manuelga
18/12/2007 11:55:14 a.m. - System Default
18/12/2007 11:55:15 a.m. LoadPreferences
18/12/2007 11:55:15 a.m. LoadPreferences searching for default
18/12/2007 11:55:15 a.m. C:\Archivos de programa\PLSQL Developer\Preferences\manuelga\default.ini
18/12/2007 11:55:15 a.m. LoadPreferences end
18/12/2007 11:55:15 a.m. FormCreate Logon.Execute
18/12/2007 11:59:35 a.m. TOracleSession PLSQLDevForm.Session Start Session.LogOn as data@pivodesa
18/12/2007 11:59:37 a.m. TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
18/12/2007 11:59:37 a.m. TOracleQuery Query End (2 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleSession PLSQLDevForm.Session End
Duration = 1.625
18/12/2007 11:59:37 a.m. LogonHistorySave start
18/12/2007 11:59:37 a.m. ChangeUserPref LogonHistory,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref DSA,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref ColumnAssociations,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref ImportAssociations,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref BrowserFilters,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref BrowserFolders,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref SessionQueries,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref ExternalTools,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref Documents,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. ChangeUserPref Reports,
18/12/2007 11:59:37 a.m. ChangeUserPref end
18/12/2007 11:59:37 a.m. PreferenceSet.Save
18/12/2007 11:59:37 a.m. PreferenceSet filename = C:\Archivos de programa\PLSQL Developer\Preferences\manuelga\user.prefs
18/12/2007 11:59:37 a.m. PreferenceSet.Save end
18/12/2007 11:59:37 a.m. LogonHistorySave end
18/12/2007 11:59:37 a.m. FormCreate Session.Connected
18/12/2007 11:59:37 a.m. FormCreate Logon.Executed -1
18/12/2007 11:59:37 a.m. FormCreate TDBNames.Make
18/12/2007 11:59:37 a.m. FormCreate SessionChanged
18/12/2007 11:59:37 a.m. TOracleQuery Query Start Query.Execute
SQL = select * from v$version
18/12/2007 11:59:37 a.m. TOracleQuery Query End (5 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. SessionChanged SetDBAViews
18/12/2007 11:59:37 a.m. 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%'
18/12/2007 11:59:37 a.m. TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.016
18/12/2007 11:59:37 a.m. TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
18/12/2007 11:59:37 a.m. TOracleQuery PLSQLDevForm.DynamicQuery End (3 records processed)
Duration = 0.016
18/12/2007 11:59:37 a.m. SessionChanged Authorizations.Load
18/12/2007 11:59:37 a.m. TOracleQuery $022DD6D0 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)
18/12/2007 11:59:37 a.m. TOracleQuery $022DD6D0 End
Result = ORA-00942: table or view does not exist
Duration = 0
18/12/2007 11:59:37 a.m. SessionChanged EnableAuthorizedMenus
18/12/2007 11:59:37 a.m. TOracleSession $014FB220 Start Session.LogOn as data@pivodesa
18/12/2007 11:59:37 a.m. TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
18/12/2007 11:59:37 a.m. TOracleQuery Query End (2 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleSession $014FB220 End
Duration = 0.062
18/12/2007 11:59:37 a.m. SetSessionAction starts: Main session
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
18/12/2007 11:59:37 a.m. TOracleQuery $022DDAF0 Start Query.Execute
SQL = select null from dual
18/12/2007 11:59:37 a.m. TOracleQuery $022DDAF0 End (2 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DDAF0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (52 records processed)
Duration = 0.015
18/12/2007 11:59:37 a.m. TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
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')
18/12/2007 11:59:37 a.m. TOracleQuery BytesPerCharacterQuery End (2 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
18/12/2007 11:59:37 a.m. TOracleQuery BytesPerCharacterQuery End (2 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DDAF0 End
Duration = 0.047
18/12/2007 11:59:37 a.m. SetSessionAction ends
18/12/2007 11:59:37 a.m. ExecuteConnectScript starts
18/12/2007 11:59:37 a.m. ExecuteConnectScript ends
18/12/2007 11:59:37 a.m. TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
18/12/2007 11:59:37 a.m. TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
18/12/2007 11:59:37 a.m. SessionChanged LoadRecentObjects
18/12/2007 11:59:37 a.m. SessionChanged Notify children
18/12/2007 11:59:37 a.m. SessionChanged Logoff secondary sessions
18/12/2007 11:59:37 a.m. SessionChanged SessionMode = smMulti
18/12/2007 11:59:37 a.m. SessionChanged EnableChildFunctions
18/12/2007 11:59:37 a.m. Toolbar.NavDisable
18/12/2007 11:59:37 a.m. SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME1
OracleHomeDir: C:\oracle\ora92
Found: oci.dll
Using: C:\oracle\ora92\bin\oci.dll
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.219
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.015
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.016
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.031
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.016
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.015
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.015
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0.016
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:37 a.m. TOracleQuery $022DD410 End (100 records processed)
Duration = 0
18/12/2007 11:59:38 a.m. TOracleQuery $022DD410 Start Query.Next for up to 100 records
18/12/2007 11:59:38 a.m. TOracleQuery $022DD410 End (96 records processed)
Duration = 0.125
18/12/2007 11:59:38 a.m. TOracleSession $014FB220 Start Session.LogOff
18/12/2007 11:59:38 a.m. TOracleSession $014FB220 End
Duration = 0
18/12/2007 11:59:38 a.m. SortPreferenceSets
18/12/2007 11:59:38 a.m. - Default manuelga
18/12/2007 11:59:38 a.m. - System Default
18/12/2007 11:59:39 a.m. Toolbar.NavDisable
18/12/2007 11:59:39 a.m. Toolbar.NavDisable
18/12/2007 11:59:39 a.m. WMUpdatePopups starts
18/12/2007 11:59:39 a.m. LoadDesktop starts
18/12/2007 11:59:39 a.m. LoadDesktop ends
18/12/2007 11:59:39 a.m. WMUpdatePopups ends
18/12/2007 11:59:45 a.m. TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Execute
SQL = select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o
where object_type = 'PACKAGE BODY'
and object_name not like 'BIN$%'
order by decode(owner, user, 0, 1),
owner,
object_name
:OBJECT_TYPE = PACKAGE BODY
:EXTRA_CONDITION =
18/12/2007 11:59:45 a.m. TOracleQuery PLSQLDevForm.ObjectQuery End (2 records processed)
Duration = 0.172
18/12/2007 11:59:51 a.m. TOracleQuery $022DD990 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner =
bject_owner
and po.object_name =
bject_name
and po.object_type =
bject_type
:OBJECT_OWNER = DATA
:OBJECT_NAME = PIV_K_TELEMARKETING_MMX
:OBJECT_TYPE = PACKAGE BODY
18/12/2007 11:59:51 a.m. TOracleQuery $022DD990 End (1 record processed)
Duration = 0.047
18/12/2007 11:59:51 a.m. AddPlugInPopups Start 0
18/12/2007 11:59:51 a.m. AddPlugInPopups End
18/12/2007 11:59:59 a.m. TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Execute
SQL = select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o
where object_type = 'PACKAGE'
and object_name not like 'BIN$%'
order by decode(owner, user, 0, 1),
owner,
object_name
:OBJECT_TYPE = PACKAGE
:EXTRA_CONDITION =
18/12/2007 11:59:59 a.m. TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0.343
18/12/2007 11:59:59 a.m. TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
18/12/2007 11:59:59 a.m. TOracleQuery PLSQLDevForm.ObjectQuery End (93 records processed)
Duration = 0
18/12/2007 12:00:06 p.m. TOracleQuery $022DD990 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner =
bject_owner
and po.object_name =
bject_name
and po.object_type =
bject_type
:OBJECT_OWNER = DATA
:OBJECT_NAME = PIV_VENTANA_SAGIS_MMX
:OBJECT_TYPE = PACKAGE BODY
18/12/2007 12:00:06 p.m. TOracleQuery $022DD990 End (1 record processed)
Duration = 0.016
18/12/2007 12:00:06 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:06 p.m. AddPlugInPopups End
18/12/2007 12:00:07 p.m. Create TProcEditForm
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Execute
SQL = select text from sys.all_source
where owner =
wner
and name = :name
and type = :type
order by line
:OWNER = DATA
:NAME = PIV_VENTANA_SAGIS_MMX
:TYPE = PACKAGE BODY
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0.438
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0.015
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0.016
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0.016
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (100 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 Start Query.Next for up to 100 records
18/12/2007 12:00:08 p.m. TOracleQuery $022DDAF0 End (65 records processed)
Duration = 0
18/12/2007 12:00:08 p.m. TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner =
wner
order by sequence
:NAME = PIV_VENTANA_SAGIS_MMX
:TYPE = PACKAGE BODY
:OWNER = DATA
18/12/2007 12:00:08 p.m. TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0.016
18/12/2007 12:00:08 p.m. ProcEditForm.GetTabNames
18/12/2007 12:00:08 p.m. + piv_ventana_sagis_mmx
18/12/2007 12:00:08 p.m. ProcEditForm.GetTabNames done
18/12/2007 12:00:08 p.m. UpdateContents(Clear)
18/12/2007 12:00:08 p.m. Source = CREATE OR REPLACE PACKAGE BODY piv_ventana_sagis_mmx IS
18/12/2007 12:00:08 p.m. UpdatingContents: Thread Started
18/12/2007 12:00:08 p.m. ContentsThread: Execute
18/12/2007 12:00:08 p.m. ContentsThread: Analyze
18/12/2007 12:00:08 p.m. ContentsThread: Valid
18/12/2007 12:00:08 p.m. ContentsThread: Suspend started
18/12/2007 12:00:09 p.m. NavigationBookmarks.EnableButtons(Rebuild)
18/12/2007 12:00:09 p.m. NavigationBookmarks: Backward=0, Forward=0
18/12/2007 12:00:09 p.m. ContentsUpdated
18/12/2007 12:00:09 p.m. ContentsUpdated: Valid
18/12/2007 12:00:09 p.m. ContentsUpdated: Refresh Code Contents
18/12/2007 12:00:09 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:09 p.m. AddPlugInPopups End
18/12/2007 12:00:09 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:09 p.m. AddPlugInPopups End
18/12/2007 12:00:09 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:09 p.m. AddPlugInPopups End
18/12/2007 12:00:09 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:09 p.m. AddPlugInPopups End
18/12/2007 12:00:10 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:10 p.m. AddPlugInPopups End
18/12/2007 12:00:10 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:10 p.m. AddPlugInPopups End
18/12/2007 12:00:10 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if
bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner =
bject_owner
and object_name =
bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
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.all_constraints c
where c.constraint_name =
art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name,
art3
into
bject_type,
bject_owner,
bject_name, :sub_object
from sys.all_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;
:sub_object :=
art2;
if
part2 is null) or
part1 != user) then
begin
select object_type, user,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_objects
where owner = user
and object_name =
art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if
bject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object :=
art2;
if
art3 is not null then
:sub_object := :sub_object || '.' ||
art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object :=
art3;
begin
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner =
art1
and o.object_name =
art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if
art2 is null and
art3 is null
then
select 'USER', null,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_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;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = L_MAX_SPTO
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =
:SUB_OBJECT = Null
ART3 =
EEP = 1
18/12/2007 12:00:10 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.047
18/12/2007 12:00:10 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:10 p.m. AddPlugInPopups End
18/12/2007 12:00:10 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:10 p.m. AddPlugInPopups End
18/12/2007 12:00:11 p.m. AddNavigationBookmark starts
18/12/2007 12:00:11 p.m. AddNavigationBookmark GNV00001
18/12/2007 12:00:11 p.m. NavigationBookmarks.EnableButtons(Rebuild)
18/12/2007 12:00:11 p.m. NavigationBookmarks: Backward=1, Forward=0
18/12/2007 12:00:11 p.m. AddNavigationBookmark ends
18/12/2007 12:00:11 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if
bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner =
bject_owner
and object_name =
bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
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.all_constraints c
where c.constraint_name =
art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name,
art3
into
bject_type,
bject_owner,
bject_name, :sub_object
from sys.all_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;
:sub_object :=
art2;
if
part2 is null) or
part1 != user) then
begin
select object_type, user,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_objects
where owner = user
and object_name =
art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if
bject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object :=
art2;
if
art3 is not null then
:sub_object := :sub_object || '.' ||
art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object :=
art3;
begin
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner =
art1
and o.object_name =
art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if
art2 is null and
art3 is null
then
select 'USER', null,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_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;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = DATA
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 = PIV_VENTANA_SAGIS_MMX
:SUB_OBJECT = Null
ART3 = P_OBT_NUM_SINIESTRO_MIN
EEP = 0
18/12/2007 12:00:11 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Result = ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 264
ORA-06512: at line 49
Duration = 0.015
18/12/2007 12:00:20 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:20 p.m. AddPlugInPopups End
18/12/2007 12:00:20 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:20 p.m. AddPlugInPopups End
18/12/2007 12:00:20 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:20 p.m. AddPlugInPopups End
18/12/2007 12:00:20 p.m. AddPlugInPopups Start 0
18/12/2007 12:00:20 p.m. AddPlugInPopups End
18/12/2007 12:00:22 p.m. AddNavigationBookmark starts
18/12/2007 12:00:22 p.m. AddNavigationBookmark GNV00002
18/12/2007 12:00:22 p.m. NavigationBookmarks.EnableButtons(Rebuild)
18/12/2007 12:00:22 p.m. NavigationBookmarks: Backward=2, Forward=0
18/12/2007 12:00:22 p.m. AddNavigationBookmark ends
18/12/2007 12:00:22 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if
bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner =
bject_owner
and object_name =
bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
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.all_constraints c
where c.constraint_name =
art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name,
art3
into
bject_type,
bject_owner,
bject_name, :sub_object
from sys.all_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;
:sub_object :=
art2;
if
part2 is null) or
part1 != user) then
begin
select object_type, user,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_objects
where owner = user
and object_name =
art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if
bject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object :=
art2;
if
art3 is not null then
:sub_object := :sub_object || '.' ||
art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name =
art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object :=
art3;
begin
select o.object_type, o.owner, o.object_name
into
bject_type,
bject_owner,
bject_name
from sys.all_objects o
where o.owner =
art1
and o.object_name =
art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if
art2 is null and
art3 is null
then
select 'USER', null,
art1
into
bject_type,
bject_owner,
bject_name
from sys.all_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;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = DATA
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 = PIV_VENTANA_SAGIS_MMX
:SUB_OBJECT = Null
ART3 = P_POLIZA_DATOVAR
EEP = 0
18/12/2007 12:00:22 p.m. TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Result = ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 264
ORA-06512: at line 49
Duration = 0.015
