You can write
INSERT INTO REF_USER_ROLE_XRE
SELECT Param1, Param2, Param1,
(select to_char(sysdate, 'DD-MON-YY') from dual)
FROM
(SELECT ? AS Param1, ? AS Param2) params
mdma
2010-05-27 22:59:55
+1
A:
Exactly what I was looking for. Thanks a lot.
Chris Lieb
2010-05-28 12:59:08