[syslog-ng] oracle db + syslog-ng integration

[vijay]

hi,

   Iam Using syslog-ng 3.0.4.when i used below configuration

    destination d_sql {
           sql(type(oracle) username("myusername") password("mypassword")
           database("LOGS")
           table("msgs_${R_YEAR}${R_MONTH}${R_DAY}")
           columns("datetime varchar(16)", "host varchar(32)",
"program varchar(32)", "pid varchar(8)", "message varchar2")
    values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY")
           indexes("datetime", "host", "program", "pid", "message"));
};

   iam facing error while starting service

   syntax error in /usr/local/etc/syslog-ng.conf at line 322.
   syslog-ng documentation:
http://www.balabit.com/support/documentation/?product=syslog-ng
   mailing list: https://lists.balabit.hu/mailman/listinfo/syslog-ng

the line 322 is----------  sql(type(oracle) username("myusername")
password("mypassword")


                                                     vijay.p