ORA-01762: vopdrv: view query block not in FROM

ORA-01762: vopdrv: view query block not in FROM

01762. 00000 - "vopdrv: view query block not in FROM"

*Cause:

*Action:

Error at Line: 29 Column: 18

 

Answer:: Relace join with simple muti-join table query , see below e.g.

 

WITH

NewsT AS ( SELECT P.related_id ID

FROM Profiling P
JOIN Account A

ON A.ID = P.account_id

WHERE P.profiling_type = 1

AND P.related_type = 3

AND A.ID = 6 )

 Select * FROM NewsT;

Replace Join:

WITH

NewsT AS ( SELECT P.related_id ID

FROM Profiling P , Account A

Where A.ID = P.account_id

AND P.profiling_type = 1

AND P.related_type = 3

AND A.ID = 6 )

 Select * FROM NewsT;

Great, it works !