![]() ![]() We are on table C, try to process 2 digitsĭummy := TO_NUMBER(SUBSTR(p_input, i, 2)) V_retval := v_retval||CHR(204) -switch to tabelC Determine if the p_cnt characters from p_start are numeric * written by David Pyke ( )Ĭ_pinput_length CONSTANT NUMBER := LENGTH(p_input) įUNCTION usetableC(p_start NUMBER, p_cnt NUMBER) * the CODE128.TTF font can be source from ![]() * * an empty string if the supplied parameter is no good * Return : * a string which give the bar code when it is dispayed with CODE128.TTF font * This function is governed by the GNU Lesser General Public License (GNU LGPL) We have found a PL/SQL function which converts that with no problem but our restriction here is that we are using Oracle Cloud ( Fusion ERP) and therefore we can't create any objects in the DB.Īny pointers/hints if the below is doable in SQL only, please?ĬREATE OR REPLACE FUNCTION Code128(P_INPUT varchar2) return varchar2 We have a requirement to display a specific numeric value to Code 128 ( this is a barcode font). 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |