| BarCode Report Oracle 10g [message #507013] |
Thu, 12 May 2011 04:29  |
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
Dear All
I have created a report which generates barcode, it is working fine in development environment.(Report Builder 10.1.2.0.2)
but when i place it on Application server and want to call it from there, it terminates with error. and error log is
Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA
report attached: please help.
regards
|
|
|
|
|
|
| Re: BarCode Report Oracle 10g [message #507066 is a reply to message #507031] |
Thu, 12 May 2011 06:33  |
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
Littlefoot wrote on Thu, 12 May 2011 04:58Please, post contents of Before Report trigger.
function BeforeReport return boolean is
begin
globals.barcode_to_use:=BarCodeConstants.BAR_CODE_128;
globals.bcobj := barcodemaker.new();
return (TRUE);
end;
report is attached. please view it.
[Updated on: Thu, 12 May 2011 06:35] Report message to a moderator |
|
|
|
| Re: BarCode Report Oracle 10g [message #507085 is a reply to message #507013] |
Thu, 12 May 2011 07:32 |
cookiemonster
Messages: 9284
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
myclassic wrote on Thu, 12 May 2011 10:29
Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA
The fact that it can't find the correct error message text strongly implies oracle isn't installed properly on that server. I suggest you fix that first.
|
|
|
|
| Re: BarCode Report Oracle 10g [message #507092 is a reply to message #507085] |
Thu, 12 May 2011 07:40 |
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
cookiemonster wrote on Thu, 12 May 2011 07:32myclassic wrote on Thu, 12 May 2011 10:29
Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA
The fact that it can't find the correct error message text strongly implies oracle isn't installed properly on that server. I suggest you fix that first.
Sir Oracle is working fine. Apps server is working correctly with all forms and reports exept this report.
|
|
|
|
| Re: BarCode Report Oracle 10g [message #507093 is a reply to message #507092] |
Thu, 12 May 2011 07:43 |
cookiemonster
Messages: 9284
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
The message you state clearly shows oracle is not installed properly. Unless it's giving a phantom error number - in which case you need to contact oracle support.
|
|
|
|
|
|
|
|
| Re: BarCode Report Oracle 10g [message #507206 is a reply to message #507095] |
Fri, 13 May 2011 02:46 |
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
ramoradba wrote on Thu, 12 May 2011 07:53http://forums.oracle.com/forums/thread.jspa?threadID=154911
Sriram
Dear
Thanks a lot.
It is really a wonderful link.
Actually we need to add the classpath in conf file of Reports in Application server.
Simply modify the following lines
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" classPath="d:\oracle\reports\jlib\oraclebarcode.jar"[/b]>?
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" classPath="d:\oracle\reports\jlib\oraclebarcode.jar"/>
|
|
|
|
|
|
| Re: BarCode Report Oracle 10g [message #507485 is a reply to message #507235] |
Mon, 16 May 2011 03:02 |
 |
ramoradba
Messages: 2427
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
myclassic wrote on Mon, 16 May 2011 13:25Dear
Thanks a lot for providing me help.
I want another favour from you.
I want to print this barcode on a sticker. and i am using it in 10g. i want to print it on client's printer.
how to do that?
client printer is not accessable in oracle report 10g. if i set the destination to printer in report .. i tries to access application server. where as i want it to print on client's local printer.
you may reply to maanosajnabi@yahoo.com
please help.
regards
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
