New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
SubEBS

Oracle Reports Java Barcode Error: cf_barcodeformula : Fatal PL/SQL error occured

The IDAutomation Barcode Java product (jar) within our reports is not working after the latest Java 6.0 Update (JDK : 1.6.0_33)
It was working perfectly fine before we moved to latest Java. To confirm if this issue is caused by the Java update, we removed this latest Java update and tested with the previous version, and it started working again. So it has been confirmed that the LinearBarcode.jar is not compatible with the latest version.

So is there a patch from IDAutomation for this to make the jar compatible for the latest Java?

“'cf_barcodeformula : Fatal PL/SQL error occured"
ORA -39565 : Message 39565 not found; Product=RDBMS facility=ORA”


07-21-12     2556 day(s) ago    

  Report Abuse

 

HankF

Best Answer

By now you have probably resolved this, so this response may be of more use to others who pass by here.

When I encountered this error it was resolved by correcting the location of the jar file, and the "REPORTS_CLASSPATH" in the environment. The ORA-39565 error indicated that Oracle Reports runtime could not find the IDAutomation jar file. Establishing where to place jar files, and confirming that with the REPORTS_CLASSPATH environment variable setting resolved the error.

HankF

Posted 2494 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (2)

SubEBS
We get the generic error message below. This only happens on the latest patch which we applied on the latest JDK version, and it still works if we revert the latest version.

"'cf_barcodeformula : Fatal PL/SQL error occured"
ORA -39565 : Message 39565 not found; Product=RDBMS facility=ORA


Code within the report is
=============================
function CF_barcodeFormula return Char is

/*name of temp file*/
ImageFile VarChar2(250);
/*object containing barcode properties*/
BarcodeObject ORA_JAVA.JOBJECT;
/*object that creates jpeg of barcode based on BarcodeObject*/
BarcodeEncoderObject ORA_JAVA.JOBJECT;
begin
/*Get a temporary file name for the jpeg*/
imageFile := srw.create_temporary_filename();
/*Create the barcode object*/
BarcodeObject := Barcode.new();
/*Set the symbology*/
if :P_BARCODE_FILE='Code39' THEN --'Code128
Barcode.setSymbologyID(BarcodeObject, Barcode.CODE39);
else
Barcode.setSymbologyID(BarcodeObject, Barcode.CODE128);
barcode.setXDimensionCM(BarcodeObject,.10);
end if;
barcode.setShowText(BarcodeObject,false);
barcode.setCheckCharacterInText(BarcodeObject,false);

--barcode.setXDimensionCM(BarcodeObject,.10);
--barcode.setBarHeightCM(BarcodeObject,.10);
/*set the data to encode*/
Barcode.setDataToEncode(BarcodeObject, to_char(:wo_wip_entity_name));
/*Create the jpeg*/
BarcodeEncoderObject := BarcodeEncoder.new(BarcodeObject, 'JPEG',ImageFile);
/*If, for some reason, the barcode is not created, return null
otherwise, return the name of the barcode image jpeg that was
created */
if ORA_JAVA.IS_NULL(BarcodeEncoderObject) then
return(NULL);
else
return(ImageFile);
end if;

end;
=============================

Posted 2554 day(s) ago

()
()
   Report Abuse

Tim
SubEBS,

The jar file should work, because it was compiled in a previous version of Java.
I will run some tests on our end to try and recreate the error.
Can you post some more details on how it is failing?
Are there any error messages being thrown, does the project compile, etc...?
If you can also include some code snippets that would be a big help as well.
Thank you.

Posted 2554 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook