Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » toolkit error (AS 10gR2 RHEL5.5x86_64)
toolkit error [message #614866] Tue, 27 May 2014 23:42 Go to next message
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 #614872 is a reply to message #614866] Wed, 28 May 2014 01:27 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to fix CF_1FORMULA first, as it ends up without returning a value.
Re: toolkit error [message #614946 is a reply to message #614872] Thu, 29 May 2014 01:02 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
how to debug CF_1Formula
as you said
Try to fix CF_1FORMULA first, as it ends up without returning a value.
Re: toolkit error [message #614948 is a reply to message #614946] Thu, 29 May 2014 01:11 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, maybe you should ask someone who knows how to use Reports Builder.

Normally, it is done by opening that report, finding CF_1 formula column in Data Model Editor, edit its PL/SQL code, spotting the culprit and fixing the issue.
Re: toolkit error [message #615102 is a reply to message #614948] Fri, 30 May 2014 04:38 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 21806
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

Previous Topic: Oracle 10g Font Change on Web
Next Topic: Help on URL Masking
Goto Forum:
  


Current Time: Thu Mar 28 10:49:51 CDT 2024