Recent content by Chuck_mtc

  1. Chuck_mtc

    Select Into Raises NO_DATA_FOUND

    Yet More info .. The first Select was failing with a search value not really matching the table. The value, if checked at this Select, had no trailing spaces but in the table it had two. In the error handler, Test showed the same variable as having 2 trailing spaces. This is the value I was...
  2. Chuck_mtc

    Select Into Raises NO_DATA_FOUND

    More info.. Running the stored procedure from command line, it finds data in the first Select so skips the second one, getting the expected result. Strange..
  3. Chuck_mtc

    Select Into Raises NO_DATA_FOUND

    Both yesterday and today I have been testing a stored procedure that contains some : "Select myTb.Column Into MyVar From MyTb Where Column1 = Value1 And Column2 = Value2" Clauses. Two consecutive Selects (2nd is in the exception handler for the first, an effort to leave a more detailed error...
See more
Back
Top