Inserting records into Oracle utilizing Oracle functions for some fields

[kettle_anonymous]

Is it possible to insert values as oracle functions? Some examples are:


sysdate
nvl
substr
something user defined



I thought about using javascript to concatenate a statement together but I think the insert action would actually enclose the result in quotes, which would defeat the purpose.






Any ideas?






Thanks,



John

[MattCasters]

>I thought about using javascript to concatenate a statement together
>but I think the insert action would actually enclose the result in quotes, which would defeat the purpose.

It would do what? :-)

Anyway, you can use the "Call DB Procedure" step: simply specify SYSDATE as function and the name of the return value. (SystemDate or something)

It's as simple as that.

Please note that you can also obtain Sysdate from "Get System Info" and NVL is in Calculator.

HTH,

Matt