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;
