APEX

Hi,

I'm fairly sure this has been discussed before, but It'd be great to be able to programmatically access the htmldb_application.g_f01 item values. I'm designing a form-item generation system that will create all necessary elements from a master table anjd provide generalized front-end code to process these items. It significantly reduces development time for forms, except that the htmldb front end code is reduced to massive case or if-else statements to determine which item to access.

For example :

On a test page, with one report region as :

select htmldb_item.text(1, 'boo') from dual;

one submit button, and one after-submit process as :

declare
q varchar2(1024);
val varchar2(128);
begin
q := 'select htmldb_application.g_f01(1) from dual';
htp.p('q is ' || q);
execute immediate q into val;
end;

(in reality, the array index 1 will be a variable)

This will throw the following error upon page submission :

ORA-06553: PLS-221: 'G_F01' is not a procedure or is undefined

I recall the reasons for this have to do with values only accessible from local pl/sql code state, but it's really starting to kill me, and I'm running into the 4000 character limit for page processes. Does anyone have any suggestions?

Thanks much,

Matt