> Is there a way of declaring a bind variable of date type?  I need it to pass
> into the call of a stored procedure.  I'm using Oracle 7.3.4.
>
> Thanks
>
> --
> Sonia Gillespie
> E-mail: [email protected]
>
>

The answer is "yes, depending on the client HOWEVER, you never actually
want to do that".

The Oracle date format is a 7 byte binary format and isn't easy to use
as is.  You would almost always fetch the date back to a client in
either a string format or in a number (as a julian date for example, or
converted to the number of seconds since some point in time -- 1/1/1970
for example).

You would then always use TO_CHAR() (or to_number(to_char())) on the
way OUT and TO_DATE() on the way in and bind either a STRING or a
NUMBER.

--
Thomas Kyte                              [email protected]
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html