Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> passing VB date to Oracle stored procedure

passing VB date to Oracle stored procedure

From: garrettmr <member24852_at_dbforums.com>
Date: Wed, 12 Feb 2003 20:26:21 +0000
Message-ID: <2520773.1045081581@dbforums.com>

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.com
Received on Wed Feb 12 2003 - 14:26:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US