Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> passing VB date to Oracle stored procedure
This question has probably been asked before, but here I go again.
Imagine the following Oracle stored procedure:
PROCEDURE cv_lotsByNumOrEquip ( prm_equip_id IN lot.equip_id%TYPE, prm_start_date IN DATE);
Using OO4O (Oracle Objects 4 OLE), not RDO or ADO, how can a VB6 function successfully execute this procedure? I've attempted just about every format I can think of, but I always end up with the err msg
OIP-00005: Variable not in a valid date format
Any suggestions would be most welcome.
Thanks in advance,
Garrett
-- Posted via http://dbforums.comReceived on Wed Feb 12 2003 - 14:26:21 CST
![]() |
![]() |