Dear all,

Hope you are fine and doing well.
I am trying to use oracle 10g as backend while VFP9 as frontend.

i have created oracle package having one procedure who returns
all the records in the table.it does well. now i want to limit
records to be return by parameters.following is the detail of
package and vfp code i am using.

******************************** Oracle Package ***************
create or replace package allusers_pkg as
Type curtyp is REF cursor return allusers%rowtype;
Procedure alluser (uname IN Varchar,c1 IN OUT curtyp);
End allusers_pkg;

create or replace package body allusers_pkg as
Procedure alluser (uname IN Varchar,c1 IN OUT curtyp)
is
Begin
Open c1 for
Select *from allusers where user_name=uname;
end;
End allusers_pkg;
************** end package ********************

************* vfp codes ******************
uname="abdulaqeel"
IF SQLEXEC(nconsql,"{call allusers_pkg.alluser(@uname)}","allusers")>0
SELECT allusers
BROWSE
endif
*************** End vfp code ***********************

here connection is ok.

above said does not return any value and returns error.

can some one guide me in detail what's the problem in above codes?

Regards,
Abdul Aqeel