[Dbix-class] Oracle Built-In Functions

[Duncan Garland]

Hi,

I'm struggling to persuade DBIx::Class to use simple Oracle built-ins such as SYSDATE, DECODE and NVL.

Eg UPDATE table1 SET date_updated = SYSDATE, destination = NVL( $destination, 'home' ) WHERE ... ;

$rs->date_updated( 'SYSDATE' );

Doesn't work, nor can any variation on a theme that I can think of.

I'm sure it must be possible and I'm sure it must be in the docs, but I can't find it.

Can anybody help?

Regards

Duncan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100804/8223ed54/attachment.htm