works in sql+ but not in reports [message #78617] |
Wed, 06 March 2002 00:51 |
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.
|
|
|
|