OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Create View Error Message (APEX 19.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create View Error Message [message #678818]

Thu, 16 January 2020 04:58

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

Report message to a moderator

Re: Create View Error Message [message #678836 is a reply to message #678818]

Fri, 17 January 2020 01:40

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Create View Error Message [message #678844 is a reply to message #678836]

Fri, 17 January 2020 05:48

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.

Report message to a moderator

Re: Create View Error Message [message #678875 is a reply to message #678844]

Sat, 18 January 2020 07:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You're welcome. I'm glad you found the culprit.

Report message to a moderator

Previous Topic:	Restrict the status in Oracle Apex
Next Topic:	Embedded PL/SQL Gateway EPG in DB 12.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:04:35 CST 2024