SERVERERROR trigger catch errors(ORA-04044,ORA-00942) when using WITH query statement in plsql dev

A

arthurtangel

Member
I have a SERVERERROR Trigger to catch error and insert related error message into table LOG_ERRORINFO.
when query SQL (with .. as ..) in SQLPLUS, no error message and No data being inserted in table LOG_ERRORINFO.
however, query the same SQL (with .. as ..) in PL/SQL dev program(sql windows), no error message output on screen, but Trigger catch error ORA-04044 or ORA-00942
into LOG_ERRORINFO.

run in [sql windows] on pl/sql dev program:
WITH u AS (SELECT SYSDATE d FROM dual) SELECT * FROM u;
servererror trigger will catch a error "ORA-00942"

run in [sql windows] on pl/sql dev program:
WITH v AS (SELECT SYSDATE d FROM dual) SELECT * FROM v;
servererror trigger will catch a error "ORA-04044"

we want to know why SERVERERROR trigger can catch these errors when using WITH query statement,and how to avoid it?

source code:
------------------------------------------------------------------------
CREATE OR REPLACE TRIGGER LOG.TR_$S_ServerError
AFTER SERVERERROR ON DATABASE
DECLARE
n PLS_INTEGER;
sql_text ora_name_list_t;
stmt VARCHAR2(30000);
vCode PLS_INTEGER := ora_server_error(1);
vSize PLS_INTEGER;
vMsg VARCHAR2(4000);
vID VARCHAR2(4000);
vModel VARCHAR2(300);
BEGIN
dbms_application_info.read_client_info(vID);
IF vCode BETWEEN 20000 AND 20999 THEN
RETURN;
END IF;
vSize := ora_server_error_depth;
FOR i IN 1 .. vSize LOOP
vMsg := vMsg || ora_server_error_msg(i);
END LOOP;
n := ora_sql_txt(sql_text);
FOR i IN 1 .. n LOOP
stmt := stmt || sql_text(i);
END LOOP;
stmt := substr(stmt, 1, 4000);

INSERT INTO LOG_ErrorInfo
(SessionID, ErrorTime, ErrorCode, ErrorMsg, CurSQL, Model, PartFlag)
VALUES
(SYS_CONTEXT('USERENV', 'SESSIONID'),
systimestamp,
vCode,
vMsg,
stmt,
vModel,
to_char(SYSDATE, 'MM'));
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
-------------------------------------------------------------------------------------------
create table log.LOG_ERRORINFO
(
sessionid NUMBER(20),
errortime TIMESTAMP(6),
errorcode NUMBER(10),
errormsg VARCHAR2(4000),
cursql VARCHAR2(4000),
model VARCHAR2(200),
partflag NUMBER(2)
);
-------------------------------------------------------------------------------------------------

 
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\\AppData\Roaming\PLSQL Developer).
 
here is my debug.txt

PL/SQL Developer
Version 8.0.4.1514
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,968,444 available)

Parameters
F:\plsql_dev\plsqldev.exe
DebugSQL

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

Preference Files

Plug-Ins

2013/4/23 9:08:00 Application started
2013/4/23 9:08:00 InitPreferences
2013/4/23 9:08:00 Load F:\plsql_dev\Preferences\Default = 0
2013/4/23 9:08:00 PreferenceSet.Load F:\plsql_dev\Preferences\Default\Default.ini
2013/4/23 9:08:00 PreferenceSet.Load OK
2013/4/23 9:08:00 Determine LocalPrefPath
2013/4/23 9:08:00 [1]: C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences
2013/4/23 9:08:00 LocalPrefPath: C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit
2013/4/23 9:08:00 Load C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit = 0
2013/4/23 9:08:00 PreferenceSet.Load C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit\default.ini
2013/4/23 9:08:00 PreferenceSet.Load OK
2013/4/23 9:08:00 PreferenceSet.Load C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit\user.prefs
2013/4/23 9:08:00 PreferenceSet.Load OK
2013/4/23 9:08:00 InitPreferences end
2013/4/23 9:08:00 SortPreferenceSets
2013/4/23 9:08:00 - Default cmhit
2013/4/23 9:08:00 - System Default
2013/4/23 9:08:00 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
2013/4/23 9:08:00 ReadString OK
2013/4/23 9:08:00 pfReadRegistry: "F:\plsql_dev\PLSQLDev.exe" "%1"
2013/4/23 9:08:00 LoadPreferences
2013/4/23 9:08:00 LoadPreferences searching for default
2013/4/23 9:08:00 C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit\default.ini
2013/4/23 9:08:00 LoadPreferences NewPref := nil
2013/4/23 9:08:00 LoadPreferences
2013/4/23 9:08:00 LoadPreferences Reading preferences
2013/4/23 9:08:00 LoadPreferences ReadPosition
2013/4/23 9:08:00 LoadPreferences ToolsBrowserItemClick(nil)
2013/4/23 9:08:00 LoadPreferences CreateBrowserFilters...
2013/4/23 9:08:00 LoadPreferences Files
2013/4/23 9:08:00 LoadPreferences Logon
2013/4/23 9:08:00 LoadPreferences Buttons
2013/4/23 9:08:00 LoadPreferences Printer
2013/4/23 9:08:00 LoadPreferences FileBrowserFolders
2013/4/23 9:08:00 LoadPreferences BrowserFolders
2013/4/23 9:08:00 LoadPreferences
2013/4/23 9:08:00 LoadPreferences end
2013/4/23 9:08:00 MacroLibFilename: F:\plsql_dev\Macro\cmhit.emlib
2013/4/23 9:08:00 FormCreate Logon.Execute
2013/4/23 9:08:06 TOracleSession PLSQLDevForm.Session Start Session.LogOn as ctos@ctos_dev
2013/4/23 9:08:06 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2013/4/23 9:08:06 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:06 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2013/4/23 9:08:06 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:06 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2013/4/23 9:08:06 TOracleQuery Query End (1 record processed)
Duration = 0
2013/4/23 9:08:06 TOracleSession PLSQLDevForm.Session End
Duration = 0.156
2013/4/23 9:08:06 LogonHistorySave start
2013/4/23 9:08:06 ChangeUserPref LogonHistory,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref DSA,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref ColumnAssociations,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref ImportAssociations,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref BrowserFilters,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref FileBrowserFolders,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref BrowserFolders,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref SessionQueries,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref ExternalTools,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref Documents,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 ChangeUserPref Reports,
2013/4/23 9:08:06 ChangeUserPref end
2013/4/23 9:08:06 PreferenceSet.Save
2013/4/23 9:08:06 PreferenceSet Filename = C:\Users\cmhit\AppData\Roaming\PLSQL Developer\Preferences\cmhit\user.prefs
2013/4/23 9:08:06 PreferenceSet AltFile = user.prefs
2013/4/23 9:08:06 PreferenceSet.Save end
2013/4/23 9:08:06 LogonHistorySave end
2013/4/23 9:08:06 FormCreate Session.Connected
2013/4/23 9:08:06 FormCreate Logon.Executed -1
2013/4/23 9:08:06 FormCreate TDBNames.Make
2013/4/23 9:08:06 FormCreate SessionChanged
2013/4/23 9:08:06 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
2013/4/23 9:08:06 TOracleQuery Query End (5 records processed)
Duration = 0
2013/4/23 9:08:06 SessionChanged SetDBAViews
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End (0 records processed)
Duration = 0.016
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End (0 records processed)
Duration = 0
2013/4/23 9:08:06 SessionChanged Authorizations.Load
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 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)
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End
Result = ORA-00942: table or view does not exist
Duration = 0
2013/4/23 9:08:06 SessionChanged EnableAuthorizedMenus
2013/4/23 9:08:06 ExecuteConnectScript starts
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End
Duration = 0
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End
Duration = 0.016
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End
Duration = 0
2013/4/23 9:08:06 ExecuteConnectScript ends
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
2013/4/23 9:08:06 TOracleQuery $02B4D6D0 End (1 record processed)
Duration = 0
2013/4/23 9:08:06 TOracleSession $0564D230 Start Session.LogOn as ctos@ctos_dev
2013/4/23 9:08:07 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2013/4/23 9:08:07 TOracleQuery Query End (1 record processed)
Duration = 0.016
2013/4/23 9:08:07 TOracleSession $0564D230 End
Duration = 0.062
2013/4/23 9:08:07 SetSessionAction starts: Main session
2013/4/23 9:08:07 TOracleQuery $02B4D990 Start Query.Execute
SQL = select null from dual
2013/4/23 9:08:07 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2013/4/23 9:08:07 TOracleQuery $02B4D990 End (1 record processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D990 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
2013/4/23 9:08:07 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2013/4/23 9:08:07 TOracleQuery $02B4D990 End
Duration = 0
2013/4/23 9:08:07 SetSessionAction ends
2013/4/23 9:08:07 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2013/4/23 9:08:07 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Execute
SQL = select object_name, object_type
from sys.all_objects o
where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = CTOS
2013/4/23 9:08:07 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 SessionChanged LoadRecentObjects
2013/4/23 9:08:07 SessionChanged Notify children
2013/4/23 9:08:07 SessionChanged Logoff secondary sessions
2013/4/23 9:08:07 SessionChanged SessionMode = smMulti
2013/4/23 9:08:07 SessionChanged EnableChildFunctions
2013/4/23 9:08:07 SessionChanged
OCIDLL forced to F:\oracle_related\instantclient\oci.dll
2013/4/23 9:08:07 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:07 TOracleQuery $02B4D830 End (30 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D830 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = CTOS
2013/4/23 9:08:07 SortPreferenceSets
2013/4/23 9:08:07 - Default cmhit
2013/4/23 9:08:07 - System Default
2013/4/23 9:08:07 TOracleQuery $02B4D990 Start Query.Execute
SQL = select null from all_synonyms where 1=0
2013/4/23 9:08:07 TOracleQuery $02B4D990 End (0 records processed)
Duration = 0
2013/4/23 9:08:07 TOracleQuery $02B4D990 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
2013/4/23 9:08:07 TOracleQuery $02B4D990 End (0 records processed)
Duration = 0
2013/4/23 9:08:07 FormActivate start
2013/4/23 9:08:07 FormActivate end
2013/4/23 9:08:07 WMUpdatePopups starts
2013/4/23 9:08:07 LoadDesktop starts
2013/4/23 9:08:07 DoUpdateChildList
2013/4/23 9:08:07 LoadDesktop ends
2013/4/23 9:08:07 Create TSQLForm Start
2013/4/23 9:08:07 Create TSQLForm Inherited
2013/4/23 9:08:07 TSQLForm.FormCreate Start
2013/4/23 9:08:07 SQLForm
2013/4/23 9:08:07 TSQLForm.FormCreate Finished
2013/4/23 9:08:07 Create TSQLForm SetupMainFont
2013/4/23 9:08:07 Create TSQLForm Activate
2013/4/23 9:08:07 Create TSQLForm Activate done
2013/4/23 9:08:07 Create TSQLForm UpdateWindowList
2013/4/23 9:08:07 UpdateChildList [timer]
2013/4/23 9:08:07 Create TSQLForm Positioning
2013/4/23 9:08:07 Create TSQLForm Finished
2013/4/23 9:08:07 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:08:07 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:08:07 WMUpdatePopups ends
2013/4/23 9:08:07 DoUpdateChildList
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 1.263
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.031
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.031
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.047
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.031
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:08 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:08 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 1.576
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.031
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.141
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.047
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.031
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.016
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (100 records processed)
Duration = 0.015
2013/4/23 9:08:10 TOracleQuery $02B4D830 Start Query.Next for up to 100 records
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (52 records processed)
Duration = 0
2013/4/23 9:08:10 TOracleQuery $02B4D830 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 = CTOS
2013/4/23 9:08:10 TOracleQuery $02B4D830 End (1 record processed)
Duration = 0
2013/4/23 9:08:10 TOracleSession $0564D230 Start Session.LogOff
2013/4/23 9:08:10 TOracleSession $0564D230 End
Duration = 0.016
2013/4/23 9:08:20 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:08:20 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:08:51 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:08:51 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:08:56 EditCopy
2013/4/23 9:08:56 Screen.ActiveCustomForm EditCopy
2013/4/23 9:08:56 ChildForm.EditCopy
2013/4/23 9:09:21 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:09:21 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:09:22 EditCopy
2013/4/23 9:09:22 Screen.ActiveCustomForm EditCopy
2013/4/23 9:09:22 ChildForm.EditCopy
2013/4/23 9:09:23 SQLForm Initializing...
2013/4/23 9:09:23 SetConnected starts
2013/4/23 9:09:23 SetConnected: Connect starts
2013/4/23 9:09:23 TOracleSession $0564FC30 Start Session.LogOn as ctos@ctos_dev
2013/4/23 9:09:23 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2013/4/23 9:09:23 TOracleQuery Query End (1 record processed)
Duration = 0
2013/4/23 9:09:23 TOracleSession $0564FC30 End
Duration = 0.063
2013/4/23 9:09:23 SetConnected: (Dis)connect ends
2013/4/23 9:09:23 SetSessionAction starts: SQL Window - New
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = select null from dual
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End (1 record processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2013/4/23 9:09:23 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2013/4/23 9:09:23 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End
Duration = 0
2013/4/23 9:09:23 SetSessionAction ends
2013/4/23 9:09:23 ExecuteConnectScript starts
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End
Duration = 0.015
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End
Duration = 0
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End
Duration = 0
2013/4/23 9:09:23 ExecuteConnectScript ends
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
2013/4/23 9:09:23 TOracleQuery $02B4CFF0 End (1 record processed)
Duration = 0
2013/4/23 9:09:23 EnableOutput starts
2013/4/23 9:09:23 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
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
2013/4/23 9:09:23 EnableOutput done
2013/4/23 9:09:23 InitStatistics starts
2013/4/23 9:09:23 TStatistics.Init starts
2013/4/23 9:09:23 InitStatNames starts
2013/4/23 9:09:23 select name from v$statname order by statistic#
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:23 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.015
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.DynamicQuery End (13 records processed)
Duration = 0
2013/4/23 9:09:24 InitStatNames ends
2013/4/23 9:09:24 StatQuery.Describe starts
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
2013/4/23 9:09:24 StatQuery.Describe ends
2013/4/23 9:09:24 TStatistics.Init ends
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 867
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery End (638 records processed)
Duration = 0
2013/4/23 9:09:24 InitStatistics ends
2013/4/23 9:09:24 SQL Window Height = 678
2013/4/23 9:09:24 SQL Grid Height = 548
2013/4/23 9:09:24 SQL Panel Height = 130
2013/4/23 9:09:24 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:09:24 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:09:24 SQLForm Executing...
2013/4/23 9:09:24 SQLForm Executing...
2013/4/23 9:09:24 TSQLThread SQLThread.Execute
2013/4/23 9:09:24 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2013/4/23 9:09:24 TOracleQuery Query End
Duration = 0
2013/4/23 9:09:24 TOracleQuery $02B4D2B0 Start Query.Execute
SQL = WITH v AS
(SELECT SYSDATE d FROM dual)
SELECT * FROM v
2013/4/23 9:09:24 TOracleQuery $02B4D2B0 End (1 record processed)
Duration = 0
2013/4/23 9:09:24 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM v
2013/4/23 9:09:24 TOracleQuery SQLForm.TestQuery End
Result = ORA-04044: procedure, function, package, or type is not allowed here
Duration = 0
2013/4/23 9:09:24 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2013/4/23 9:09:24 TOracleQuery Query End
Duration = 0
2013/4/23 9:09:24 TSQLThread SQLThread Postmessage
2013/4/23 9:09:24 TSQLThread SQLThread Suspend
2013/4/23 9:09:24 TSQLForm.ThreadFinished
2013/4/23 9:09:24 TSQLForm.ThreadFinished: SQLThread.Suspended
2013/4/23 9:09:24 SQLForm 1 row selected in 0.031 seconds
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 867
2013/4/23 9:09:24 TOracleQuery PLSQLDevForm.StatQuery End (638 records processed)
Duration = 0.016
2013/4/23 9:09:24 NavigationBookmarks.EnableButtons(Rebuild)
2013/4/23 9:09:24 NavigationBookmarks: Backward=0, Forward=0
2013/4/23 9:09:24 TOracleQuery $02B4D150 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
2013/4/23 9:09:24 TOracleQuery $02B4D150 End
Duration = 0
2013/4/23 9:09:24 SQLForm 1 row selected in 0.031 seconds
 
Last edited:
You must log in or register to reply here.
Back
Top