> 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