[Zope-DB] DataType is broken at all for Zope? (Was: Oracle Date in DCOracle2's Stored Procedure)

[Bo M. Maryniuck]

Hi, Matt.

But what about much more important issue: passing Oracle DateTime type to=
 the=20
procedures? ;-) Is it only way to exec it via SQL statement?..

> >No. On "20030220" I have this error:
> >
> >=09ORA-01861: literal does not match format string
> >
> >On anything else (nuts, working with it like a puzzle game) I always g=
ot:
> >
> >=09ORA-01843: not a valid month
> >
> >I've made a little temporary tweak for DCOracle2.py (where your FIXME =
is
> > on 1491 line) to know what exactly types Zope passes for a procedure.=
 As
> > I see, there *is* OracleDate type passed, but still does not work. He=
re
> > is a full output:
> >
> >BEGIN :1 :=3D  PM.PM_08.INSERT_DAY_REPORT(:2,:3,:4,:5,:6,:7,:8); END;
> >with parameters (__repr__):
> >[<BindingArray object at 0x952e108>, OracleDate("2003-02-10 00:00:00")=
,
> > 844L, 'Descr', 1, 10, 'Comment', <BindingArray object at 0x938aff8>]
> >
> >args map:
> >["Val: <BindingArray object at 0x952e108>, Type: <type 'BindingArray'>=
}",
> >"Val: 2003-02-10 00:00:00, Type: <type 'OracleDate'>",
> >"Val: 844, Type: <type 'long int'>",
> >"Val: Descr, Type: <type 'string'>",
> >"Val: 1, Type: <type 'int'>",
> >"Val: 10, Type: <type 'int'>",
> >"Val: Comment, Type: <type 'string'>",
> >"Val: <BindingArray object at 0x938aff8>, Type: <type 'BindingArray'>"=
]
>

--=20
Regards, Bogdan

"When the grammar checker identifies an error,
it suggests a correction and can even makes
some changes for you."
=09=09-- Microsoft Word for Windows 2.0 User's Guide.