# Simple scrript

**URL:** <https://forums.toadworld.com/t/simple-scrript/9012>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 1, 2009, 2:45am UTC](https://forums.toadworld.com/t/simple-scrript/9012 "2009-12-01T02:45:59Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\
**Post date:** [December 1, 2009, 2:45am UTC](https://forums.toadworld.com/t/simple-scrript/9012/1 "2009-12-01T02:45:59Z")

</div>

Hi there:

With TOAD 10.1.0.7 I am not able to execute simple script:

set head off  
set feed off  
set lines 120  
set pages 60  
set verify off

spool pwd.lis  
select u.name||':'  
||u.password||':'  
||substr(u.spare4,3,63)||':'  
||d.name||':'  
||sys\_context('USERENV','SERVER\_HOST')||':'  
from sys.user$ u, sys.V\_$DATABASE d  
where u.type#=1  
/

The error message is:

select u.name||':'  
||u.password||':'  
||substr(u.spare4,3,63)||':'  
||d.name||':'  
||sys\_context('USERENV','SERVER\_HOST')||':'  
from sys.user$ u, sys.V\_$DATABASE d  
where u.type#=1  
\*  
Error at line 0  
ORA-01036: illegal variable name/number  
Script Terminated on line 8 of C:\Users\Acimobile\Documents\My  
Presentations\ORACLE\PeteFinnigan-Ostalo\scripts\pwd.sql.

No problems with TOAD 9.7.xxxx. Any idea ??????

## Regards!

Hi there:

With TOAD 10.1.0.7 I am not able to execute simple script:

set head off  
set feed off  
set lines 120  
set pages 60  
set verify off

spool pwd.lis  
select u.name||':'  
||u.password||':'  
||substr(u.spare4,3,63)||':'  
||d.name||':'  
||sys\_context('USERENV','SERVER\_HOST')||':'  
from sys.user$ u, sys.V\_$DATABASE d  
where u.type#=1  
/

The error message is:

select u.name||':'  
||u.password||':'  
||substr(u.spare4,3,63)||':'  
||d.name||':'  
||sys\_context('USERENV','SERVER\_HOST')||':'  
from sys.user$ u, sys.V\_$DATABASE d  
where u.type#=1  
\*  
Error at line 0  
ORA-01036: illegal variable name/number  
Script Terminated on line 8 of C:\Users\Acimobile\Documents\My  
Presentations\ORACLE\PeteFinnigan-Ostalo\scripts\pwd.sql.

No problems with TOAD 9.7.xxxx. Any idea ??????

Regards!

--

acip.vcf (298 Bytes)

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [December 1, 2009, 7:02am UTC](https://forums.toadworld.com/t/simple-scrript/9012/2 "2009-12-01T07:02:13Z")

</div>

In the meantime, the Execute as Script option to use QSR still works.

I think Toad doesn’t like the ‘:’

If I run this I get the same error message.

select sysdate || ':' from dual ;

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**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:** [December 1, 2009, 7:17am UTC](https://forums.toadworld.com/t/simple-scrript/9012/3 "2009-12-01T07:17:26Z")

</div>

It does seem to be angry with the ':'. Another work around is to change ':' to  
CHR(58)

set head off

set feed off

set lines 120

set pages 60

set verify off

spool pwd . lis

select u.name || CHR( 58 )

|| u.password || CHR( 58 )

|| substr(u. spare4 , 3 , 63 ) || CHR( 58 )

|| d .name || CHR( 58 )

|| sys\_context( 'USERENV' , 'SERVER\_HOST' ) || CHR( 58 )

from sys . user$ u, sys . V\_$DATABASE d

where u. type# = 1

/

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\
**Post date:** [December 1, 2009, 7:29am UTC](https://forums.toadworld.com/t/simple-scrript/9012/4 "2009-12-01T07:29:23Z")

</div>

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

> In the meantime, the Execute as Script option to use QSR still works.
> 
> I think Toad doesn't like the ':'
> 
> If I run this I get the same error message.
> 
> select sysdate || ':' from dual;
> 
> _From:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com) [[mailto:toad@yahoogroups.com](mailto:toad@yahoogroups.com)] \*On Behalf  
> Of \*Aci Polajnar  
> _Sent:_ Tuesday, December 01, 2009 3:46 AM  
> _To:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com)  
> _Subject:_ [toad] Simple scrript
> 
> Hi there:
> 
> With TOAD 10.1.0.7 I am not able to execute simple script:
> 
> set head off  
> set feed off  
> set lines 120  
> set pages 60  
> set verify off
> 
> spool pwd.lis  
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> /
> 
> The error message is:
> 
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> \*  
> Error at line 0  
> ORA-01036: illegal variable name/number  
> Script Terminated on line 8 of C:\Users\Acimobile\Documents\My  
> Presentations\ORACLE\PeteFinnigan-Ostalo\scripts\pwd.sql.
> 
> No problems with TOAD 9.7.xxxx. Any idea ??????
> 
> Regards!
> 
> --
> 
> \_\_\_\_\_\_\_\_\_\_ Information from ESET Smart Security, version of virus  
> signature database 4651 (20091201) \_\_\_\_\_\_\_\_\_\_
> 
> The message was checked by ESET Smart Security.
> 
> [http://www.eset.com](http://www.eset.com)

--

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

In the meantime, the Execute as Script option to use QSR still works.

I think Toad doesn’t like the ‘:’

If I run this I get the same error message.

select sysdate || ':' from dual ;  
[att1.dat](https://forums.toadworld.com/uploads/default/original/2X/d/d58027efc5b350a5d7288e0a4800e92648597765.dat) (73.2 KB)

---

<div class="post-metadata">

**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\
**Post date:** [December 1, 2009, 7:29am UTC](https://forums.toadworld.com/t/simple-scrript/9012/5 "2009-12-01T07:29:23Z")

</div>

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

> In the meantime, the Execute as Script option to use QSR still works.
> 
> I think Toad doesn't like the ':'
> 
> If I run this I get the same error message.
> 
> select sysdate || ':' from dual;
> 
> _From:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com) [[mailto:toad@yahoogroups.com](mailto:toad@yahoogroups.com)] \*On Behalf  
> Of \*Aci Polajnar  
> _Sent:_ Tuesday, December 01, 2009 3:46 AM  
> _To:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com)  
> _Subject:_ [toad] Simple scrript
> 
> Hi there:
> 
> With TOAD 10.1.0.7 I am not able to execute simple script:
> 
> set head off  
> set feed off  
> set lines 120  
> set pages 60  
> set verify off
> 
> spool pwd.lis  
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> /
> 
> The error message is:
> 
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> \*  
> Error at line 0  
> ORA-01036: illegal variable name/number  
> Script Terminated on line 8 of C:\Users\Acimobile\Documents\My  
> Presentations\ORACLE\PeteFinnigan-Ostalo\scripts\pwd.sql.
> 
> No problems with TOAD 9.7.xxxx. Any idea ??????
> 
> Regards!
> 
> --
> 
> \_\_\_\_\_\_\_\_\_\_ Information from ESET Smart Security, version of virus  
> signature database 4651 (20091201) \_\_\_\_\_\_\_\_\_\_
> 
> The message was checked by ESET Smart Security.
> 
> [http://www.eset.com](http://www.eset.com)

--

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

In the meantime, the Execute as Script option to use QSR still works.

I think Toad doesn’t like the ‘:’

If I run this I get the same error message.

select sysdate || ':' from dual ;

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\
**Post date:** [December 1, 2009, 7:29am UTC](https://forums.toadworld.com/t/simple-scrript/9012/6 "2009-12-01T07:29:23Z")

</div>

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

> In the meantime, the Execute as Script option to use QSR still works.
> 
> I think Toad doesn't like the ':'
> 
> If I run this I get the same error message.
> 
> select sysdate || ':' from dual;
> 
> _From:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com) [[mailto:toad@yahoogroups.com](mailto:toad@yahoogroups.com)] \*On Behalf  
> Of \*Aci Polajnar  
> _Sent:_ Tuesday, December 01, 2009 3:46 AM  
> _To:_ [toad@yahoogroups.com](mailto:toad@yahoogroups.com)  
> _Subject:_ [toad] Simple scrript
> 
> Hi there:
> 
> With TOAD 10.1.0.7 I am not able to execute simple script:
> 
> set head off  
> set feed off  
> set lines 120  
> set pages 60  
> set verify off
> 
> spool pwd.lis  
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> /
> 
> The error message is:
> 
> select u.name||':'  
> ||u.password||':'  
> ||substr(u.spare4,3,63)||':'  
> ||d.name||':'  
> ||sys\_context('USERENV','SERVER\_HOST')||':'  
> from sys.user$ u, sys.V\_$DATABASE d  
> where u.type#=1  
> \*  
> Error at line 0  
> ORA-01036: illegal variable name/number  
> Script Terminated on line 8 of C:\Users\Acimobile\Documents\My  
> Presentations\ORACLE\PeteFinnigan-Ostalo\scripts\pwd.sql.
> 
> No problems with TOAD 9.7.xxxx. Any idea ??????
> 
> Regards!
> 
> --
> 
> \_\_\_\_\_\_\_\_\_\_ Information from ESET Smart Security, version of virus  
> signature database 4651 (20091201) \_\_\_\_\_\_\_\_\_\_
> 
> The message was checked by ESET Smart Security.
> 
> [http://www.eset.com](http://www.eset.com)

--

Hi Jeff, the problem is that same query works fine in TOAD 9.7.  
Do we have a bug ??

Regards!

Jeff Smith wrote:

In the meantime, the Execute as Script option to use QSR still works.

I think Toad doesn’t like the ‘:’

If I run this I get the same error message.

select sysdate || ':' from dual ;  
[acip.vcf](https://forums.toadworld.com/uploads/default/original/1X/9c7a2868d644bf6b3033f304f52cba7afecb1d9b.vcf) (298 Bytes)

---

<div class="post-metadata">

**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:** [December 1, 2009, 7:33am UTC](https://forums.toadworld.com/t/simple-scrript/9012/7 "2009-12-01T07:33:56Z")

</div>

Aci,

It looks like a bug. I'm digging a bit deeper to see what the cause is.

Greg

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**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:** [December 1, 2009, 7:33am UTC](https://forums.toadworld.com/t/simple-scrript/9012/8 "2009-12-01T07:33:56Z")

</div>

Aci,

It looks like a bug. I'm digging a bit deeper to see what the cause is.

Greg

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [December 1, 2009, 7:34am UTC](https://forums.toadworld.com/t/simple-scrript/9012/9 "2009-12-01T07:34:29Z")

</div>

Anything that will run in SQL\*Plus but not in Toad is probably a bug, but  
I’ll let the Toad folks confirm that or not.

 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [December 1, 2009, 11:13am UTC](https://forums.toadworld.com/t/simple-scrript/9012/10 "2009-12-01T11:13:41Z")

</div>

place at the begiinig of the script:  
set define off

Damir Vadas

> **[Damir Vadas, Oracle as I learned](https://damir-vadas.blogspot.com/)**
>
> This blog has been created just to express some of my thoughts publicly. To share something with beautiful Oracle community.
> 
> Let me share some knowledge ...

* * *

place at the begiinig of the script:  
set define off

Damir Vadas

> **[Damir Vadas, Oracle as I learned](https://damir-vadas.blogspot.com/)**
>
> This blog has been created just to express some of my thoughts publicly. To share something with beautiful Oracle community.
> 
> Let me share some knowledge ...

  
 ![Podpis.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/fb53f537d111574f338f3afbd804bbbf8f701cbe.jpeg)