Year format not taking in properly

[tharunkrishna16]

Hi SL Community,

I am facing a hiccup when I am trying to call a child pipeline which pulls data from Oracle database. The error happens in all the snaps where a SQL statement has year written in the form of parameter. The error I get is an Oracle error ORA-01841 : full year must be between -4713 and +9999, and not be 0. But the year is not zero in any of the parameters I have defined. But when I try to validate the child pipeline separately, it doesn’t throw any error. Please see the photos I have attached.

[akidave]

See SQL Injection question - #2 by tstack about how to format the dynamic SQL statements, that should help with the date formatting issue also