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)