JDBC Step integration hub

[maryc]

I am trying to connect to Oracle DB to unlock use account and my query is 

 alter user <UserID>  account unlock

I am trying to Sanitize the userid value , but it is appending single quotes to the userid value. 

How do I remove the single quote and pass it as a plane string with no single or double quotes?

[RaghavSh]

what is the error if you pass it without quotes. I dont think it will allow you to test the JDBC step without sanitising.

If you pass the value dynamically from inputs, then single quote is not required.

[maryc]

I am getting error saying "Given SQLis not allowed to be executed at this time"

The query is going as 

Alter user 'ABC'  account unlock

Instead Of

Alter user ABC  account unlock

ABC is coming from the input step as a String