PL/SQL Developer 7.0.0.1050 02.25102 - 10 user license
C:\Program Files\PLSQL Developer\plsqldev.exe
13/02/2006 09:40:33 Application started
13/02/2006 09:40:33 InitPreferences
13/02/2006 09:40:33 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
13/02/2006 09:40:33 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
13/02/2006 09:40:33 PreferenceSet.Load OK
13/02/2006 09:40:33 PreferenceSet.Save
13/02/2006 09:40:33 PreferenceSet filename = C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
13/02/2006 09:40:33 PreferenceSet.Save end
13/02/2006 09:40:33 Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste = 0
13/02/2006 09:40:33 PreferenceSet.Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:33 PreferenceSet.Load OK
13/02/2006 09:40:33 PreferenceSet.Save
13/02/2006 09:40:33 PreferenceSet filename = C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:33 PreferenceSet.Save end
13/02/2006 09:40:33 PreferenceSet.Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\user.prefs
13/02/2006 09:40:33 PreferenceSet.Load OK
13/02/2006 09:40:33 InitPreferences end
13/02/2006 09:40:33 SortPreferenceSets
13/02/2006 09:40:33 - lilacoste
13/02/2006 09:40:33 - System Default
13/02/2006 09:40:34 LoadPreferences
13/02/2006 09:40:34 LoadPreferences searching for default
13/02/2006 09:40:34 C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:34 LoadPreferences end
13/02/2006 09:40:34 FormCreate Logon.Execute
13/02/2006 09:40:34 TOracleSession PLSQLDevForm.Session Start Session.LogOn as aid/a@aides.world
13/02/2006 09:40:35 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:35 TOracleQuery Query End (1 record processed)
Duration = 0.015
13/02/2006 09:40:35 TOracleSession PLSQLDevForm.Session End
Duration = 0.484
13/02/2006 09:40:35 FormCreate Session.Connected
13/02/2006 09:40:35 FormCreate Logon.Executed -1
13/02/2006 09:40:35 FormCreate TDBNames.Make
13/02/2006 09:40:35 FormCreate SessionChanged
13/02/2006 09:40:35 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
13/02/2006 09:40:35 TOracleQuery Query End (5 records processed)
Duration = 0
13/02/2006 09:40:35 SessionChanged SetDBAViews
13/02/2006 09:40:35 SessionChanged Authorizations.Load
13/02/2006 09:40:35 TOracleQuery 499620 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/02/2006 09:40:35 TOracleQuery 499620 End
Result = ORA-00942: Table ou vue inexistante
Duration = 0
13/02/2006 09:40:35 SessionChanged EnableAuthorizedMenus
13/02/2006 09:40:35 TOracleSession 94CF10 Start Session.LogOn as aid@aides.world
13/02/2006 09:40:35 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:35 TOracleQuery Query End (1 record processed)
Duration = 0.015
13/02/2006 09:40:35 TOracleSession 94CF10 End
Duration = 0.109
13/02/2006 09:40:35 SetSessionAction starts: Main session
13/02/2006 09:40:35 TOracleQuery 4998A0 Start Query.Execute
SQL = select null from dual
13/02/2006 09:40:35 TOracleQuery 4994E0 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/02/2006 09:40:35 TOracleQuery 4998A0 End (1 record processed)
Duration = 0
13/02/2006 09:40:35 TOracleQuery 4998A0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
13/02/2006 09:40:35 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:35 TOracleQuery 4998A0 End
Duration = 0
13/02/2006 09:40:35 SetSessionAction ends
13/02/2006 09:40:35 ExecuteConnectScript starts
13/02/2006 09:40:35 ExecuteConnectScript ends
13/02/2006 09:40:35 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery PLSQLDevForm.DynamicQuery End (0 records processed)
Duration = 0
13/02/2006 09:40:35 SessionChanged LoadRecentObjects
13/02/2006 09:40:35 TOracleQuery 4994E0 End (37 records processed)
Duration = 0.015
13/02/2006 09:40:35 TOracleQuery 4994E0 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')
13/02/2006 09:40:35 SessionChanged Notify children
13/02/2006 09:40:35 SessionChanged Logoff secondary sessions
13/02/2006 09:40:35 SessionChanged SessionMode = smDual
13/02/2006 09:40:35 SessionChanged EnableChildFunctions
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.031
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\oracle\ora81
Found: oci.dll
Using: C:\oracle\ora81\bin\oci.dll
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.015
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (100 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35 TOracleQuery 4994E0 End (44 records processed)
Duration = 0.016
13/02/2006 09:40:35 TOracleSession 94CF10 Start Session.LogOff
13/02/2006 09:40:35 TOracleSession 94CF10 End
Duration = 0
13/02/2006 09:40:35 SortPreferenceSets
13/02/2006 09:40:35 - lilacoste
13/02/2006 09:40:35 - System Default
13/02/2006 09:40:38 Create TTestForm
13/02/2006 09:40:44 SetConnected starts
13/02/2006 09:40:44 SetConnected: Connect starts
13/02/2006 09:40:44 TOracleSession PLSQLDevForm.94D1B0 Start Session.LogOn as aid@aides.world
13/02/2006 09:40:45 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:45 TOracleQuery Query End (1 record processed)
Duration = 0.016
13/02/2006 09:40:45 TOracleSession PLSQLDevForm.94D1B0 End
Duration = 0.109
13/02/2006 09:40:45 SetConnected: (Dis)connect ends
13/02/2006 09:40:45 SetSessionAction starts: Secondary session
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = select null from dual
13/02/2006 09:40:45 TOracleQuery 499C60 End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Secondary session
13/02/2006 09:40:45 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
13/02/2006 09:40:45 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery 499C60 End
Duration = 0
13/02/2006 09:40:45 SetSessionAction ends
13/02/2006 09:40:45 ExecuteConnectScript starts
13/02/2006 09:40:45 ExecuteConnectScript ends
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
13/02/2006 09:40:45 TOracleQuery 499C60 End (1 record processed)
Duration = 0.016
13/02/2006 09:40:45 InitHTPOutput starts
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
13/02/2006 09:40:45 TOracleQuery 499C60 End
Duration = 0
13/02/2006 09:40:45 InitHTPOutput finished
13/02/2006 09:40:45 EnableOutput starts
13/02/2006 09:40:45 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
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
13/02/2006 09:40:45 EnableOutput done
13/02/2006 09:40:45 InitStatistics starts
13/02/2006 09:40:45 TStatistics.Init starts
13/02/2006 09:40:45 InitStatNames starts
13/02/2006 09:40:45 select name from v$statname order by statistic#
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.DynamicQuery End (11 records processed)
Duration = 0
13/02/2006 09:40:45 InitStatNames ends
13/02/2006 09:40:45 StatQuery.Describe starts
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
13/02/2006 09:40:45 StatQuery.Describe ends
13/02/2006 09:40:45 TStatistics.Init ends
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 19
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery End (211 records processed)
Duration = 0
13/02/2006 09:40:45 InitStatistics ends
13/02/2006 09:40:45 TSQLThread SQLThread.Execute
13/02/2006 09:40:45 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
13/02/2006 09:40:45 TOracleQuery Query End
Duration = 0.015
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Execute
SQL = SELECT *
FROM AID.DOSSIER D
WHERE D.DATENREG >= '09/12/2005'
AND D.DATENREG < '10/12/2005'
AND D.CODART = :CODART
:CODART = 27
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0.063
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0.015
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0.016
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (1 record processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45 TOracleQuery TestForm.TestQuery End (0 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
13/02/2006 09:40:45 TOracleQuery Query End
Duration = 0
13/02/2006 09:40:45 TSQLThread SQLThread Postmessage
13/02/2006 09:40:45 TSQLThread SQLThread Suspend
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 19
13/02/2006 09:40:45 TOracleQuery PLSQLDevForm.StatQuery End (211 records processed)
Duration = 0
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
13/02/2006 09:40:45 TOracleQuery 499C60 End
Duration = 0
13/02/2006 09:40:45 GetHTPOutput starts
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
13/02/2006 09:40:45 TOracleQuery 499C60 End
Duration = 0.015
13/02/2006 09:40:45 Trying htp.get_line
13/02/2006 09:40:45 TOracleQuery 499C60 Start Query.Execute
SQL = begin htp.flush; :line := htp.get_line(:rows); end;
:LINE = Null
:ROWS = Null
13/02/2006 09:40:45 TOracleQuery 499C60 End
Duration = 0
13/02/2006 09:40:45 No lines retrieved
13/02/2006 09:40:45 GetHTPOutput finished
13/02/2006 09:40:49 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
13/02/2006 09:40:49 TOracleQuery Query End
Duration = 0