File Upload and Download in Oracle APEX Page

By -

 

Create table structure 



CREATE TABLE XX_TEMPLATE_FILE_UPLOAD_ALL

(

   TEMPLATE_ID         NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,

   TEMPLATE_NAME       VARCHAR2 (1000) DEFAULT 'File Upload',

   FILE_NAME           VARCHAR2 (1000),

   FILE_ATTACHMENT     BLOB,

   MIME_TYPE           VARCHAR2 (1000),

   FILE_CHARSET        VARCHAR2 (1000),

   STATUS              VARCHAR2 (1000),

   CREATION_DATE       DATE DEFAULT SYSDATE,

   CREATED_BY          NUMBER DEFAULT 1,

   LAST_UPDATE_DATE    DATE DEFAULT SYSDATE,

   LAST_UPDATED_BY     NUMBER DEFAULT 1,

   LAST_UPDATE_LOGIN   NUMBER DEFAULT 1,

   CONSTRAINT TEMPLATE_ID_XX_PK PRIMARY KEY (TEMPLATE_ID)

)

















































































































Pranay is a versatile Oracle Technical consultant. Adept in Oracle ERP development, SDLC management, design, and architecture. He has 11 years of extensive experience in Oracle Apps implementation engaged in technical development areas of Oracle Applications 11i/R12 E-Business Suite. He possesses sound knowledge in technologies like OAF, ADF, J2EE, MSCA, Oracle PaaS Cloud, Java Cloud services, ADF & XML Publisher. Currently, he is working for BirlaSoft Inc. USA. Being a Consistent solution provider in Oracle Developer Community forums earned him the title of "Technology Master”, Currently he holds 3rd position globally for providing a solution in Oracle Developer Community for the OAF Workspace. He has also authored several articles on ADF Technology, Fusion Financials, OAF & PaaS Cloud. He successfully presented the case study in Oracle Collaborate event forum on "How optimizing the Oracle Mobile App Solution Helped in Boosting the Productivity of a Warehouse."

Comments

Post a Comment

Popular posts from this blog

Sample HZ API's script to Create Contacts and Contact Points in Oracle

By -
1. Below Code will create Contact Point in Oracle . DECLARE    P_CONTACT_POINT_REC   HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;    P_PHONE_REC           HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;    P_EDI_REC_TYPE        HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;    P_EMAIL_REC_TYPE      HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;    P_TELEX_REC_TYPE      HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;    P_WEB_REC_TYPE        HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;    X_RETURN_STATUS       VARCHAR2 (1000);    X_CONTACT_POINT_ID    NUMBER;    X_MSG_COUNT           NUMBER;    X_MSG_DATA            VARCHAR2 (1000); BEGIN    P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'EMAIL';    P_CONTACT_POINT_REC.OWN...
Read more

PO Creation API in EBS R12.2.X

By -
  This BLOG provides a step-by-step approach to creating a Purchase Order (PO) API in Oracle E-Business Suite (EBS). The API automates the conversion of approved purchase requisitions into purchase orders using PL/SQL procedures. /* Formatted on 3/26/2025 3:56:31 PM (QP5 v5.269.14213.34769) */ DECLARE    l_return_status         VARCHAR2 (1);    l_msg_count             NUMBER;    l_msg_data              VARCHAR2 (5000);    l_num_lines_processed   NUMBER;    l_document_number       po_headers_all.segment1%TYPE;    l_document_id           NUMBER;    l_msg                   VARCHAR2 (5000);    l_msg_index_out         NUMBER;    v_item_key   Varchar2(100); ...
Read more

OIC Tutorial Link

By -
  # Tutorial Link 1 What is Oracle Integration Cloud Service? What is the various type of integration flows available in OIC? 2 Building Blocks and Life cycle operations of an Integration in Oracle Integration Cloud Services 3 Quick 3 steps to create Oracle Integration Cloud instance in Oracle Cloud Environment? 4 What are the Different Types of Integration Patterns available in Oracle Integration Cloud Services? 5 Explorations of Accelerators and Recipe in Oracle Integration Cloud Services 6   Build Sample REST integration using Oracle Integration Cloud services 7   Consuming External Rest API in Oracle Integration Cloud service 8   Decoding Agents in Oracle Integration Cloud Services and explore the prerequisites required to install the Connectivity Agent on your local netw...
Read more