| toolkit error [message #614866] |
Tue, 27 May 2014 23:42  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
Machine Name= test.abc.net
IP = 192.168.50.22
OS = RHEL 5.5
run level 3
App Server = 10gR2 (forms/report server)
Running barcode report on web.
When setting in opmn.xml file
REPORTS_DEFAULT_DISPLAY="YES"
DISPLAY=test.abc.net:0.0
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.
ORA-06503: PL/SQL: Function returned without value
When setting in opmn.xml file
REPORTS_DEFAULT_DISPLAY="NO"
DISPLAY=test.abc.net:0.0
REP-3000: Internal error starting Oracle Toolkit.
|
|
|
|
|
|
|
|
|
|
| Re: toolkit error [message #615102 is a reply to message #614948] |
Fri, 30 May 2014 04:38  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
as developers have no expertise about this...
Please guide us step by step .....to resolve this issue
Moreover it works on windows.using developer 10g.... But When we deploy it on Oracle Application Server 10gR2 on linux then it happen
[Updated on: Fri, 30 May 2014 04:39] Report message to a moderator |
|
|
|
| Re: toolkit error [message #615107 is a reply to message #615102] |
Fri, 30 May 2014 05:08 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Eh? Developers can't debug one formula column? You must be joking. How did they manage to create a report, then?
P.S. "ORA-06503: PL/SQL: Function returned without value" doesn't depend on operating system. If the same function sometimes work and sometimes not, I suspect that it contains exception handler section which doesn't contain RETURN clause. For example, this is what you have now:
formula cf_1 return varchar2 is
l_ename emp.ename%type;
begin
select ename
into l_ename
from emp
where empno = :par_empno;
return (l_ename); -- value returned if SELECT finds an employee whose EMPNO = :PAR_EMPNO
exception
when no_data_found then
null; --> this is wrong
end;
"null" within the NO_DATA_FOUND is wrong. Normally, in an anonymous PL/SQL block, that would be OK, but a function MUST return some value. Therefore, you should modify that line and change it to
exception
when no_data_found then
return (null); --> now, it is OK
[Updated on: Fri, 30 May 2014 05:24] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
