Resolved Questions

SubEBS

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

Tagged With:-

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 the 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 LinearBarcode.jar is not compatible with the latest version.

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

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

07-21-12 11.6 year(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 using the Oracle Reports IDAutomation solution, verify the location of the Jar. 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 11.4 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (1)

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 to the latest version.

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

The 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 11.6 year(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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