Posts

Showing posts from July, 2020

Displaying Images in Oracle Apex

Image
Displaying Images in Oracle Apex Steps : 1. Create PL/SQL dynamic Content Region and write the code declare  cursor c1 is   select FILE_SHORT_INFO,emp_code from prtl_files where emp_code = :P8_empcd;  t varchar2(200); begin    for i in c1    loop     htp.p('<body>');htp.p('<p>&nbsp;</p>');        htp.p('<table width="100%">');         htp.p('<tr>');       for rec in (select * from PRTL_FILES                where emp_code = :P8_EMPCD and status='A')     loop       IF rec.ATT_MIMETYPE is not null or rec.ATT_MIMETYPE != '' THEN  htp.p('<td colspan="2">'); htp.p( '<img src="my_image_display?                          fid='||NVL(rec.FILE_ID,0)||'" height="'||100||'"/>' );    ...
Post a Comment
Read more

Printing Bar Code in Oracle Apex

Image
Bar Code report in Oracle Apex Steps: 1.  Download barcode font  https://www.wfonts.com/font/code39azalea 2. Upload the both .ttf & .woff font in Application > Shared Component > Static Application Files 3. Write the below code      a. Pages Designer > Javascript >  Function and Global Variable Declaration function printContent(el){       var restorepage = $('body').html();       var printcontent = $('#' + el).clone();       $('body').empty().html(printcontent);       window.print();       $('body').html(restorepage);       }    b.  Pages Designer >  CSS > Inline @font-face {    font-family: 'barcode';           src: url('#APP_IMAGES#Code39Azalea.ttf') format('truetype');           src: url('#APP_IMAGES#Code39Azalea.woff') format('woff');    ...
Post a Comment
Read more