# Toad in 12.0 (as well in 12.1) script output **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [August 2, 2013, 2:45am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102 "2013-08-02T02:45:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [August 2, 2013, 2:45am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/1 "2013-08-02T02:45:52Z")
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](https://global.discourse-cdn.com/quest/original/2X/a/ae5aec71298a6ec1b6e7c93ae37d7fa6126d7db1.png) 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 ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [August 2, 2013, 2:55am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/2 "2013-08-02T02:55:51Z")
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](mailto:bounce-damirvadas_531@toadworld.com) wrote: > **[Toad in 12.0 (as well in 12.1) script output](http://gyk.r.mailjet.com/redirect/09oyt1zksn3bcyokohkgn9/www.toadworld.com/products/toad-for-oracle/f/10/t/20008.aspx)** > 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 > > ``` ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [August 2, 2013, 4:25am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/3 "2013-08-02T04:25:51Z")
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](mailto:bounce-damirvadas_531@toadworld.com)] **Sent:** Friday, August 02, 2013 5:46 AM **To:** [toadoracle@toadworld.com](mailto: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](http://gyk.r.mailjet.com/redirect/09oyt1zksn3bcyokohkgn9/www.toadworld.com/products/toad-for-oracle/f/10/t/20008.aspx)** 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 ``` ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [August 4, 2013, 2:15am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/4 "2013-08-04T02:15:59Z")
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; ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [August 5, 2013, 6:01am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/5 "2013-08-05T06:01:04Z")
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](mailto:bounce-damirvadas_531@toadworld.com)] **Sent:** Sunday, August 04, 2013 5:17 AM **To:** [toadoracle@toadworld.com](mailto: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](http://gyk.r.mailjet.com/redirect/jlnchnfzlzlo673dgndr60/www.toadworld.com/products/toad-for-oracle/f/10/p/20008/40455.aspx#40455)** 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 ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [August 5, 2013, 10:27am UTC](https://forums.toadworld.com/t/toad-in-12-0-as-well-in-12-1-script-output/26102/6 "2013-08-05T10:27:07Z")
This is fixed for the next beta. Greg