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

Home -> Community -> Usenet -> c.d.o.server -> Passing date value from VB to Oracle Stored Procedure

Passing date value from VB to Oracle Stored Procedure

From: Melinda Schall <no.one_at_daytonoh.ncr.com>
Date: 1998/03/24
Message-ID: <01bd5740$f78bce20$d7541995@aohemd4-schalm.DaytonOH.NCR.COM>#1/1

Our developers are trying to pass a date value from VB to an Oracle Stored Procedure and it is not working. The stored procedure's input parameter is defined as DATE. The VB code wants to pass the date format of MM/DD/YYYY. I've tried having them pass the value as a string containing the to_date function, i.e. to_date(vb_date, 'MM/DD/YYYY'), to the stored procedure but this fails as well. It seems like there must be a simple/obvious thing wrong...but it's eluding me and the other database developers here.

Thanks in advance for any information. Received on Tue Mar 24 1998 - 00:00:00 CST

Original text of this message

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