|
 |
|
Oracle Tips by Burleson |
Creating
the PL/SQL Procedure to Display the Image with APEX
At this point, the PL/SQL procedure that will be
used to download the image into the browser has to be created.
Navigate to the SQL Workshopand
click on the SQL Script icon.
1.
On the SQL Scripts page click the Upload button.
2.
On the Upload Script page:
·
File: C:\htmldb_book\CodeDepot\plsql_display_easy_image.sql
·
Script Name: Display Easy Image PLSQL.
·
Click Upload.
3. Once
the script is uploaded, click on the run button to the right of the
Display Easy Image PLSQL script. Tip: If it is sorted by Last Updated
in descending order it will be the first row in the report.
4. Click
the Run button on the next page also.
5. Now
that the PL/SQL Procedure has been created and the execute privilege
has been granted to public, click on the Application Builder tab to go
back to the Application Builder Home page. Then click on the Easy
HTML DB Book link. You are now at the Application Home page and ready
to continue on to Create the next application page.
The text of the plsql_display_easy_images.sql file
is shown here to make referencing it convenient.
Take
note of the fact that this procedure must be granted execute to
public. Forgetting this little detail can be the source of great
frustration.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm |
