OraFAQ Forum: Forms » works in sql+ but not in reports

Home » Developer & Programmer » Forms » works in sql+ but not in reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: works in sql+ but not in reports [message #78621 is a reply to message #78617]

Wed, 06 March 2002 03:35

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

Report message to a moderator

Previous Topic:	Have a look at this people, it's strange SQL things
Next Topic:	Re: Binary tree or Trie

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 07:06:41 CDT 2024