Databases Reference
In-Depth Information
Figure 6-77.
Modifying the BLOB column attributes
10.
Scroll to the top of the page, and click
Apply Changes
.
Run the application. Test the file upload and download capabilities by attaching a file to one of the Ticket Details
records and then downloading it from the report.
This ability to easily upload and download files in APEX is extremely useful in building web applications where
users need to upload and download data for whatever purpose. The Declarative BLOBs feature of APEX makes it
simple for developers to add upload and download capabilities to an application.
Summary
You've reviewed most of the APEX form and report types and walked through building various forms and reports
for your Help Desk system using the APEX form and report wizards. Along the way, you've learned about APEX
items, session state, the APEX URL syntax, adding help to APEX pages, and incorporating upload and download
functionality by using the Declarative BLOBs feature. That's a lot to digest, but the APEX wizards have done most of
the work for you.
The common theme is that the APEX form and reports wizards are huge time-savers for developers, creating all
the objects—items, buttons, branches, processes, and so on—needed for a working form or report. You can then alter
the created objects to quickly customize the form or report to suit your needs.
Still, you haven't strayed far from what APEX builds for you, and you've covered only the simplest types of forms
and reports. The next chapter looks at more complex types of APEX forms and reports, also generated by wizards.
