Print Thread
V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
#43187 01/23/12 02:50 PM
Joined: Jan 2012
Posts: 2
C
chrj Offline OP
Member
OP Offline
Member
C
Joined: Jan 2012
Posts: 2
Hi all,

I try to migrate from Oracle Sql Developer to PL/SQL Developer.

I have no experience with it. I have installed it and it looks like, that it got all connection definition to our different Oracle DBs from the tns file.

But when I do a simple SELECT and press F8, I always get the error:

Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E

After pressing F8, I have the following info in the status bar: Initializing..., Executing... here the pl/sql dev starts to display the column names. After that I get the same error all the time. The result area of the sql window I can see the column names, but no records.

I have V9.0.4.1644. I haven't found any log in the installation folder.

Any ideas? Thanks in advance,
Christopher

Re: V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
chrj #43192 01/24/12 10:35 AM
Joined: Aug 1999
Posts: 22,175
Member
Offline
Member
Joined: Aug 1999
Posts: 22,175
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:\Users\<User>\AppData\Roaming\PLSQL Developer).


Marco Kalter
Allround Automations
Re: V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
Marco Kalter #43211 01/25/12 11:36 AM
Joined: Jan 2012
Posts: 2
C
chrj Offline OP
Member
OP Offline
Member
C
Joined: Jan 2012
Posts: 2
Hi Marco,

What happens in the background, when using the paramter 'DebugSQL'?

Before I have tried it with the paramter the PL/SQl Dev was still open. Before I closed the app, I got the error as all the time.

Then I have closed and started it with parameter DebugSQL. Since then I never got the error again. Even without the parameter - no problem. strange...

Anyway, now it works.


Thanks,
Christopher

Re: V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
chrj #43213 01/26/12 10:53 AM
Joined: Aug 1999
Posts: 22,175
Member
Offline
Member
Joined: Aug 1999
Posts: 22,175
DebugSQL causes PL/SQL Developer to log all database activities and other diagnostic information to a file. There are no other side-effects.


Marco Kalter
Allround Automations
Re: V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
Marco Kalter #43245 01/31/12 04:39 PM
Joined: Jan 2012
Posts: 1
F
Member
Offline
Member
F
Joined: Jan 2012
Posts: 1
I wanted to report the exact same issue that chrj reported, with exactly the same behaviour when I ran PLSQL developer with the DebugSQL paramter.

I have just upgraded from version 8 to 9.04, then I tried it with 9.05, hoping the newest version would resolve the error.

I was receiving both the "Invalid Filename" error and the Access violation at address..." error. Sometimes one, sometimes the other, never both at one time. It seemed to change when I closed and reopened the application, but remained consistent until it was closed again.

I ran it with the DebugSQL parameter and now it works just fine, even when I run it without.

I can't reproduce the error with DebugSQL turned on.

Re: V9.0.4.1644: Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
FGFGH #44043 06/05/12 12:53 PM
Joined: Jun 2012
Posts: 1
B
Member
Offline
Member
B
Joined: Jun 2012
Posts: 1
I am recieving the same error message - unable to retieve any data.

PL/SQL Developer
Version 9.0.6.1665
Windows 7 6.1 Build 7601 (Service Pack 1)

Physical memory : 2,097,152 kB (1,792,508 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,957,216 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files

Plug-Ins

6/5/2012 8:42:41 AM Application started
6/5/2012 8:42:41 AM InitPreferences
6/5/2012 8:42:41 AM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
6/5/2012 8:42:41 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
6/5/2012 8:42:41 AM PreferenceSet.Load OK
6/5/2012 8:42:41 AM Determine LocalPrefPath
6/5/2012 8:42:41 AM [1]: C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences
6/5/2012 8:42:41 AM LocalPrefPath: C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj
6/5/2012 8:42:41 AM Load C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj = 0
6/5/2012 8:42:41 AM PreferenceSet.Load C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj\default.ini
6/5/2012 8:42:41 AM PreferenceSet.Load OK
6/5/2012 8:42:41 AM PreferenceSet.Load C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj\user.prefs
6/5/2012 8:42:41 AM PreferenceSet.Load OK
6/5/2012 8:42:41 AM InitPreferences end
6/5/2012 8:42:41 AM SortPreferenceSets
6/5/2012 8:42:41 AM - Default xjj5flj
6/5/2012 8:42:41 AM - System Default
6/5/2012 8:42:41 AM DoUpdateChildList
6/5/2012 8:42:41 AM FindPassword starts for xjj5flj@xapprd1
6/5/2012 8:42:41 AM Check current connections...
6/5/2012 8:42:41 AM Check connection definitions...
6/5/2012 8:42:41 AM FindPassword ends for xjj5flj@xapprd1, no result
6/5/2012 8:42:41 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
6/5/2012 8:42:41 AM ReadString OK
6/5/2012 8:42:41 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\PLSQLDev.exe" "%1"
6/5/2012 8:42:41 AM LoadPreferences
6/5/2012 8:42:41 AM LoadPreferences searching for default
6/5/2012 8:42:41 AM C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj\default.ini
6/5/2012 8:42:41 AM LoadPreferences NewPref := nil
6/5/2012 8:42:41 AM LoadPreferences <section 2>
6/5/2012 8:42:41 AM LoadPreferences Reading preferences
6/5/2012 8:42:41 AM LoadPreferences ReadPosition
6/5/2012 8:42:41 AM LoadPreferences ToolsBrowserItemClick(nil)
6/5/2012 8:42:41 AM LoadPreferences CreateBrowserFilters...
6/5/2012 8:42:41 AM LoadPreferences Files
6/5/2012 8:42:41 AM LoadPreferences Buttons
6/5/2012 8:42:41 AM LoadPreferences Printer
6/5/2012 8:42:41 AM LoadPreferences FileBrowserFolders
6/5/2012 8:42:41 AM LoadPreferences Connections
6/5/2012 8:42:41 AM LoadPreferences BrowserFolders
6/5/2012 8:42:41 AM LoadPreferences <section 3>
6/5/2012 8:42:41 AM LoadPreferences end
6/5/2012 8:42:41 AM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\xjj5flj.emlib
6/5/2012 8:42:41 AM Logging on..
6/5/2012 8:42:41 AM Creating new session
6/5/2012 8:42:41 AM Initializing new session
6/5/2012 8:42:41 AM Setting new session parameters
6/5/2012 8:42:41 AM Setting logon session
6/5/2012 8:42:41 AM OCI Initialization starts
6/5/2012 8:42:41 AM OCI Initialization done
6/5/2012 8:42:41 AM OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\ORACLE11G\product\11.2.0\client_1
Found: oci.dll
Using: C:\ORACLE11G\product\11.2.0\client_1\bin\oci.dll
6/5/2012 8:42:41 AM Logon2 starting
6/5/2012 8:42:41 AM Logon2.Execute starts
6/5/2012 8:42:46 AM TOracleSession $0566DED0 Start Session.LogOn as xjj5flj@xapprd1
6/5/2012 8:42:48 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
6/5/2012 8:42:48 AM TOracleQuery Query End (1 record processed)
Duration = 0.062
6/5/2012 8:42:48 AM TOracleSession $0566DED0 End
Duration = 1.638
6/5/2012 8:42:48 AM Logon2.Execute done
6/5/2012 8:42:48 AM Logon2 done
6/5/2012 8:42:48 AM TOracleQuery $056082C0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
6/5/2012 8:42:48 AM TOracleQuery $056082C0 End (1 record processed)
Duration = 0.062
6/5/2012 8:42:48 AM TOracleSession $0566E170 Start Session.LogOn as xjj5flj@xapprd1
6/5/2012 8:42:48 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
6/5/2012 8:42:48 AM TOracleQuery Query End (1 record processed)
Duration = 0.062
6/5/2012 8:42:48 AM TOracleSession $0566E170 End
Duration = 0.609
6/5/2012 8:42:48 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
6/5/2012 8:42:48 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
6/5/2012 8:42:49 AM TOracleQuery Query End (5 records processed)
Duration = 0.063
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.062
6/5/2012 8:42:49 AM TOracleQuery $05608000 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)
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.062
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
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 = XJJ5FLJ
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (0 records processed)
Duration = 0.109
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from sys.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 = XJJ5FLJ
6/5/2012 8:42:49 AM TOracleQuery $05608000 End
Result = ORA-00942: table or view does not exist
Duration = 0.281
6/5/2012 8:42:49 AM LogonHistorySave start
6/5/2012 8:42:49 AM ChangeUserPref LogonHistory,
6/5/2012 8:42:49 AM ChangeUserPref DSA,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref ColumnAssociations,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref ImportAssociations,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref BrowserFilters,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref FileBrowserFolders,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref Connections,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref BrowserFolders,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref SessionQueries,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref ExternalTools,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref Documents,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref Reports,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM ChangeUserPref CurrentConnections,
6/5/2012 8:42:49 AM ChangeUserPref end
6/5/2012 8:42:49 AM PreferenceSet.Save
6/5/2012 8:42:49 AM PreferenceSet Filename = C:\Users\xjj5flj\AppData\Roaming\PLSQL Developer\Preferences\xjj5flj\user.prefs
6/5/2012 8:42:49 AM PreferenceSet AltFile = user.prefs
6/5/2012 8:42:49 AM PreferenceSet.Save end
6/5/2012 8:42:49 AM LogonHistorySave end
6/5/2012 8:42:49 AM FormCreate Logon.Executed -1
6/5/2012 8:42:49 AM FormCreate SessionChanged
6/5/2012 8:42:49 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
6/5/2012 8:42:49 AM TOracleQuery Query End (5 records processed)
Duration = 0.062
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
6/5/2012 8:42:49 AM TOracleQuery $05608000 End (1 record processed)
Duration = 0.062
6/5/2012 8:42:49 AM SessionChanged SetDBAViews
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from all_synonyms where 1=0
6/5/2012 8:42:49 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.062
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.421
6/5/2012 8:42:49 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.047
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.032
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.063
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:49 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.062
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM SessionChanged Authorizations.Load
6/5/2012 8:42:49 AM SessionChanged EnableAuthorizedMenus
6/5/2012 8:42:49 AM WindowAllowed(1)
6/5/2012 8:42:49 AM WindowAllowed done
6/5/2012 8:42:49 AM WindowAllowed(1)
6/5/2012 8:42:49 AM WindowAllowed done
6/5/2012 8:42:49 AM ExecuteConnectScript starts
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.047
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM TOracleQuery $05608000 End
Duration = 0.031
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:49 AM TOracleQuery $05608000 End
Duration = 0.031
6/5/2012 8:42:49 AM ExecuteConnectScript ends
6/5/2012 8:42:49 AM SetSessionAction starts: Primary Session
6/5/2012 8:42:49 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from dual
6/5/2012 8:42:49 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.032
6/5/2012 8:42:49 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM TOracleQuery $05608000 End (1 record processed)
Duration = 0.062
6/5/2012 8:42:50 AM TOracleQuery $05608000 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608000 End
Duration = 0.032
6/5/2012 8:42:50 AM SetSessionAction ends
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM SessionChanged LoadRecentObjects
6/5/2012 8:42:50 AM SessionChanged Notify children
6/5/2012 8:42:50 AM SessionChanged Logoff secondary sessions
6/5/2012 8:42:50 AM SessionChanged EnableChildFunctions
6/5/2012 8:42:50 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\ORACLE11G\product\11.2.0\client_1
Found: oci.dll
Using: C:\ORACLE11G\product\11.2.0\client_1\bin\oci.dll
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM Lock
6/5/2012 8:42:50 AM UnLock
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.062
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.078
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.046
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.062
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.047
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.047
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.046
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.032
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM SortPreferenceSets
6/5/2012 8:42:50 AM - Default xjj5flj
6/5/2012 8:42:50 AM - System Default
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.062
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from all_synonyms where 1=0
6/5/2012 8:42:50 AM TOracleQuery $05608420 End (100 records processed)
Duration = 0.031
6/5/2012 8:42:50 AM TOracleQuery $05608420 Start Query.Next for up to 100 records
6/5/2012 8:42:50 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.062
6/5/2012 8:42:50 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
6/5/2012 8:42:50 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.062
6/5/2012 8:42:50 AM Lock
6/5/2012 8:42:50 AM UnLock
6/5/2012 8:42:51 AM DoUpdateChildList
6/5/2012 8:42:51 AM FormActivate start
6/5/2012 8:42:51 AM FormActivate end
6/5/2012 8:42:51 AM WMUpdatePopups starts
6/5/2012 8:42:51 AM Adding new connection
6/5/2012 8:42:51 AM Username = xjj5flj
6/5/2012 8:42:51 AM Database = xapprd1
6/5/2012 8:42:51 AM LoadDesktop starts
6/5/2012 8:42:51 AM DoUpdateChildList
6/5/2012 8:42:51 AM Lock
6/5/2012 8:42:51 AM Lock
6/5/2012 8:42:51 AM UnLock
6/5/2012 8:42:51 AM UnLock
6/5/2012 8:42:51 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
6/5/2012 8:42:51 AM TOracleQuery Query End (5 records processed)
Duration = 0.062
6/5/2012 8:42:51 AM SessionChanged SetDBAViews
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from all_synonyms where 1=0
6/5/2012 8:42:51 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.062
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
6/5/2012 8:42:51 AM TOracleQuery $05608000 End (0 records processed)
Duration = 0.062
6/5/2012 8:42:51 AM SessionChanged Authorizations.Load
6/5/2012 8:42:51 AM SessionChanged ApplyPreferences
6/5/2012 8:42:51 AM SortPreferenceSets
6/5/2012 8:42:51 AM - Default xjj5flj
6/5/2012 8:42:51 AM - System Default
6/5/2012 8:42:51 AM SessionChanged EnableAuthorizedMenus
6/5/2012 8:42:51 AM WindowAllowed(1)
6/5/2012 8:42:51 AM WindowAllowed done
6/5/2012 8:42:51 AM WindowAllowed(1)
6/5/2012 8:42:51 AM WindowAllowed done
6/5/2012 8:42:51 AM ExecuteConnectScript starts
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
6/5/2012 8:42:51 AM TOracleQuery $05608000 End
Duration = 0.031
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
6/5/2012 8:42:51 AM TOracleQuery $05608420 End (87 records processed)
Duration = 0.702
6/5/2012 8:42:51 AM TOracleQuery $05608420 Start Query.Execute
SQL =
select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema
or o.owner = 'PUBLIC'
:SCHEMA = XJJ5FLJ
6/5/2012 8:42:51 AM TOracleQuery $05608000 End
Duration = 0.032
6/5/2012 8:42:51 AM ExecuteConnectScript ends
6/5/2012 8:42:51 AM SetSessionAction starts: Primary Session
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = select null from dual
6/5/2012 8:42:51 AM TOracleQuery $05608420 End (0 records processed)
Duration = 0.078
6/5/2012 8:42:51 AM TOracleSession $0566E170 Start Session.LogOff
6/5/2012 8:42:51 AM TOracleQuery $05608000 End (1 record processed)
Duration = 0.063
6/5/2012 8:42:51 AM TOracleQuery $05608000 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
6/5/2012 8:42:51 AM TOracleSession $0566E170 End
Duration = 0.031
6/5/2012 8:42:51 AM TOracleQuery $05608000 End
Duration = 0.031
6/5/2012 8:42:51 AM SetSessionAction ends
6/5/2012 8:42:51 AM SessionChanged LoadRecentObjects
6/5/2012 8:42:51 AM SessionChanged Notify children
6/5/2012 8:42:51 AM SessionChanged Logoff secondary sessions
6/5/2012 8:42:51 AM SessionChanged EnableChildFunctions
6/5/2012 8:42:51 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\ORACLE11G\product\11.2.0\client_1
Found: oci.dll
Using: C:\ORACLE11G\product\11.2.0\client_1\bin\oci.dll
6/5/2012 8:42:51 AM Lock
6/5/2012 8:42:51 AM UnLock
6/5/2012 8:42:51 AM LoadDesktop ends
6/5/2012 8:42:51 AM WMUpdatePopups ends
6/5/2012 8:42:54 AM Create TSQLForm Start
6/5/2012 8:42:54 AM Create TSQLForm Inherited
6/5/2012 8:42:54 AM TSQLForm.FormCreate Start
6/5/2012 8:42:54 AM Lock
6/5/2012 8:42:54 AM UnLock
6/5/2012 8:42:54 AM SQLForm
6/5/2012 8:42:54 AM TSQLForm.FormCreate Finished
6/5/2012 8:42:54 AM Create TSQLForm SetupMainFont
6/5/2012 8:42:54 AM Create TSQLForm Activate
6/5/2012 8:42:54 AM UpdateChildList [timer]
6/5/2012 8:42:54 AM Create TSQLForm Activate done
6/5/2012 8:42:54 AM Create TSQLForm UpdateWindowList
6/5/2012 8:42:54 AM UpdateChildList [timer]
6/5/2012 8:42:54 AM Create TSQLForm Positioning
6/5/2012 8:42:54 AM Create TSQLForm Finished
6/5/2012 8:42:54 AM ExecuteTemplateByName: Default\SQL Window
6/5/2012 8:42:54 AM ExecuteTemplate: C:\Program Files\PLSQL Developer\Template\Default\SQL Window.tpl
6/5/2012 8:42:54 AM Path: C:\Program Files\PLSQL Developer\Template\Default\SQL Window.tpl
6/5/2012 8:42:54 AM Lock
6/5/2012 8:42:54 AM UnLock
6/5/2012 8:42:54 AM Lock
6/5/2012 8:42:54 AM UnLock
6/5/2012 8:42:54 AM Lock
6/5/2012 8:42:54 AM Lock
6/5/2012 8:42:54 AM UnLock
6/5/2012 8:42:54 AM UnLock
6/5/2012 8:42:54 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:42:54 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:42:55 AM DoUpdateChildList
6/5/2012 8:42:55 AM Lock
6/5/2012 8:42:55 AM Lock
6/5/2012 8:42:55 AM UnLock
6/5/2012 8:42:55 AM UnLock
6/5/2012 8:42:55 AM Lock
6/5/2012 8:42:55 AM UnLock
6/5/2012 8:43:02 AM TOracleQuery $05607920 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:02 AM TOracleQuery $05607920 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:05 AM TOracleQuery $05607920 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:05 AM TOracleQuery $05607920 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:09 AM TOracleQuery $05607920 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:09 AM TOracleQuery $05607920 End (1 record processed)
Duration = 0.062
6/5/2012 8:43:12 AM TOracleQuery $05607920 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:12 AM TOracleQuery $05607920 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:13 AM TOracleQuery $05607920 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:13 AM TOracleQuery $05607920 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:15 AM SQLForm Initializing...
6/5/2012 8:43:15 AM SetConnected starts
6/5/2012 8:43:15 AM SetConnected: Connect starts
6/5/2012 8:43:15 AM TOracleSession $05670B70 Start Session.LogOn as xjj5flj@xapprd1
6/5/2012 8:43:17 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
6/5/2012 8:43:17 AM TOracleQuery Query End (1 record processed)
Duration = 0.062
6/5/2012 8:43:17 AM TOracleSession $05670B70 End
Duration = 1.435
6/5/2012 8:43:17 AM SetConnected: (Dis)connect ends
6/5/2012 8:43:17 AM SetSessionAction starts: SQL Window - New
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select null from dual
6/5/2012 8:43:17 AM TOracleQuery $05607A80 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:17 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
6/5/2012 8:43:17 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.063
6/5/2012 8:43:17 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
6/5/2012 8:43:17 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.063
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
6/5/2012 8:43:17 AM TOracleQuery $05607A80 End
Duration = 0.031
6/5/2012 8:43:17 AM SetSessionAction ends
6/5/2012 8:43:17 AM ExecuteConnectScript starts
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
6/5/2012 8:43:17 AM TOracleQuery $05607A80 End
Duration = 0.031
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
6/5/2012 8:43:17 AM TOracleQuery $05607A80 End
Duration = 0.032
6/5/2012 8:43:17 AM ExecuteConnectScript ends
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
6/5/2012 8:43:17 AM TOracleQuery $05607A80 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:17 AM EnableOutput starts
6/5/2012 8:43:17 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 = 10000
6/5/2012 8:43:17 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.031
6/5/2012 8:43:17 AM EnableOutput done
6/5/2012 8:43:17 AM InitStatistics starts
6/5/2012 8:43:17 AM TStatistics.Init starts
6/5/2012 8:43:17 AM InitStatNames starts
6/5/2012 8:43:17 AM select name from v$statname order by statistic#
6/5/2012 8:43:17 AM TOracleQuery $05607BE0 Start Query.Execute
SQL = select name from v$statname order by statistic#
6/5/2012 8:43:17 AM TOracleQuery $05607BE0 End (380 records processed)
Duration = 0.124
6/5/2012 8:43:17 AM 380 statistics found
6/5/2012 8:43:17 AM StatQuery.ReadBuffer = 381
6/5/2012 8:43:17 AM InitStatNames ends
6/5/2012 8:43:17 AM StatQuery.Describe starts
6/5/2012 8:43:17 AM TOracleQuery $05607A80 Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
6/5/2012 8:43:18 AM TOracleQuery $05607A80 End
Duration = 0.031
6/5/2012 8:43:18 AM StatQuery.Describe ends
6/5/2012 8:43:18 AM TStatistics.Init ends
6/5/2012 8:43:18 AM StartValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:18 AM StartValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:18 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:18 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.063
6/5/2012 8:43:18 AM InitStatistics ends
6/5/2012 8:43:18 AM CreateQueryTabs starts
6/5/2012 8:43:18 AM SQL Window Height = 258
6/5/2012 8:43:18 AM SQL Grid Height = 179
6/5/2012 8:43:18 AM SQL Panel Height = 79
6/5/2012 8:43:18 AM GotoQueryTab 0
6/5/2012 8:43:18 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:18 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:18 AM GotoQueryTab done
6/5/2012 8:43:18 AM CreateQueryTabs ends
6/5/2012 8:43:18 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:18 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:18 AM Lock
6/5/2012 8:43:18 AM UnLock
6/5/2012 8:43:18 AM SQLForm Executing...
6/5/2012 8:43:18 AM Lock
6/5/2012 8:43:18 AM UnLock
6/5/2012 8:43:18 AM GotoQueryTab 0
6/5/2012 8:43:18 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:18 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:18 AM GotoQueryTab done
6/5/2012 8:43:18 AM SQLForm Executing...
6/5/2012 8:43:18 AM TSQLThread SQLThread.Execute
6/5/2012 8:43:18 AM TSQLThread SQLThread runs
6/5/2012 8:43:18 AM TSQLThread SQLThread loop start
6/5/2012 8:43:18 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:18 AM TOracleQuery Query End
Duration = 0.031
6/5/2012 8:43:18 AM TOracleQuery $056077C0 Start Query.Execute
SQL = select * from webstp.sailpoint_stp2_view
6/5/2012 8:43:18 AM TOracleQuery $056077C0 End
Result = ORA-00942: table or view does not exist
Duration = 0.094
6/5/2012 8:43:18 AM TSQLThread SQLThread loop end
6/5/2012 8:43:18 AM TSQLThread SQLThread loop done
6/5/2012 8:43:18 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:18 AM TOracleQuery Query End
Duration = 0.031
6/5/2012 8:43:18 AM TSQLThread SQLThread transaction management done
6/5/2012 8:43:18 AM TSQLThread SQLThread Postmessage
6/5/2012 8:43:18 AM TSQLThread SQLThread Suspend
6/5/2012 8:43:18 AM TSQLForm.ThreadFinished
6/5/2012 8:43:18 AM TSQLForm.ThreadFinished: SQLThread.Suspended
6/5/2012 8:43:20 AM Lock
6/5/2012 8:43:20 AM UnLock
6/5/2012 8:43:20 AM EndValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:20 AM EndValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:20 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:20 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.063
6/5/2012 8:43:20 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:20 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:20 AM TOracleQuery $05607D40 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
6/5/2012 8:43:20 AM TOracleQuery $05607D40 End
Duration = 0.032
6/5/2012 8:43:20 AM GotoQueryTab -1
6/5/2012 8:43:20 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:20 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:20 AM SQLForm ORA-00942: table or view does not exist
6/5/2012 8:43:20 AM GotoQueryTab done
6/5/2012 8:43:27 AM TOracleQuery $05607D40 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:27 AM TOracleQuery $05607D40 End (1 record processed)
Duration = 0.062
6/5/2012 8:43:27 AM TOracleQuery $05607BE0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
6/5/2012 8:43:27 AM TOracleQuery $05607BE0 End (1 record processed)
Duration = 0.062
6/5/2012 8:43:27 AM TOracleQuery $05607D40 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;
guard_error exception;
pragma exception_init(guard_error, -16224);
begin
:object_type := null;
:object_owner := null;
:object_name := null;
:sub_object := null;
expr := :part1;
if :part2 is not null then expr := expr || '.' || :part2; end if;
if :part3 is not null then expr := expr || '.' || :part3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => :object_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then :object_type := 'INDEX'; end if;
if part1_type = 2 then :object_type := 'TABLE'; end if;
if part1_type = 4 then :object_type := 'VIEW'; end if;
if part1_type = 5 then :object_type := 'SYNONYM'; end if;
if part1_type = 6 then :object_type := 'SEQUENCE'; end if;
if part1_type = 7 then :object_type := 'PROCEDURE'; end if;
if part1_type = 8 then :object_type := 'FUNCTION'; end if;
if part1_type = 9 then :object_type := 'PACKAGE'; end if;
if part1_type = 12 then :object_type := 'TRIGGER'; end if;
if part1_type = 13 then :object_type := 'TYPE'; end if;
if part1_type = 28 then :object_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then :object_type := 'JAVA CLASS'; end if;
if :object_type is null then
select object_type into :object_type
from sys.all_objects
where object_id = object_number;
end if;
exception
when guard_error then
raise;
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 :object_type is not null then
if p1 is null then
:object_name := p2;
elsif p2 is null then
:object_name := p1;
if :object_name = :part1 and :part2 is not null then
:sub_object := :part2;
end if;
if :object_name = :part2 and :part3 is not null then
:sub_object := :part3;
end if;
else
:object_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if :part2 is null and :part3 is null then
select 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.all_users u
where u.username = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0 then
select 'ROLE', null, :part1
into :object_type, :object_owner, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if :part2 is null then
select constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.all_constraints c
where c.constraint_name = :part1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.all_constraints c
where c.constraint_name = :part2
and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then
:object_type := 'PRIMARY KEY';
end if;
if :object_type = 'U' then
:object_type := 'UNIQUE KEY';
end if;
if :object_type = 'R' then
:object_type := 'FOREIGN KEY';
end if;
if :object_type = 'C' then
:object_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
:PART1 = WEBSTP
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 =
:SUB_OBJECT = Null
:PART3 =
:DEEP = 0
:CUR_SCHEMA = XJJ5FLJ
6/5/2012 8:43:27 AM TOracleQuery $05607D40 End
Duration = 0.031
6/5/2012 8:43:27 AM TOracleQuery $05607D40 Start Query.Execute
SQL = select object_name synonym_name, object_name, owner object_owner, status, object_type
from sys.all_objects o
where o.owner = :object_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_name, o.object_type
:OBJECT_OWNER = WEBSTP
:OBJECT_TYPE = 'TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SEQUENCE', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE'
:EXTRA_CONDITION = Null
6/5/2012 8:43:27 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.156
6/5/2012 8:43:27 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:27 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.031
6/5/2012 8:43:27 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:28 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.031
6/5/2012 8:43:28 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:28 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.031
6/5/2012 8:43:28 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:28 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.031
6/5/2012 8:43:28 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:28 AM TOracleQuery $05607D40 End (25 records processed)
Duration = 0.031
6/5/2012 8:43:28 AM TOracleQuery $05607D40 Start Query.Next for up to 25 records
6/5/2012 8:43:28 AM TOracleQuery $05607D40 End (15 records processed)
Duration = 0.031
6/5/2012 8:43:32 AM SQLForm Initializing...
6/5/2012 8:43:32 AM SetConnected starts
6/5/2012 8:43:32 AM Already connected: check connection
6/5/2012 8:43:32 AM TOracleQuery $05607D40 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:32 AM TOracleQuery $05607D40 End (1 record processed)
Duration = 0.062
6/5/2012 8:43:32 AM Using existing connection
6/5/2012 8:43:32 AM EnableOutput starts
6/5/2012 8:43:32 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 = 10000
6/5/2012 8:43:32 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.031
6/5/2012 8:43:32 AM EnableOutput done
6/5/2012 8:43:32 AM InitStatistics starts
6/5/2012 8:43:32 AM TOracleQuery $05607D40 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:32 AM TOracleQuery $05607D40 End (1 record processed)
Duration = 0.062
6/5/2012 8:43:32 AM StartValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:32 AM StartValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:32 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:32 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.062
6/5/2012 8:43:32 AM InitStatistics ends
6/5/2012 8:43:32 AM CreateQueryTabs starts
6/5/2012 8:43:32 AM GotoQueryTab 0
6/5/2012 8:43:32 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:32 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:32 AM GotoQueryTab done
6/5/2012 8:43:32 AM CreateQueryTabs ends
6/5/2012 8:43:32 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:32 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:32 AM Lock
6/5/2012 8:43:32 AM UnLock
6/5/2012 8:43:32 AM SQLForm Executing...
6/5/2012 8:43:32 AM Lock
6/5/2012 8:43:32 AM UnLock
6/5/2012 8:43:32 AM GotoQueryTab 0
6/5/2012 8:43:32 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:32 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:32 AM GotoQueryTab done
6/5/2012 8:43:32 AM SQLForm Executing...
6/5/2012 8:43:32 AM TSQLThread SQLThread Suspend ended
6/5/2012 8:43:32 AM TSQLThread SQLThread runs
6/5/2012 8:43:32 AM TSQLThread SQLThread loop start
6/5/2012 8:43:32 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:33 AM TOracleQuery Query End
Duration = 0.031
6/5/2012 8:43:33 AM TOracleQuery $056077C0 Start Query.Execute
SQL = select * from webstp.sailpoint_access_stp2_view
6/5/2012 8:43:33 AM TOracleQuery $056077C0 End (100 records processed)
Duration = 0.203
6/5/2012 8:43:33 AM TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM webstp.sailpoint_access_stp2_view
6/5/2012 8:43:33 AM TOracleQuery SQLForm.TestQuery End
Duration = 0.031
6/5/2012 8:43:33 AM TSQLThread SQLThread loop end
6/5/2012 8:43:33 AM TSQLThread SQLThread loop done
6/5/2012 8:43:33 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:33 AM TOracleQuery Query End
Duration = 0.032
6/5/2012 8:43:33 AM TSQLThread SQLThread transaction management done
6/5/2012 8:43:33 AM TSQLThread SQLThread Postmessage
6/5/2012 8:43:33 AM TSQLThread SQLThread Suspend
6/5/2012 8:43:33 AM TSQLForm.ThreadFinished
6/5/2012 8:43:33 AM TSQLForm.ThreadFinished: SQLThread.Suspended
6/5/2012 8:43:49 AM Lock
6/5/2012 8:43:49 AM UnLock
6/5/2012 8:43:49 AM EndValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:49 AM EndValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:49 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:49 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.062
6/5/2012 8:43:49 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:49 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:49 AM TOracleQuery $05607BE0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
6/5/2012 8:43:49 AM TOracleQuery $05607BE0 End
Duration = 0.031
6/5/2012 8:43:49 AM GotoQueryTab -1
6/5/2012 8:43:49 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:49 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:49 AM SQLForm Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
6/5/2012 8:43:49 AM GotoQueryTab done
6/5/2012 8:43:52 AM SQLForm Initializing...
6/5/2012 8:43:52 AM SetConnected starts
6/5/2012 8:43:52 AM Already connected: check connection
6/5/2012 8:43:52 AM TOracleQuery $05607BE0 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:52 AM TOracleQuery $05607BE0 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:52 AM Using existing connection
6/5/2012 8:43:52 AM EnableOutput starts
6/5/2012 8:43:52 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 = 10000
6/5/2012 8:43:52 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.032
6/5/2012 8:43:52 AM EnableOutput done
6/5/2012 8:43:52 AM InitStatistics starts
6/5/2012 8:43:52 AM TOracleQuery $05607BE0 Start Query.Execute
SQL = select 'x' from dual
6/5/2012 8:43:52 AM TOracleQuery $05607BE0 End (1 record processed)
Duration = 0.063
6/5/2012 8:43:52 AM StartValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:52 AM StartValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:52 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:52 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.062
6/5/2012 8:43:52 AM InitStatistics ends
6/5/2012 8:43:52 AM CreateQueryTabs starts
6/5/2012 8:43:52 AM GotoQueryTab 0
6/5/2012 8:43:52 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:52 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:52 AM GotoQueryTab done
6/5/2012 8:43:52 AM CreateQueryTabs ends
6/5/2012 8:43:52 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:52 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:52 AM Lock
6/5/2012 8:43:52 AM UnLock
6/5/2012 8:43:52 AM SQLForm Executing...
6/5/2012 8:43:52 AM Lock
6/5/2012 8:43:52 AM UnLock
6/5/2012 8:43:52 AM GotoQueryTab 0
6/5/2012 8:43:52 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:52 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:52 AM GotoQueryTab done
6/5/2012 8:43:52 AM SQLForm Executing...
6/5/2012 8:43:52 AM TSQLThread SQLThread Suspend ended
6/5/2012 8:43:52 AM TSQLThread SQLThread runs
6/5/2012 8:43:52 AM TSQLThread SQLThread loop start
6/5/2012 8:43:52 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:52 AM TOracleQuery Query End
Duration = 0.031
6/5/2012 8:43:52 AM TOracleQuery $056077C0 Start Query.Execute
SQL = select * from webstp.sailpoint_access_stp2_view
6/5/2012 8:43:52 AM TOracleQuery $056077C0 End (100 records processed)
Duration = 0.187
6/5/2012 8:43:52 AM TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM webstp.sailpoint_access_stp2_view
6/5/2012 8:43:53 AM TOracleQuery SQLForm.TestQuery End
Duration = 0.032
6/5/2012 8:43:53 AM TSQLThread SQLThread loop end
6/5/2012 8:43:53 AM TSQLThread SQLThread loop done
6/5/2012 8:43:53 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
6/5/2012 8:43:53 AM TOracleQuery Query End
Duration = 0.343
6/5/2012 8:43:53 AM TSQLThread SQLThread transaction management done
6/5/2012 8:43:53 AM TSQLThread SQLThread Postmessage
6/5/2012 8:43:53 AM TSQLThread SQLThread Suspend
6/5/2012 8:43:53 AM TSQLForm.ThreadFinished
6/5/2012 8:43:53 AM TSQLForm.ThreadFinished: SQLThread.Suspended
6/5/2012 8:43:54 AM Lock
6/5/2012 8:43:54 AM UnLock
6/5/2012 8:43:54 AM EndValues: StatQuery.ReadBuffer = 381
6/5/2012 8:43:54 AM EndValues: StatQuery.ReadBuffer set to 381
6/5/2012 8:43:54 AM TOracleQuery $05607A80 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 438
6/5/2012 8:43:54 AM TOracleQuery $05607A80 End (380 records processed)
Duration = 0.078
6/5/2012 8:43:54 AM NavigationBookmarks.EnableButtons(Rebuild)
6/5/2012 8:43:54 AM NavigationBookmarks: Backward=0, Forward=0
6/5/2012 8:43:54 AM TOracleQuery $05607D40 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
6/5/2012 8:43:54 AM TOracleQuery $05607D40 End
Duration = 0.032
6/5/2012 8:43:54 AM GotoQueryTab -1
6/5/2012 8:43:54 AM GotoQueryTab: QueryTabControlChanging
6/5/2012 8:43:54 AM GotoQueryTab: QueryTabControlChange
6/5/2012 8:43:55 AM SQLForm Access violation at address 00405142 in module 'plsqldev.exe'. Read of address 7365742E
6/5/2012 8:43:55 AM GotoQueryTab done


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 15 (0.005s) Memory: 2.6109 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-03-29 11:54:02 UTC
Valid HTML 5 and Valid CSS