Hi, I am trying to pull data from an Oracle table using a Select query with a Where clause. When the Where clause contains 4 or less characters, it works fine. When I try something with more that 4, it won't pull anything. I have verified the data is actually in the table, and have tried hardcoded the criteria with no success. Any suggestions? thanks!

VB Code:
  1. Dim objcommand As New OracleCommand("SELECT * FROM APP_SECURITY WHERE APP_SECURITY.USER_NAME = 'test1'", objConnection)