Aria People Search - I had this package run successfully once before...deinstall and week later re-install...now i get the below error messages.
Any ideas....
Platform - Oracle 10g XE apex 3.0 - Linux
---------------------------------------------------------------------------------
ORA-06550: line 4, column 36: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 4, column 11: PL/SQL: SQL Statement ignored ORA-06550: line 7, column 27: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 7, column 5: PL/SQL: Statement ignored
Debug:
1: begin
2: begin
3:
4: htp.p('<center>');
5: for c1 in (select message_text from aria_messages
6: where message_current = 'Y')
7: loop
8: htp.p(dbms_lob.substr(c1.message_text,8000,1));
9: end loop;
10: htp.p('</center>');
11:
12: if wwv_flow.g_flow_step_id not in (17,8,15) then
13: htp.prn('<div style="text-align:center;">
Edit my information</div>');
14: end if;
15: end;
16: end;