Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02070: database does not support operator PLSFUN in this context
ORA-02070: database does not support operator PLSFUN in this context [message #272917] Mon, 08 October 2007 03:19 Go to next message
cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA
Junior Member

Can anyone tell me how to solve this issue?

http://www.lslnet.com/linux/edosc/49/linux-49333299.htm

Basically my problem is i can't put calling function and user defined type's field inside a materialized view. Thanks..
Re: ORA-02070: database does not support operator PLSFUN in this context [message #272919 is a reply to message #272917] Mon, 08 October 2007 03:26 Go to previous message
cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA
Junior Member

It's under a database, no database link.

----------
create materialized view lot_view refresh complete start with sysdate next sysdate+1/4096 with rowid for update as
select GEOLOC, TO_DISPLAY_UNIT(A_AREA) from lot;
-----------

GEOLOC is user defined type's field, TO_DISPLAY_UNIT is a function.
Previous Topic: How to fetch % symbol using like operator
Next Topic: a procedure taking long time while running it
Goto Forum:
  


Current Time: Sun Dec 04 13:06:47 CST 2016

Total time taken to generate the page: 0.08246 seconds