Hi,
I have to create a hierarchical list of values over 3 levels
1. Level: (called P13_STUFE_1)
select loc d,deptno r
from dept
order by 1
2. Level (called P13_STUFE_2)
select column_name d,column_name r from user_tab_columns
where table_name='EMP'
cascading LOV parent Item P13_STUFE_1
Page Items to submit P13_STUFE_1
3. Level (called P13_STUFE_3)
Depending on the results of LOV 1 and LOV 2 there should be a LOV shwing the content of the selected column and department like
P13_STUFE1 = 10
P13_STUFE_2 = ENAME
P13_STUFE_3 =
CLARK
KING
MILLER
RETURN 'select nvl('||:P13_STUFE_2||',job) d,nvl('||:P13_STUFE_2||',job) r from emp WHERE deptno=nvl('''||:P13_STUFE_1||''',deptno)';
cascading LOV parent Item P13_STUFE_2
Page Items to submit
Result:
http://localhost:8080/apex/f?p=101:13:9704449646773:::::
Error during rendering of page item P13_STUFE_3. ORA-06550: line 1, column 24: PL/SQL: ORA-00936: missing expression ORA-00936: missing expression ORA-06550: line 1, column 13: PL/SQL: SQL Statement ignored ORA-00936: missing expression
Technical Info (only visible for developers)
- is_internal_error: true
- apex_error_code: WWV_FLOW_FORM.UNHANDLED_ERROR
- ora_sqlcode: -6550
- ora_sqlerrm: ORA-06550: line 1, column 24: PL/SQL: ORA-00936: missing expression ORA-00936: missing expression ORA-06550: line 1, column 13: PL/SQL: SQL Statement ignored ORA-00936: missing expression
- component.type: APEX_APPLICATION_PAGE_ITEMS
- component.id: 2521712617507612
- component.name: P13_STUFE_3
- error_backtrace: ORA-06512: at "SYS.DBMS_SYS_SQL", line 1325 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1022 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 1246 ORA-06512: at "APEX_040200.WWV_FLOW_NATIVE_ITEM", line 1741 ORA-06512: at "APEX_040200.WWV_FLOW_NATIVE_ITEM", line 4242 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1251 ORA-06512: at "APEX_040200.WWV_FLOW_FORMS", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_FORMS", line 1428
Please help me to filnd the error
Regards
Siegwin