PL/SQL Developer
Version 7.1.4.1390
Windows Vista 6.0 Build 6000
Physical memory : 2,094,592 kB (611,280 available)
Paging file : 4,194,304 kB (2,309,692 available)
Virtual memory : 2,097,024 kB (1,997,300 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Preference Files
Plug-Ins
13/03/2008 9:19:06 AM Application started
13/03/2008 9:19:06 AM InitPreferences
13/03/2008 9:19:06 AM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
13/03/2008 9:19:06 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
13/03/2008 9:19:06 AM PreferenceSet.Load OK
13/03/2008 9:19:06 AM Determine LocalPrefPath
13/03/2008 9:19:06 AM [1]: C:\Program Files\PLSQL Developer\Preferences
13/03/2008 9:19:06 AM LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\richardc
13/03/2008 9:19:06 AM Load C:\Program Files\PLSQL Developer\Preferences\richardc = 0
13/03/2008 9:19:06 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\richardc\default.ini
13/03/2008 9:19:06 AM PreferenceSet.Load OK
13/03/2008 9:19:06 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\richardc\user.prefs
13/03/2008 9:19:06 AM PreferenceSet.Load OK
13/03/2008 9:19:06 AM InitPreferences end
13/03/2008 9:19:06 AM SortPreferenceSets
13/03/2008 9:19:06 AM - Default richardc
13/03/2008 9:19:06 AM - System Default
13/03/2008 9:19:06 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
13/03/2008 9:19:06 AM ReadString OK
13/03/2008 9:19:06 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
13/03/2008 9:19:06 AM LoadPreferences
13/03/2008 9:19:06 AM LoadPreferences searching for default
13/03/2008 9:19:06 AM C:\Program Files\PLSQL Developer\Preferences\richardc\default.ini
13/03/2008 9:19:06 AM LoadPreferences NewPref := nil
13/03/2008 9:19:06 AM LoadPreferences
13/03/2008 9:19:06 AM LoadPreferences Reading preferences
13/03/2008 9:19:06 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
13/03/2008 9:19:06 AM ReadString OK
13/03/2008 9:19:06 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
13/03/2008 9:19:06 AM LoadPreferences ReadPosition
13/03/2008 9:19:06 AM LoadPreferences ToolsBrowserItemClick(nil)
13/03/2008 9:19:06 AM LoadPreferences CreateBrowserFilters...
13/03/2008 9:19:06 AM LoadPreferences Files
13/03/2008 9:19:06 AM LoadPreferences Logon
13/03/2008 9:19:06 AM LoadPreferences Buttons
13/03/2008 9:19:06 AM LoadPreferences Printer
13/03/2008 9:19:06 AM LoadPreferences BrowserFolders
13/03/2008 9:19:06 AM LoadPreferences
13/03/2008 9:19:06 AM LoadPreferences end
13/03/2008 9:19:06 AM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\richardc.emlib
13/03/2008 9:19:06 AM FormCreate Logon.Execute
13/03/2008 9:19:09 AM TOracleSession PLSQLDevForm.Session Start Session.LogOn as domtest@dnrdev01
13/03/2008 9:19:10 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
13/03/2008 9:19:10 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
13/03/2008 9:19:10 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/03/2008 9:19:10 AM TOracleQuery Query End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleSession PLSQLDevForm.Session End
Duration = 0.25
13/03/2008 9:19:10 AM LogonHistorySave start
13/03/2008 9:19:10 AM ChangeUserPref LogonHistory,
13/03/2008 9:19:10 AM ChangeUserPref DSA,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref ColumnAssociations,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref ImportAssociations,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref BrowserFilters,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref BrowserFolders,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref SessionQueries,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref ExternalTools,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref Documents,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM ChangeUserPref Reports,
13/03/2008 9:19:10 AM ChangeUserPref end
13/03/2008 9:19:10 AM LogonHistorySave end
13/03/2008 9:19:10 AM FormCreate Session.Connected
13/03/2008 9:19:10 AM FormCreate Logon.Executed -1
13/03/2008 9:19:10 AM FormCreate TDBNames.Make
13/03/2008 9:19:10 AM FormCreate SessionChanged
13/03/2008 9:19:10 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
13/03/2008 9:19:10 AM TOracleQuery Query End (5 records processed)
Duration = 0
13/03/2008 9:19:10 AM SessionChanged SetDBAViews
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End (0 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
13/03/2008 9:19:10 AM SessionChanged Authorizations.Load
13/03/2008 9:19:10 AM TOracleQuery $03270760 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)
13/03/2008 9:19:10 AM TOracleQuery $03270760 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
13/03/2008 9:19:10 AM SessionChanged EnableAuthorizedMenus
13/03/2008 9:19:10 AM TOracleSession $01E7F1D0 Start Session.LogOn as domtest@dnrdev01
13/03/2008 9:19:10 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/03/2008 9:19:10 AM TOracleQuery Query End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleSession $01E7F1D0 End
Duration = 0.172
13/03/2008 9:19:10 AM SetSessionAction starts: Main session
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = select null from dual
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
13/03/2008 9:19:10 AM TOracleQuery $03270A20 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')
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End
Duration = 0
13/03/2008 9:19:10 AM SetSessionAction ends
13/03/2008 9:19:10 AM ExecuteConnectScript starts
13/03/2008 9:19:10 AM ExecuteConnectScript ends
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.015
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM SessionChanged LoadRecentObjects
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM SessionChanged Notify children
13/03/2008 9:19:10 AM SessionChanged Logoff secondary sessions
13/03/2008 9:19:10 AM SessionChanged SessionMode = smMulti
13/03/2008 9:19:10 AM SessionChanged EnableChildFunctions
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (78 records processed)
Duration = 0.016
13/03/2008 9:19:10 AM TOracleQuery $03270A20 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', 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')
13/03/2008 9:19:10 AM 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
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.141
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.015
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.016
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM SortPreferenceSets
13/03/2008 9:19:10 AM - Default richardc
13/03/2008 9:19:10 AM - System Default
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End (0 records processed)
Duration = 0.016
13/03/2008 9:19:10 AM TOracleQuery $032708C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
13/03/2008 9:19:10 AM TOracleQuery $032708C0 End
Result = ORA-00942: table or view does not exist
Duration = 0
13/03/2008 9:19:10 AM WMUpdatePopups starts
13/03/2008 9:19:10 AM LoadDesktop starts
13/03/2008 9:19:10 AM Create TProcEditForm Start
13/03/2008 9:19:10 AM Create TProcEditForm Inherited
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.281
13/03/2008 9:19:10 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.031
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.015
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM Create TProcEditForm Activate
13/03/2008 9:19:10 AM Create TProcEditForm Activate done
13/03/2008 9:19:10 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:10 AM Create TProcEditForm Positioning
13/03/2008 9:19:10 AM Create TProcEditForm Finished
13/03/2008 9:19:10 AM TOracleQuery $03270600 Start Query.Execute
SQL = select /*+rule*/ text from sys.all_source
where owner =

wner
and name = :name
and type = :type
order by line
:OWNER = DOMTEST
:NAME = CMD_LOGIN_T
:TYPE = TYPE BODY
13/03/2008 9:19:10 AM TOracleQuery $03270600 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270600 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270600 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270600 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270600 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270600 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270600 End (62 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select /*+rule*/ *
from sys.all_errors
where name = :name and type = :type and owner =

wner
order by sequence
:NAME = CMD_LOGIN_T
:TYPE = TYPE BODY
:OWNER = DOMTEST
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.032
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM ProcEditForm.GetTabNames
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0.015
13/03/2008 9:19:10 AM + cmd_login_t
13/03/2008 9:19:10 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (100 records processed)
Duration = 0
13/03/2008 9:19:10 AM TOracleQuery $03270A20 Start Query.Next for up to 100 records
13/03/2008 9:19:10 AM TOracleQuery $03270A20 End (66 records processed)
Duration = 0.016
13/03/2008 9:19:10 AM TOracleSession $01E7F1D0 Start Session.LogOff
13/03/2008 9:19:10 AM TOracleSession $01E7F1D0 End
Duration = 0
13/03/2008 9:19:10 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:10 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:10 AM UpdateContents(Clear)
13/03/2008 9:19:10 AM Source = create or replace type body cmd_login_t as
13/03/2008 9:19:11 AM UpdatingContents: Thread Started
13/03/2008 9:19:11 AM ContentsThread: Execute
13/03/2008 9:19:11 AM ContentsThread: Analyze
13/03/2008 9:19:11 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:11 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:11 AM Create TProcEditForm Start
13/03/2008 9:19:11 AM Create TProcEditForm Inherited
13/03/2008 9:19:11 AM ContentsThread: Valid
13/03/2008 9:19:11 AM ContentsThread: Suspend started
13/03/2008 9:19:11 AM AddNavigationBookmark starts
13/03/2008 9:19:11 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:11 AM Create TProcEditForm Activate
13/03/2008 9:19:11 AM Create TProcEditForm Activate done
13/03/2008 9:19:11 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:11 AM Create TProcEditForm Positioning
13/03/2008 9:19:11 AM Create TProcEditForm Finished
13/03/2008 9:19:11 AM TOracleQuery $032704A0 Start Query.Execute
SQL = select /*+rule*/ text from sys.all_source
where owner =

wner
and name = :name
and type = :type
order by line
:OWNER = DOMTEST
:NAME = CMD_MSG_ACKNOWLEDGE_T
:TYPE = TYPE BODY
13/03/2008 9:19:11 AM TOracleQuery $032704A0 End (100 records processed)
Duration = 0
13/03/2008 9:19:11 AM TOracleQuery $032704A0 Start Query.Next for up to 100 records
13/03/2008 9:19:11 AM TOracleQuery $032704A0 End (1 record processed)
Duration = 0
13/03/2008 9:19:11 AM TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select /*+rule*/ *
from sys.all_errors
where name = :name and type = :type and owner =

wner
order by sequence
:NAME = CMD_MSG_ACKNOWLEDGE_T
:TYPE = TYPE BODY
:OWNER = DOMTEST
13/03/2008 9:19:11 AM TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0.016
13/03/2008 9:19:11 AM ProcEditForm.GetTabNames
13/03/2008 9:19:11 AM + cmd_msg_acknowledge_t
13/03/2008 9:19:11 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:11 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:11 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:11 AM UpdateContents(Clear)
13/03/2008 9:19:11 AM Source = create or replace type body cmd_msg_acknowledge_t
13/03/2008 9:19:11 AM UpdatingContents: Thread Started
13/03/2008 9:19:11 AM ContentsThread: Execute
13/03/2008 9:19:11 AM ContentsThread: Analyze
13/03/2008 9:19:11 AM ContentsThread: Valid
13/03/2008 9:19:11 AM ContentsThread: Suspend started
13/03/2008 9:19:11 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:11 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:11 AM Create TSQLForm Start
13/03/2008 9:19:11 AM Create TSQLForm Inherited
13/03/2008 9:19:11 AM TSQLForm.FormCreate Start
13/03/2008 9:19:11 AM SQLForm
13/03/2008 9:19:11 AM TSQLForm.FormCreate Finished
13/03/2008 9:19:11 AM AddNavigationBookmark starts
13/03/2008 9:19:11 AM Create TSQLForm SetupMainFont
13/03/2008 9:19:11 AM Create TSQLForm Activate
13/03/2008 9:19:11 AM Create TSQLForm Activate done
13/03/2008 9:19:11 AM Create TSQLForm UpdateWindowList
13/03/2008 9:19:11 AM Create TSQLForm Positioning
13/03/2008 9:19:11 AM Create TSQLForm Finished
13/03/2008 9:19:11 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_acknowledge_all_t.sql = 4:14:10 PM
13/03/2008 9:19:11 AM SQLForm
13/03/2008 9:19:11 AM Create TProcEditForm Start
13/03/2008 9:19:11 AM Create TProcEditForm Inherited
13/03/2008 9:19:11 AM AddNavigationBookmark starts
13/03/2008 9:19:11 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:11 AM Create TProcEditForm Activate
13/03/2008 9:19:11 AM Create TProcEditForm Activate done
13/03/2008 9:19:11 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:11 AM Create TProcEditForm Positioning
13/03/2008 9:19:11 AM Create TProcEditForm Finished
13/03/2008 9:19:11 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_acknowledge_all_t.plb = 4:21:16 PM
13/03/2008 9:19:11 AM ProcEditForm.GetTabNames
13/03/2008 9:19:11 AM + cmd_msg_acknowledge_all_t
13/03/2008 9:19:11 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:11 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:11 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:11 AM UpdateContents(Clear)
13/03/2008 9:19:11 AM Source = create or replace type body cmd_msg_acknowledge_all_t as
13/03/2008 9:19:11 AM UpdatingContents: Thread Started
13/03/2008 9:19:11 AM Create TSQLForm Start
13/03/2008 9:19:11 AM ContentsThread: Execute
13/03/2008 9:19:11 AM Create TSQLForm Inherited
13/03/2008 9:19:11 AM ContentsThread: Analyze
13/03/2008 9:19:11 AM ContentsThread: Valid
13/03/2008 9:19:11 AM ContentsThread: Suspend started
13/03/2008 9:19:11 AM TSQLForm.FormCreate Start
13/03/2008 9:19:11 AM SQLForm
13/03/2008 9:19:11 AM TSQLForm.FormCreate Finished
13/03/2008 9:19:11 AM AddNavigationBookmark starts
13/03/2008 9:19:11 AM Create TSQLForm SetupMainFont
13/03/2008 9:19:11 AM Create TSQLForm Activate
13/03/2008 9:19:11 AM Create TSQLForm Activate done
13/03/2008 9:19:11 AM Create TSQLForm UpdateWindowList
13/03/2008 9:19:11 AM Create TSQLForm Positioning
13/03/2008 9:19:11 AM Create TSQLForm Finished
13/03/2008 9:19:11 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_confirm_t.sql = 4:37:56 PM
13/03/2008 9:19:11 AM SQLForm
13/03/2008 9:19:11 AM Create TProcEditForm Start
13/03/2008 9:19:11 AM Create TProcEditForm Inherited
13/03/2008 9:19:11 AM AddNavigationBookmark starts
13/03/2008 9:19:11 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:11 AM Create TProcEditForm Activate
13/03/2008 9:19:11 AM Create TProcEditForm Activate done
13/03/2008 9:19:11 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:11 AM Create TProcEditForm Positioning
13/03/2008 9:19:11 AM Create TProcEditForm Finished
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_confirm_t.plb = 4:40:36 PM
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames
13/03/2008 9:19:12 AM + cmd_msg_confirm_t
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:12 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:12 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:12 AM UpdateContents(Clear)
13/03/2008 9:19:12 AM Source = create or replace type body cmd_msg_confirm_t as
13/03/2008 9:19:12 AM UpdatingContents: Thread Started
13/03/2008 9:19:12 AM Create TProcEditForm Start
13/03/2008 9:19:12 AM ContentsThread: Execute
13/03/2008 9:19:12 AM ContentsThread: Analyze
13/03/2008 9:19:12 AM Create TProcEditForm Inherited
13/03/2008 9:19:12 AM ContentsThread: Valid
13/03/2008 9:19:12 AM ContentsThread: Suspend started
13/03/2008 9:19:12 AM AddNavigationBookmark starts
13/03/2008 9:19:12 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:12 AM Create TProcEditForm Activate
13/03/2008 9:19:12 AM Create TProcEditForm Activate done
13/03/2008 9:19:12 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:12 AM Create TProcEditForm Positioning
13/03/2008 9:19:12 AM Create TProcEditForm Finished
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\packages\web.pls = 9:06:20 AM
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames
13/03/2008 9:19:12 AM + web
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:12 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:12 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:12 AM UpdateContents(Clear)
13/03/2008 9:19:12 AM Source = create or replace package web is
13/03/2008 9:19:12 AM UpdatingContents: Thread Started
13/03/2008 9:19:12 AM Create TProcEditForm Start
13/03/2008 9:19:12 AM ContentsThread: Execute
13/03/2008 9:19:12 AM ContentsThread: Analyze
13/03/2008 9:19:12 AM Create TProcEditForm Inherited
13/03/2008 9:19:12 AM ContentsThread: Valid
13/03/2008 9:19:12 AM ContentsThread: Suspend started
13/03/2008 9:19:12 AM AddNavigationBookmark starts
13/03/2008 9:19:12 AM Create TProcEditForm SetupMainFont
13/03/2008 9:19:12 AM Create TProcEditForm Activate
13/03/2008 9:19:12 AM Create TProcEditForm Activate done
13/03/2008 9:19:12 AM Create TProcEditForm UpdateWindowList
13/03/2008 9:19:12 AM Create TProcEditForm Positioning
13/03/2008 9:19:12 AM Create TProcEditForm Finished
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\packages\web.plb = 9:05:36 AM
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames
13/03/2008 9:19:12 AM + web
13/03/2008 9:19:12 AM ProcEditForm.GetTabNames done
13/03/2008 9:19:12 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:12 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:12 AM UpdateContents(Clear)
13/03/2008 9:19:12 AM Source = create or replace package body web is
13/03/2008 9:19:12 AM UpdatingContents: Thread Started
13/03/2008 9:19:12 AM ContentsThread: Execute
13/03/2008 9:19:12 AM ContentsThread: Analyze
13/03/2008 9:19:12 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:12 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:12 AM ContentsThread: Valid
13/03/2008 9:19:12 AM ContentsThread: Suspend started
13/03/2008 9:19:12 AM LoadDesktop ends
13/03/2008 9:19:12 AM WMUpdatePopups ends
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 4:14:10 PM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_acknowledge_all_t.sql = 4:14:10 PM
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 4:21:16 PM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_acknowledge_all_t.plb = 4:21:16 PM
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 4:37:56 PM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_confirm_t.sql = 4:37:56 PM
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 4:40:36 PM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\types\cmd_msg_confirm_t.plb = 4:40:36 PM
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 9:06:20 AM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\packages\web.pls = 9:06:20 AM
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:12 AM CheckFileDate WindowFileDate = 9:05:36 AM
13/03/2008 9:19:12 AM FileAge: C:\workspace\database\src\database\packages\web.plb = 9:05:36 AM
13/03/2008 9:19:12 AM ContentsUpdated
13/03/2008 9:19:12 AM ContentsUpdated: Valid
13/03/2008 9:19:12 AM ContentsUpdated: Refresh Code Contents
13/03/2008 9:19:24 AM Create TTestForm Start
13/03/2008 9:19:24 AM Create TTestForm Inherited
13/03/2008 9:19:24 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:24 AM NavigationBookmarks: Backward=0, Forward=0
13/03/2008 9:19:24 AM AddNavigationBookmark starts
13/03/2008 9:19:24 AM AddNavigationBookmark GNV00001
13/03/2008 9:19:24 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:24 AM NavigationBookmarks: Backward=1, Forward=0
13/03/2008 9:19:24 AM AddNavigationBookmark ends
13/03/2008 9:19:24 AM Create TTestForm SetupMainFont
13/03/2008 9:19:24 AM Create TTestForm Activate
13/03/2008 9:19:24 AM Create TTestForm Activate done
13/03/2008 9:19:24 AM Create TTestForm UpdateWindowList
13/03/2008 9:19:25 AM Create TTestForm Positioning
13/03/2008 9:19:25 AM Create TTestForm Finished
13/03/2008 9:19:25 AM FileAge: C:\Users\richardc\webContactUpdate.tst = 4:03:40 PM
13/03/2008 9:19:25 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:25 AM NavigationBookmarks: Backward=1, Forward=0
13/03/2008 9:19:25 AM CheckFileDate WindowFileDate = 4:03:40 PM
13/03/2008 9:19:25 AM FileAge: C:\Users\richardc\webContactUpdate.tst = 4:03:40 PM
13/03/2008 9:19:34 AM EditCopy
13/03/2008 9:19:34 AM Screen.ActiveCustomForm EditCopy
13/03/2008 9:19:34 AM ChildForm.EditCopy
13/03/2008 9:19:38 AM Create TSQLForm Start
13/03/2008 9:19:38 AM Create TSQLForm Inherited
13/03/2008 9:19:38 AM TSQLForm.FormCreate Start
13/03/2008 9:19:38 AM SQLForm
13/03/2008 9:19:38 AM TSQLForm.FormCreate Finished
13/03/2008 9:19:38 AM AddNavigationBookmark starts
13/03/2008 9:19:38 AM AddNavigationBookmark GNV00002
13/03/2008 9:19:38 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:38 AM NavigationBookmarks: Backward=2, Forward=0
13/03/2008 9:19:38 AM AddNavigationBookmark ends
13/03/2008 9:19:38 AM Create TSQLForm SetupMainFont
13/03/2008 9:19:38 AM Create TSQLForm Activate
13/03/2008 9:19:38 AM Create TSQLForm Activate done
13/03/2008 9:19:38 AM Create TSQLForm UpdateWindowList
13/03/2008 9:19:38 AM Create TSQLForm Positioning
13/03/2008 9:19:38 AM Create TSQLForm Finished
13/03/2008 9:19:38 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:19:38 AM NavigationBookmarks: Backward=2, Forward=0
13/03/2008 9:20:01 AM EditCopy
13/03/2008 9:20:01 AM Screen.ActiveCustomForm EditCopy
13/03/2008 9:20:01 AM ChildForm.EditCopy
13/03/2008 9:20:11 AM EditCopy
13/03/2008 9:20:11 AM Screen.ActiveCustomForm EditCopy
13/03/2008 9:20:11 AM ChildForm.EditCopy
13/03/2008 9:20:13 AM AddNavigationBookmark starts
13/03/2008 9:20:13 AM AddNavigationBookmark GNV00003
13/03/2008 9:20:13 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:20:13 AM NavigationBookmarks: Backward=3, Forward=0
13/03/2008 9:20:13 AM AddNavigationBookmark ends
13/03/2008 9:20:13 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:20:13 AM NavigationBookmarks: Backward=3, Forward=0
13/03/2008 9:20:13 AM CheckFileDate WindowFileDate = 4:03:40 PM
13/03/2008 9:20:13 AM FileAge: C:\Users\richardc\webContactUpdate.tst = 4:03:40 PM
13/03/2008 9:20:23 AM CheckFileDate WindowFileDate = 4:03:40 PM
13/03/2008 9:20:23 AM FileAge: C:\Users\richardc\webContactUpdate.tst = 4:03:40 PM
13/03/2008 9:20:23 AM FileAge: C:\Users\richardc\webContactUpdate.tst = 9:20:24 AM
13/03/2008 9:20:26 AM SetConnected starts
13/03/2008 9:20:26 AM SetConnected: Connect starts
13/03/2008 9:20:26 AM TOracleSession $0601F460 Start Session.LogOn as domtest@dnrdev01
13/03/2008 9:20:26 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/03/2008 9:20:26 AM TOracleQuery Query End (1 record processed)
Duration = 0
13/03/2008 9:20:26 AM TOracleSession $0601F460 End
Duration = 0.219
13/03/2008 9:20:26 AM SetConnected: (Dis)connect ends
13/03/2008 9:20:26 AM SetSessionAction starts: Test Window - C:\Users\richardc\webContactUpdate.tst
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 Start Query.Execute
SQL = select null from dual
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 End (1 record processed)
Duration = 0
13/03/2008 9:20:26 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
13/03/2008 9:20:26 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/03/2008 9:20:26 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
13/03/2008 9:20:26 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - C:\Users\richardc\webContactUpdate.tst
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 End
Duration = 0
13/03/2008 9:20:26 AM SetSessionAction ends
13/03/2008 9:20:26 AM ExecuteConnectScript starts
13/03/2008 9:20:26 AM ExecuteConnectScript ends
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 End
Result = ORA-00942: table or view does not exist
Duration = 0.015
13/03/2008 9:20:26 AM InitHTPOutput starts
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
13/03/2008 9:20:26 AM TOracleQuery $0465D8D0 End
Duration = 0
13/03/2008 9:20:26 AM InitHTPOutput finished
13/03/2008 9:20:26 AM EnableOutput starts
13/03/2008 9:20:26 AM TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable

size);
end if;
end;
:ENABLE = 1
:SIZE = 1000000
13/03/2008 9:20:26 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
13/03/2008 9:20:26 AM EnableOutput done
13/03/2008 9:20:26 AM InitStatistics starts
13/03/2008 9:20:26 AM TStatistics.Init starts
13/03/2008 9:20:26 AM TStatistics.Init ends
13/03/2008 9:20:26 AM InitStatistics ends
13/03/2008 9:20:26 AM NavigationBookmarks.EnableButtons(Rebuild)
13/03/2008 9:20:26 AM NavigationBookmarks: Backward=3, Forward=0
13/03/2008 9:20:26 AM TSQLThread SQLThread.Execute
13/03/2008 9:20:26 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
13/03/2008 9:20:26 AM TOracleQuery Query End
Duration = 0
13/03/2008 9:20:26 AM TOracleQuery TestForm.TestQuery Start Query.Execute
SQL = declare
-- Non-scalar parameters require additional processing
result web_transaction_t;
add_fields web_con_add_rem_t;
rem_fields web_con_add_rem_t;
chg_fields web_con_chg_t;
l_session session_t;
l_connection connection_t := connection_t();
l_connection_id integer;
connection_id number;
l_user user_t;
l_webuser web_user_t;
l_contact contact_t;
procedure endsession is
l_status integer;
begin
l_status := l_session.end_session('Whitelist Search');
dbms_output.put_line('End session = ' ||
dnr_response.error_msg(l_status));
end endsession;
procedure start_session is
l_status integer;
urns urn_list_t := urn_list_t();
ll_user varchar2(30 char) := :web_user;
begin
l_session := new session_t;
l_connection := new connection_t;
l_session.client_ip := 'FRED';
l_session.language := 'en';
l_status := user_t.get(ll_user, l_session.session_user);
dbms_output.put_line('User get = ' ||
dnr_response.error_msg(l_status));
l_status := l_session.start_session(l_connection);
dbms_output.put_line('Session start = ' ||
dnr_response.error_msg(l_status));
dbms_output.put_line('SESSSION_ID = ' || l_session.id);
l_user := user_t.get(ll_user);
l_webuser := web_user_t(l_user);
:session := l_session.id;
dbms_output.put_line('SESSSION_ID = ' || l_session.id);
l_user := user_t.get(ll_user);
l_webuser := web_user_t(l_user);
exception
when others then
endsession;
raise;
end start_session;
begin
start_session;
l_contact := contact_t.get

contact_id);
chg_fields := web_con_chg_t(web_chg_postalinfo_t(web_postalline_t(l_contact.address_int.name.value),
web_postalline_t(l_contact.address_int.org.value),
web_con_addr_t(l_contact.address_int.street1.value,
l_contact.address_int.street2.value,
l_contact.address_int.street3.value,
l_contact.address_int.city.value,
l_contact.address_int.state.value,
l_contact.address_int.postcode.value,
l_contact.address_int.country)),
null,
web_e164_t(e164_t('+61.'||l_contact.phone.string,null)),
null,
web_email_t(l_contact.email.value),
null);
-- Call the function
result := web_contact.contact_update(session => :session,
web_session => :web_session,
contact_id => :contact_id,
add_fields => add_fields,
rem_fields => rem_fields,
chg_fields => chg_fields,
sponsor_name => :sponsor_name);
-- Modify the code to output the variable
dbms_output.put_line('Command: ' || result.command);
dbms_output.put_line('Audit log: ' || result.audit_log);
dbms_output.put_line('Response Code: ' || result.response_code);
dbms_output.put_line('Response Code message: ' ||
dnr_response.error_msg(result.response_code));
l_contact := contact_t.get

contact_id);
chg_fields := web_con_chg_t(web_chg_postalinfo_t(web_postalline_t(l_contact.address_int.name.value),
web_postalline_t(l_contact.address_int.org.value),
web_con_addr_t(l_contact.address_int.street1.value,
l_contact.address_int.street2.value,
l_contact.address_int.street3.value,
l_contact.address_int.city.value,
l_contact.address_int.state.value,
l_contact.address_int.postcode.value,
l_contact.address_int.country)),
null,
web_e164_t(l_contact.phone),
null,
web_email_t

email),
null);
-- Call the function
result := web_contact.contact_update(session => :session,
web_session => :web_session,
contact_id => :contact_id,
add_fields => add_fields,
rem_fields => rem_fields,
chg_fields => chg_fields,
sponsor_name => :sponsor_name);
-- Modify the code to output the variable
dbms_output.put_line('Command: ' || result.command);
dbms_output.put_line('Audit log: ' || result.audit_log);
dbms_output.put_line('Response Code: ' || result.response_code);
dbms_output.put_line('Response Code message: ' ||
dnr_response.error_msg(result.response_code));
endsession;
end;
:SESSION = Null
:WEB_SESSION = FRED
:CONTACT_ID = CON-1
:SPONSOR_NAME = Null
:WEB_USER = registrar
:EMAIL = x@y.co.xx
13/03/2008 9:20:27 AM TOracleQuery TestForm.TestQuery End
Duration = 0.86
13/03/2008 9:20:27 AM TSQLThread SQLThread Postmessage
13/03/2008 9:20:27 AM TSQLThread SQLThread Suspend