Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Function Calling In View
hi all,
I have sql script which connect two databases and create views on local database which select data from remote database. All data is on the remote databse. Beside selecting data , some user-defined functions (which also make decisions on the basis of remote database tables) are also being called in select statements. DBMS_SQL package is used to create views on the local side.
"The script works fine on oracle 8i , but it gives following error on the oracle 7.3 "
SETDISTANCEUOM('newlink'), NULL, fh.record_changed
*
ERROR at line 23:
ORA-06571: Function SETDISTANCEUOM does not guarantee not to update database
Since function call fails , view is not created on the local database.
Any ideas ,Suggestions Please Help.
Azhar