Hi experts. I'm working on a Ajax Cascading Select List Tabular using Denes Kubicek's example. When I run it, I keep getting this error:
"report error:
ORA-06550: line 1, column 139:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 13:
PL/SQL: SQL Statement ignored"
I checked and all the tables are fine. I wonder if any expert could help me with this. I have included the query for your reference. Thank you and I greatly appreciate your help.
SELECT apex_item.checkbox (30,
seq_id,
'onclick="highlight_row(this,' || seq_id || ')"',
NULL,
':',
'f30_' || LPAD (seq_id, 4, '0')
) delete_checkbox,
apex_item.hidden (31, seq_id)
|| apex_item.select_list_from_query
(32,
c001,
'SELECT resource_name d, resource_onepass_ID r FROM resources'
|| 'RIGHT JOIN super_admin ON resources.resource_onepass_ID = super_admin.super_admin_onepass',
'style="width:220px" '
|| 'onchange="f_set_casc_sel_list_item(this,'
|| 'f33_'
|| LPAD (seq_id, 4, '0')
|| ')"',
'YES',
'0',
'- Select Resources -',
'f32_' || LPAD (seq_id, 4, '0'),
NULL,
'NO'
) resources,
apex_item.select_list_from_query
(33,
c002,
'SELECT super_admin_onepass d, super_admin_ID r FROM super_admin '
|| 'WHERE super_admin_onepass = '
|| c001,
'style = "width:220px"',
'YES',
'0',
'- Select OnePass ID -',
'f33_' || LPAD (seq_id, 4, '0'),
NULL,
'NO'
) OnePassID
FROM apex_collections
WHERE collection_name = 'DEPT_EMP'
UNION ALL
SELECT apex_item.checkbox
(30,
NULL,
'onclick="highlight_row(this,'
|| TO_NUMBER (9900 + LEVEL)
|| ')"',
NULL,
':',
'f30_' || LPAD (9900 + LEVEL, 4, '0')
) delete_checkbox,
apex_item.hidden (31, NULL)
|| apex_item.select_list_from_query
(32,
0,
'SELECT resource_name d, resource_onepass_ID r FROM resources'
|| 'RIGHT JOIN super_admin ON resources.resource_onepass_ID = super_admin.super_admin_onepass',
'style="width:220px" '
|| 'onchange="f_set_casc_sel_list_item(this,'
|| 'f33_'
|| LPAD (9900 + LEVEL, 4, '0')
|| ')"',
'YES',
'0',
'- Select Resources -',
'f32_' || LPAD (9900 + LEVEL, 4, '0'),
NULL,
'NO'
) resources,
apex_item.select_list_from_query
(33,
NULL,
'SELECT super_admin_onepass d, super_admin_ID r FROM super_admin '
|| 'WHERE super_admin_onepass = '
|| 0,
'style = "width:220px"',
'YES',
'0',
'- Select OnePass ID -',
'f33_'
|| LPAD (9900 + LEVEL, 4, '0'),
NULL,
'NO'
) OnePassID
FROM DUAL
WHERE :request = 'ADD'
CONNECT BY LEVEL = 2