Toad World® Forums

Simple scrript


#1

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


#2

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


#3

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


#4

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] *On Behalf
Of *Aci Polajnar
Sent: Tuesday, December 01, 2009 3:46 AM
To: 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

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 (73.2 KB)


#5

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] *On Behalf
Of *Aci Polajnar
Sent: Tuesday, December 01, 2009 3:46 AM
To: 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

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


#6

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] *On Behalf
Of *Aci Polajnar
Sent: Tuesday, December 01, 2009 3:46 AM
To: 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

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 (298 Bytes)


#7

Aci,

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

Greg
Podpis.jpeg


#8

Aci,

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

Greg
Podpis.jpeg


#9

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


#10

place at the begiinig of the script:
set define off

Damir Vadas


place at the begiinig of the script:
set define off

Damir Vadas


Podpis.jpeg