JDBC receiver issue -ORA-00917: missing comma

[Former Member]

Hello,

while sending data to Oracle DB through JDBC receiver, we got error like "ORA-00917: missing comma ". could you please let me know how to solve this issue.

If you r solution is- set " logSQLStatement". then can you please let me know how to set in receiver adapter(which tab)

Thanks in Advnace.

[Shabarish_Nair]

check the checkbox advanced mode

then use the add button (button with + on it) create a new line and provide the parameter name and value there

[Shabarish_Nair]

>

 logSQLStatement". then can you please let me know how to set in receiver adapter(which tab)
> 
> Thanks in Advnace.

advanced mode,

Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Ref: Note 801367 - XI 3.0 JDBC Adapter: Additional Parameters

[Former Member]

Hello Shabarish,

Thnaks for reply. i have gone through the Note and i amnot ableto find that options in JDBC receiver. please navigate with steps.

means will it be JDBCReceiver> advanced tab>advanced mode cehckbox.....or where can i insert that option ""logSQLStatement"