Re: [Sqlrelay-discussion] Oracle procedure with date parameter - how to bind?

[David M. <dav...@fi...>]

Hey Maciej,

For now, that's what you have to do.  It would be nice to be able to
bind a date object.  Most languages have some kind of date class.  I'll
add it to the TODO list and see what I can do.

Dave

On Tue, 2006-02-07 at 09:47 +0100, Maciej Wisniowski wrote:
> Hi
> 
> I wonder how should I bind to oracle procedure which has DATE parameter.
> 
> Suppose this is OUT parameter, then, in Python API, I have only:
> defineOutputBindInt
> defineOutputBindDouble
> defineOutputBindString
> 
> what should I do with date?
> 
> Now I simply write:
> begin
>     :func_ret:=BLA_PROC(to_date(:A_DATA_X,'YYYY-MM-DD'), :A_OPIS);
> end;
> 
> and I bind to string A_DATA. Is this a correct way?
>