Skip to Main Content

hierarchical list of values - 3 levels

siegwin.portNov 9 2013 — edited Nov 9 2013

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

Comments
Post Details
Added on Nov 9 2013
1 comment
416 views