I am facing a serious problem. As you know in Oracle 8.0.6, we can not use an Inline function (Which contains only select statement),whicj gives the error as "Can Not Read/Update the database", so I have declared PRAGMA RESTRICT_REFERENCES(func_name,WNDS). Now this works fine from a Select Statement.

But the problem is whenever I am trying to execute the statement from ODP. NET(Lets say from C# .NET environment), it gives the error as "You can not use WNDS only. You have to use WNPS, RNPS as well". But the problem is I can n ot use WNPS inside my package as I am altering the Package Variable there. So what can be the possible solutions??

Can anybody please help me out??

Thanks in advance