>I've got an assignment which requires calling a stored procedure on an Oracle database. I've never done this before and could use a little (ok....a lot) of help on the syntax.
>
>I was given the following information:
>
>Procedure name is sp_getDebitCardInfoForRepl(p_date varchar2, p_data out sys_refcursor) in ach@castst01
>
>I've got a Date variable --- dInpDate = {01/22/2007}
>
>How do I format the SQLEXEC statement?
>
>Thanks to all...........Rich

See if this can be of any help
Re: Passing Dates to Packages. Thread #938423 Message #938436
Re: Returning Value from Oracle SP to VFP Thread #620820 Message #621528