Home » Developer & Programmer » Forms » works in sql+ but not in reports
works in sql+ but not in reports [message #78617] Wed, 06 March 2002 00:51 Go to next message
nik
Messages: 55
Registered: January 2002
Member
Hello,
I run the following code in sqlplus and it works fine, but reports 2.5 does not accept it;

select 6 + (to_number(to_char(trunc(&mins/60))))||'.'||to_number(to_char(mod(&mins,60)))
from dual;

get the follwoing error
-----------------------
error 306 wrong number or types of arguments in call to '||'

This I understand but I do'nt understand why it works in sqlplus and not reports 2.5 ?

Please note: &mins is :mins in reports program unit.

Any suggestions warmly welcomed

Thanks
Nik.
Re: works in sql+ but not in reports [message #78621 is a reply to message #78617] Wed, 06 March 2002 03:35 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
the substitution variable like &min is not allowed in the report it is a sql*plus concept. use parameter variable or placeholder column instead
Previous Topic: Have a look at this people, it's strange SQL things
Next Topic: Re: Binary tree or Trie
Goto Forum:
  


Current Time: Fri Dec 03 08:25:32 CST 2021