Creating bar codes using external functions in Oracle

After you have inserted the bar code function declarations in to your Oracle application (See Declaring external functions), you can use bar code functions in Oracle just like existing functions.

Note: For each type of bar code, there is a unique function to use and an associated bar code font to select. See Bar code functions and Bar code font name and font size to use.

DECLARE
	i VARCHAR2(50);
	o VARCHAR2(50);
BEGIN
	i := '1234567890';
	EXECUTE IMMEDIATE 'CALL CIAXCOM_EAN128(:i, :o)' USING i, o;
END;

or

DECLARE
	i VARCHAR2(50);
	o VARCHAR2(50);
BEGIN
	i := '1234567890';
	CIAXCOM_EAN128(i, o);END;

 

 


Copyright 2000 CIA (BAR CODES) UK. All rights reserved. Reproduction prohibited.