ora-00976: specified pseudocolumn or operator not allowed here - (11g)
AAGOct 12 2012 — edited Oct 24 2012This ora error occurs on one of my Testing Environment.
ora-00976: specified pseudocolumn or operator not allowed here
This happens in one of the plsql pkg which has no compilation errors. and works perfectly fine in other environments.
THe only difference i noticed is this error happening in DB which is 11g - 11.2.0.3
and other environments which are in good shape is 10g - 10.2.0.5
In the whole of the function where error is pointing , there is one thing which i am suspecting ( but not sure)
i.e CONNECT BY LEVEL , is used in one of the queries. Could this be a problem in 11g ?
If not, any help / guidance in troubleshooting this will be greatly appreciated. !
-Thanks,