Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Create View Error Message (APEX 19.2)
Create View Error Message [message #678818] Thu, 16 January 2020 04:58 Go to next message
AdrianWard
Messages: 21
Registered: September 2019
Junior Member
Hi,

I'm trying to create a View in APEX that links to tables in APEX, tables in EBS (via DBLINK) and PL/SQL functions in EBS (via DBLINK). With this one view I am getting the following error: -

Unable to Create View
ORA-00942: table or view does not exist ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 592 ORA-02063: preceding line from XX_APEX_DBLINK ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 578 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2057


Now I know this refers to a table/view that does not exist and I believe I have created grants in EBS to everything however, is there any way I can find out WHAT LINE in the view I am trying to create, that the error occurs on?

Cheers
Adrian
Re: Create View Error Message [message #678836 is a reply to message #678818] Fri, 17 January 2020 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to go step-by-step? First create a view on only one table. If it succeeds, add another one. If it succeeds, add the third table, and so forth.

Once you get the error, investigate what's going on.
Re: Create View Error Message [message #678844 is a reply to message #678836] Fri, 17 January 2020 05:48 Go to previous messageGo to next message
AdrianWard
Messages: 21
Registered: September 2019
Junior Member
That is the exact process I have used on other issues however, this particular view is over 500 lines and contains embedded select etc. so is quite complex to break down.

I've actually found out what the error was (wrong schema prefix on a particular file) however I just wondered if APEX had an easier way to identify errored lines.

Clearly it doesn't Smile

Thanks for your response though.
Re: Create View Error Message [message #678875 is a reply to message #678844] Sat, 18 January 2020 07:04 Go to previous message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome. I'm glad you found the culprit.
Previous Topic: Restrict the status in Oracle Apex
Next Topic: Embedded PL/SQL Gateway EPG in DB 12.2
Goto Forum:
  


Current Time: Tue Sep 29 04:01:30 CDT 2020