Here's taking the nicer URLs one more step and I think I have 2 more that will follow next week. I have been doing with some testing with the Online Learning Library .

In case the screenshot is too small, the URL is

The URI Template is easy to follow and fairly portable.  I'm working on a generic way to do this in any app but here's the one we're using for this specific page.


Then the Apex Listener translates those things in  { }  into binds which can be used in this plsql block to run the F procedure and get a page out of Apex.

/* buffer to build up the value */
p varchar2(32767);


/* add in app,page, and session */

/* move along nothing to see here */
p:= p||'::::';

/* add in item names */
p:= p|| :item1;
if ( :item2 is not null ) Then
p:= p|| ','||:item2;
end if;

/* addin item values */
p:= p|| :item1v;

if ( :item2 is not null ) Then
p:= p|| ','||:item2v;
end if;



   I have to mention things could be rendered badly if anything is reading owa_util package to get assumptions from the URL.  One thing that I know didn't work for me was the use of apex_util.get_blob_file but that's easy to fix from yesterday's post.