Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to store a pdf (invoice) into database table that is created using plsql dynamic content in apex.

Andrew RDec 23 2023 — edited Jan 30 2025

Hi Experts and ***moderator action: removed call out to member that has not participated in this thread***,

I created an invoice using plsql dynamic content in oracle apex where I have used HTML and CSS to design the invoice (code below). When I open the page the code gets executed and provides the below output (shown in image). Now I want to save that invoice into my database table ( INVOICE_DOC) as a pdf file. Below is the outcome of the plsql dynamic content. How to achieve this? Thanks.

CREATE TABLE "INVOICE_DOC" 
        (   "IMAGE" BLOB, 
            "MIMETYPE" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
            "IMAGE_FILENAME" VARCHAR2(50) COLLATE "USING_NLS_COMP"
         ) ;



    Declare

    V_BILL_No number;
    V_TOTAL_AMT number;
    V_ORDER_DATE varchar2(30);
    v_cust_name varchar2(30);
    V_sno number := 1;
    v_discount_amt number := 20;

    v_title invoice_bill.title%type := 'DATABYTEZ';
    v_address_1 invoice_bill.address_1%type := 'No. 1/18, ECR ROAD';
    v_address_2 invoice_bill.address_2%type := 'xxyyvvvbbcfv';
    v_address_3 invoice_bill.address_3%type := 'dummy - 600 115.';
    v_address_4 invoice_bill.address_4%type := 'Ph: 123456790';

    begin

*** some logic to get the structure ***
     End;

Comments
Post Details
Added on Dec 23 2023
3 comments
553 views