>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
I have no idea, but better specify your dates as {^2007/01/22}, since this variation is unambiguous - not dependent on the date format. Your application might eventually be used outside the U.S., where the preferred date format might be DMY, MDY, or YMD.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)