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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
353 views