Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training

By M&S Consulting (Kevin) on Aug 6th, 2009
Filed Under Technical Tips // Tags: ,

Introduction

Reports and data entry constitue the bulk of what most of these tutorials cover, and what
many businesses need. However, there is the need to be able to upload documents for anyone with
permissions to share, afterall, why re-create the same document 100 times if you can just
upload it, and others can download it. This tutorial focuses on integrating document upload and
download into an APEX application. We reccomend you review our Oracle APEX Tutorial Preparation and OEHR Sample Data Install article before beginning.

Part 1 - Creating and Testing the Base Application and Report.

YouTube Preview Image

High Level Steps

1) Create base Application (0:30)
2) Create Upload section and test (1:59)
3) Create Report with Links (4:49)
4) Setting up for Additional Information (7:05)

Times in parenthesis are approximate start times for that step

Notes and Information

Differing Results

Some of the screen shots in the video may vary from your own screen shots as you proceed
through this tutorial. This is due to the fact that you may not be on an installation of APEX
that was made specifically for training. You may see other files in your report, as your DBA
may have other workspaces and items in another part of the installation.

APEX Appliation calls

In this tutorial we again call a built in feature of APEX. In our APEX Tutorial 5 (Working
with Check Boxes
) We used the APEX_APPLICATION_G.x feature to dynamically create items. In this
tutorial, we are using the APEX_APPLICATION_FILES package which allows you to access any file
that has been uploaded to the APEX system. It is actually a view on an internal table that is
accessible to all workspaces through the view.

Code and Pasted Text

Upload Region Item Name

P1_FILE_NAME

SQL for Uploaded Files Report

SELECT id,name FROM APEX_APPLICATION_FILES

Table Creation Command for File Subject table

CREATE TABLE oehr_file_subject
(name VARCHAR2(4000) PRIMARY KEY,
subject VARCHAR2(4000));

Insert File Description Process

INSERT INTO oehr_file_subject(name,subject) VALUES (:P1_FILE_NAME, :P1_FILE_SUBJECT);
Bookmark and Share

Related Information:

  1. Oracle APEX Tutorial 8 - Up and Downloading Files - Part 2 - Video Training
    Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...
  2. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training
    This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...
  3. Oracle APEX Tutorial 3 - Drilldown Report Part 2- Video Training
    This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report...
  4. Oracle APEX Tutorial 4 – Form Layout – Part 1 – Video Training
    APEX gives you a lot of power and flexibility with its built in wizards. They are very good at creating...
  5. Oracle APEX Tutorial 5 – Check Boxes – Part 1 – Video Training
    Within APEX, there are a multitude of things you can use Check Boxes for, and many ways they can be...
  6. Oracle APEX Tutorial 2 - Parameterized Report Part 2 - Video Training
    This Tutorial is a guided walkthrough of section 3 of the Oracle APEX Advanced Tutorials....
  7. Oracle APEX Tutorial 10 - Access Control - Part 1 - Video Training
    Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
  8. Oracle APEX Tutorial 4 – Form Layout – Part 2 – Video Training
    APEX gives you a lot of power and flexibility with it's built in wizards. They are very good at creating...

Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service