Passing timestamp as parameter.

[kamalshil]

Hi All,
I am trying to pass timestamp value to Stored procedure.
But it is failing to execute the procedure.


I have an Input Parameter of Timestamp as type.
And mapped an input column of timestamp type.
And when i pass null value it is working fine.

I have tried with modifying the procedure with %type also but no success.

I am getting below error.

SP,0: Failure during execution of operator logic.
SP,0: Input 0 consumed 1 records.
SP,0: Output 0 produced 0 records.
SP,0: Fatal Error: Fatal: ORA-01843: not a valid month ORA-06512: at line 1
node_node0: operator [SP], partition 0 of 1, processID 2,072,726 on node0, player 4 terminated unexpectedly.
main_program: Unexpected exit status 1



Any suggestion for this?

[ray.wurlod]

Read the error message.

Not a valid month.

Are you passing YMD order when Oracle is expecting MDY or some other variant?

[kamalshil]

Yes i am passing in YMD.
I changed the project default.

But it will affect my other column format which i are used in some different jobs also.

So what best can be done can i change the timestamp format in transformer so it can be passed to SP in required oracle DMY format.

[ray.wurlod]

"Best"? Anything that works.

Just make sure that you're sending the format that the database server is expecting.

[chulett]

Pass it as a string in whatever format the proc is expecting.

[kamalshil]

Passed as string as the format expected by the database