>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 #
938436Re: Returning Value from Oracle SP to VFP Thread #
620820 Message #
621528
If it's not broken, fix it until it is.
My Blog