Home » Developer & Programmer » Forms » Cannot get this to compile in Reports
Cannot get this to compile in Reports [message #78626] Wed, 06 March 2002 03:54 Go to next message
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.
Re: Cannot get this to compile in Reports [message #78627 is a reply to message #78626] Wed, 06 March 2002 04:04 Go to previous message
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
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:
  


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