logSQLStatement with Stored procedures

[Former Member]

Hi,

I used JDBC adapter parameter logSQLStatement for a sql query. I was able to see the SQL statement that gets gets executed in the database.

However when I tried using logSQLStatement for a stored procedure it just logged the name of the stored procedure without showing the parameter values that are being passed into the database.

Any clues why??

Thanks,

Sathya

[Shabarish_Nair · Accepted solution]

logSQLStatement with Stored procedures will not give you any result. It is only useful for statements other than stored procedures

[dharamveer_gaur2]

Hi

For JDBC receiver we create structue in query format. but in case stored procedure we not generate SQL query through structre, we pass parameter.