10.52.236.25 3
ORA-06512: at "DVADAS.FORCE_ORA_ERROR", line 20 rows
Could you send the script to create your ERROR_LOGS table? You can send it offline to
gregory liss software dell com
thanks,
From: damir.vadas_531 [mailto:[email protected]]
Sent: Friday, August 02, 2013 5:46 AM
To: [email protected]
Subject: [Toad for Oracle - Discussion Forum] Toad in 12.0 (as well in 12.1) script output
Toad in 12.0 (as well in 12.1) script output
Thread created by damir.vadas_531
When I run as script query in SQLPlus I get correct output:
GENERAL 02.08.13 too many rows, -1422 ORA-01422: exact fetch returns more than requested number of DVADAS
10.52.236.25 3
ORA-06512: at "DVADAS.FORCE_ORA_ERROR", line 20 rows
CREATE TABLE ERROR_LOGS
ERR_TAG VARCHAR2(16 CHAR) DEFAULT ‘UNKNOWN’ NOT NULL,
ERR_DATE DATE NOT NULL,
ERR_NOTE VARCHAR2(1024 CHAR),
ERR_CODE INTEGER NOT NULL,
ERR_MSG VARCHAR2(1024 CHAR) NOT NULL,
ERR_USER VARCHAR2(64 CHAR),
ERR_USER_IP VARCHAR2(15 CHAR),
ID INTEGER NOT NULL
SET DEFINE OFF;
Insert into ERROR_LOGS
(ERR_TAG, ERR_DATE, ERR_NOTE, ERR_CODE, ERR_MSG,
ERR_USER, ERR_USER_IP, ID)
Values
(‘GENERAL’, TO_DATE(‘08/02/2013 10:36:26’, ‘MM/DD/YYYY HH24:MI:SS’), 'bad division,
ORA-06512: at “DVADAS.FORCE_ORA_ERROR”, line 11
----- PL/SQL Call Stack -----
object line object
handle number name
70000052af484b8 65 package body TOOLS.DEBUG_PKG
700000533a17828 17 procedure TOOLS.AUTO_LOG_ERROR_GENERAL
70000052b183428 15 procedure DVADAS.FORCE_ORA_ERROR
700000522ffa2d8 1 anonymous block
', -1476, ‘ORA-01476: divisor is equal to zero’,
‘DVADAS’, ‘10.52.236.25’, 2);
Insert into ERROR_LOGS
(ERR_TAG, ERR_DATE, ERR_NOTE, ERR_CODE, ERR_MSG,
ERR_USER, ERR_USER_IP, ID)
Values
(‘GENERAL’, TO_DATE(‘08/02/2013 10:36:27’, ‘MM/DD/YYYY HH24:MI:SS’), 'too many rows,
ORA-06512: at “DVADAS.FORCE_ORA_ERROR”, line 20
----- PL/SQL Call Stack -----
object line object
handle number name
70000052af484b8 65 package body TOOLS.DEBUG_PKG
700000533a17828 17 procedure TOOLS.AUTO_LOG_ERROR_GENERAL
70000052b183428 23 procedure DVADAS.FORCE_ORA_ERROR
700000522ffa2d8 1 anonymous block
', -1422, ‘ORA-01422: exact fetch returns more than requested number of rows’,
‘DVADAS’, ‘10.52.236.25’, 3);
COMMIT;
Thanks for the info. The good news is that it’s never worked. That’s also the bad news. Back to the good news side, I’ll be able to get it fixed.
From: damir.vadas_531 [mailto:[email protected]]
Sent: Sunday, August 04, 2013 5:17 AM
To: [email protected]
Subject: RE: [Toad for Oracle - Discussion Forum] Toad in 12.0 (as well in 12.1) script output
RE: Toad in 12.0 (as well in 12.1) script output
Reply by damir.vadas_531
CREATE TABLE ERROR_LOGS
ERR_TAG VARCHAR2(16 CHAR) DEFAULT ‘UNKNOWN’ NOT NULL,
ERR_DATE DATE NOT NULL,
ERR_NOTE VARCHAR2(1024 CHAR),
ERR_CODE INTEGER NOT NULL,
ERR_MSG VARCHAR2(1024 CHAR) NOT NULL,
ERR_USER VARCHAR2(64 CHAR),
ERR_USER_IP VARCHAR2(15 CHAR),
ID INTEGER NOT NULL
SET DEFINE OFF;
Insert into ERROR_LOGS
(ERR_TAG, ERR_DATE, ERR_NOTE, ERR_CODE, ERR_MSG,
ERR_USER, ERR_USER_IP, ID)
Values
(‘GENERAL’, TO_DATE(‘08/02/2013 10:36:26’, ‘MM/DD/YYYY HH24:MI:SS’), 'bad division,
ORA-06512: at “DVADAS.FORCE_ORA_ERROR”, line 11
----- PL/SQL Call Stack -----
object line object
handle number name
70000052af484b8 65 package body TOOLS.DEBUG_PKG
700000533a17828 17 procedure TOOLS.AUTO_LOG_ERROR_GENERAL
70000052b183428 15 procedure DVADAS.FORCE_ORA_ERROR
700000522ffa2d8 1 anonymous block
', -1476, ‘ORA-01476: divisor is equal to zero’,
‘DVADAS’, ‘10.52.236.25’, 2);
Insert into ERROR_LOGS
(ERR_TAG, ERR_DATE, ERR_NOTE, ERR_CODE, ERR_MSG,
ERR_USER, ERR_USER_IP, ID)
Values
(‘GENERAL’, TO_DATE(‘08/02/2013 10:36:27’, ‘MM/DD/YYYY HH24:MI:SS’), 'too many rows,
ORA-06512: at “DVADAS.FORCE_ORA_ERROR”, line 20
