Dynamic PL/SQL Content [message #198399] |
Tue, 17 October 2006 01:17 |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
Does anyone know of a useful resource to learn how to use DYNAMIC PL/SQL CONTENT regions and APEX_... APIs?
I've been mucking about with the point-and-click bits of Application Express (HTML/DB) and want to take the next step.
I create a Dynamic PL/SQL Content region, which offers a dialog box to enter PL/SQL code. But what do I put in there? Presumably I use the APIs such as APEX_ITEM to generate forms controls and content, but how is that content then returned and rendered (not with a PL/SQL function RETURN clause - I tried...
The APEX documentation covers the syntax of all of the APIs, but does not tell you how to build dynamic content with them. It's also stonily silent on how to use the PL/SQL Dynamic Content regions.
Is there another resource - a differnt manual - that tells us how to do this?
Ross Leishman
Update: Found this. Any others?
Another Update: Seems like we use the HTP and HTF packages, but according to the Application Developers Guide:
Quote: | Documentation for these packages is not part of the database documentation library. The location of the documentation depends on the particular application server you are running. To get started with these packages, look at their procedure names and parameters using the SQL*Plus DESCRIBE command:
DESCRIBE HTP;
DESCRIBE HTF;
DESCRIBE OWA_UTIL;
| So it looks like thats what I'll be doing. Any other source of info would be nice though ...
[Updated on: Tue, 17 October 2006 22:28] Report message to a moderator
|
|
|
|
|