Parsing error on Materialized View with "WITH" clause

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Parsing error on Materialized View with "WITH" clause

Postby skoffer » Wed Sep 11, 2013 4:49 pm

Version 3.0.0.719

My view is like

CREATE MATERIALIZED VIEW smmry_cross_tab_equity_10
BUILD DEFERRED
REFRESH COMPLETE
AS WITH ba AS
(SELECT
rds_employee_id
,pcr_team_id
....

When trying to schema compare it I get the following error:
Parsing failed with message SyntaxError. Unexpected token 'AS'(Line 4, Col1) Sumbol Id.
skoffer
 
Posts: 1
Joined: Wed Sep 11, 2013 4:44 pm

Re: Parsing error on Materialized View with "WITH" clause

Postby neil.anderson » Fri Sep 13, 2013 1:49 pm

[quote="skoffer"]Version 3.0.0.719

My view is like

CREATE MATERIALIZED VIEW smmry_cross_tab_equity_10
BUILD DEFERRED
REFRESH COMPLETE
AS WITH ba AS
(SELECT
rds_employee_id
,pcr_team_id
....

When trying to schema compare it I get the following error:
Parsing failed with message SyntaxError. Unexpected token 'AS'(Line 4, Col1) Sumbol Id.[/quote]

Hi thanks for this. I've been able to recreate so I'll have a fix for you soon.
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby neil.anderson » Mon Sep 16, 2013 11:09 am

Hi,

I believe this has been fixed. You can try the latest builds of Schema Compare and Source Control here:

http://download.red-gate.com/EAP/Source ... .0.100.exe

http://download.red-gate.com/EAP/Schema ... .0.737.exe

Please let me know if the problem persists.

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests