Label Printing from PL/SQL

There are cases where we need to print Labels from PL/SQL Package. It can be achieved through Oracle API. (INV_PRINT_REQUEST.SEND_XML_TCPIP)
API Description
/*
* Method for sending a string to a TCP-IP address. Used to send the
* label-XML file to a print-server. The x_return_msg returns any
* message send back from this TCP-IP address. This function returns
* 0 if the file was send successfully. It returns -1 if there was
* any error.
*/

Usage Example

v_num_return :=
INV_PRINT_REQUEST.SEND_XML_TCPIP (v_chr_ip_address,
TO_CHAR (v_num_port_no),
v_chr_xml_content,
v_chr_ret_msg,
v_chr_print_status);

Limitations :- XML Content cannot exceed 4000 Chars.

Advertisements