> > Abdul,
> > You are correctly calling with 'call'.
> > I don't use Oracle but in SQL server when it is a function I need to include owning schema like dbo.MyFunction as opposed to MySp. Might that be something like that in Oracle? When it fails check what aerror() is returning (and preferably first try from Oracle's tool -whatever it is- if it is working).
> >
> > Cetin Basoz
> >
> >
My Blog (main)> >
My Blog (mirror)>
>
> you are right dear it works in Sql server as you said above.
> if you people simple look at the function you shall find that
> i have just inserted a value from a table into a variable called
> mt. function complied successfully in oracle so there is no problem
> on that side. it is being called by passing parameters and it should
> return back a value as any procedure does. if i write the same and get
> the result from procedure than it works fine. I just want to know is there
> any change of command to call function???
>
> any detailed answer will be welcomed.
>
> Regards,
> Abdul Aqeel
"it is being called by passing parameters and it should return back a value as any procedure does".
Does any procedure really return a value? Maybe it does in Oracle.
Actually your procedure looked awkward but since I don't have oracle preferred to accept it is working that way.
Maybe this helps.
http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/fb91a409-6c1d-4928-98fa-8da2b778cf8bCetin Basoz
.Net has got better.Think about moving - check my blog:
Blog (main)Blog (mirror)