Toad in 12.0 (as well in 12.1) script output

Toad for Oracle
1

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
----- PL/SQL Call Stack -----
object line object
handle number name
70000052af484b8 65 package body TOOLS.DEBUG_PKG
700000533a17828 17 procedure TOOLS.AUTO_LOG_ERROR_GE
NERAL
70000052b183428 23 procedure DVADAS.FORCE_ORA_ERROR
700000522ffa2d8 1 anonymous block

Run in Toad script I get result as in pic:

run script error3.png
run script error3.png1858×1080 120 KB

Problem is that "rows" value was repeated in every row instead just once (as shown in sqlplus)

MIne config:

Toad 12.0 (12.1.05 beta as well)

Windows 7 Pro x64

Client Oracle 11.2.0.3 x64

queried 11.2.0.3 x64 database

2

Looks like a bug. I'll check it out.

Greg

On Aug 2, 2013, at 5:46 AM, "damir.vadas_531" bounce-damirvadas_531@toadworld.com wrote:

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
3

Could you send the script to create your ERROR_LOGS table? You can send it offline to

gregory liss software dell com

thanks,

Greg

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Friday, August 02, 2013 5:46 AM

To: toadoracle@toadworld.com

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
4

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;

5

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.

Greg

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Sunday, August 04, 2013 5:17 AM

To: toadoracle@toadworld.com

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

6

This is fixed for the next beta.

Greg