OraFAQ Forum: Forms » Cannot get this to compile in Reports

Home » Developer & Programmer » Forms » Cannot get this to compile in Reports

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

Cannot get this to compile in Reports [message #78626]

Wed, 06 March 2002 03:54

nik for Pratap
Messages: 2
Registered: March 2002

Junior Member

cursor get_time is
select 6 + (to_number(to_char(trunc(:mins/60)))) ||'.'||to_number(to_char(mod(:mins,60)))
from dual;

begin
null;
end;

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

Although works fine in SQLplus when I substitute ":mins" for "&mins"

Any suggestions please ?

Nik.

Report message to a moderator

Re: Cannot get this to compile in Reports [message #78627 is a reply to message #78626]

Wed, 06 March 2002 04:04

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi,

try this, it will solve u r problem

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

cheers
pratap

Report message to a moderator

Previous Topic:	how transfer data from excel to form with tabular block???? PLS HELP
Next Topic:	Problem with text item of forms 6 Immediate help reqd

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 01 09:08:41 CST 2023