I am using Oracle Apex in cloud. Why I sometimes get error for Report with form for a simple table? The table has only primary key and only two other controls. Data can be updated and created normally in SQL workshop - Object Browser, but when I run application and simple Report with Form Page that has a source this table, the error occurred in Create/Update Form. I have another simple tables, and everything works for them as expected. I have only generated this form via Create Page wizard and did not change anything else.
Details of error:
Table structure copied from SQL tab in Object Browser:
CREATE TABLE "VZ3_ZAPOSLENIK"
( "ID_ZAPOSLENIKA" NUMBER,
"IME_I_PREZIME" VARCHAR2(30),
"KONTAKT_TELEFON" VARCHAR2(20),
CONSTRAINT "VZ3_ZAPOSLENIK_PK" PRIMARY KEY ("ID_ZAPOSLENIKA")
USING INDEX ENABLE
)
Error when I fill all the values in Create Form and click on Create button:
1 error has occurred
- Invalid query type. Query type must be Table, SQL query or PL/SQL Function returning SQL Query.
Error when I click on Edit button near any of records(rows) in the Report Page:
ORA-00903: invalid table name
Contact your application administrator. Details about this incident are available via debug id "872437200".
Technical Info (only visible for developers)
- is_internal_error: false
- ora_sqlcode: -903
- ora_sqlerrm: ORA-00903: invalid table name ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2176 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 788 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC", line 1628 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2049 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2218 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS_NATIVE", line 1241 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2473
- component.type: APEX_APPLICATION_PAGE_PROCESS
- component.id: 12552565907312432300
- component.name: Initialize form Zaposlenik
- association_type: REGION
- region_id: 12552558475959432278
- error_backtrace:
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2176 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 788 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC", line 1628 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2049 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2218 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS_NATIVE", line 1241 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2473 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS", line 203
- error_statement:
select i.* from ( select "ID_ZAPOSLENIKA","IME_I_PREZIME","KONTAKT_TELEFON" from (( select /*+ qb_name(apex$inner) */d."ID_ZAPOSLENIKA",d."IME_I_PREZIME",d."KONTAKT_TELEFON" from ( ) d )) i ) i where 1=1 and "ID_ZAPOSLENIKA"=:apex$f1
Best regards, Darko