Re: LIKE operator, %, and bind variables
Posted by: Douglas Duvall
Date: August 10, 2011 02:47PM

I found the solution. I needed to set the length variable in the bin structure. Instead, I was giving it the address of the buffer_length variable. So what was happening was that "PATTERSON% " was being sent to the server instead of "PATTERSON%". The extra spaces after the % were messing things up. Even in Workbench, if you did this you won't get anything. Stupid error on my part.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: LIKE operator, %, and bind variables
3018
August 10, 2011 02:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.