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