APEX

Hello all :)

I've run into a bit of a problem...

I'm using the same kind of system as described by John Scott in 3 Seconds or Less.

So I call a URL like this...

/pls/apex/schema.apex_download_text

and it downloads the file, document, or whatever.

Works fine... except that it doesn't work at all when I include a select statement for the apex_application_page_regions table.

I need to get the SQL from a region in APEX, and this is stored in that table.

The same technique is used in Denes Kubicek's export to Excel procedures.

Except that's accessed usin APEX's URL structure, like this:
f?p=&APP_ID.:0:&SESSION.:DOWNLOAD_EXCEL:NO::T_REGION_ID,T_EXCE
L_NAME,T_PAGE:#REGION_ID#,my_report,&APP_PAGE_ID.

Can anyone tell me waht the problem is here?

Looks like the web call doesn't have access to the apex_application_page_regions table.

I can access the table even using TOAD / Plsql Dev, etc.

But whenever I put mention that table in the procedure, it just dies.

-EDIT-

256 posts :D

My post count now requires more than a single byte to store lol