Stored Procedure stage cuts the time part from Date paramete
Posted: Sun Oct 30, 2011 6:49 pm
I have a stored procedure (Oracle) that has a DATE input parameter. The parameter represents the last process time and it must contain both date and time.
I'm using STP stage to call this stored procedure and have a problem with passing full date and time portions.
When I pass a Date (26,6) field to it, Datastage seems to be truncating the time part and SP executes as if only the date was passed as a parameter (which is wrong).
If I pass Timestamp field then I get the error:
As a workaround, I could create another Oracle SP that will take a VARCHAR2 parameter (and possible a date/time format), that would convert the string to date and then call my existing SP. Then I could just call it with a VarChar parameter and problem solved.
However, I would prefer though to this issue inside Datastage rather than creating any stubs in Oracle. Is there any way to achieve this?
I'm using STP stage to call this stored procedure and have a problem with passing full date and time portions.
When I pass a Date (26,6) field to it, Datastage seems to be truncating the time part and SP executes as if only the date was passed as a parameter (which is wrong).
If I pass Timestamp field then I get the error:
Code: Select all
ORA-01861: literal does not match format string ORA-06512: at line 1
However, I would prefer though to this issue inside Datastage rather than creating any stubs in Oracle. Is there any way to achieve this?