Dear Exprets,

I am trying to convert my account software from vfp/sql server 2000 to
vfp/Oracle 10g express edition.

I have created database on backend (oracle 10g express) and successfully
connected to it. I sucessfully call the procedure from front end VFP 9.

same way I created a function on oracle 10g express but unable to successfully
call it from front end VFP 9. I am using the same as I use to call store Procedure.

I have created following fuciton and connect through ODBC.

create or replace function get_maincode(ac IN Varchar2,mt IN OUT Varchar2)
return Varchar2 is
begin
select main_title into mt from chart
where acc_code=ac;
return mt;
end;

I call this function from vfp as below.
sqlexec=consql,"(call get_maincode (?ac,?@mt)}"

if I create procedure than it run successfully but not as function.

function created successfully on oracle end.

any tip??

Regards,
Abdul Aqeel