Results 1 to 2 of 2

Thread: alter session

  1. #1
    Join Date
    Nov 2008

    Unanswered: alter session

    Hi Guys,

    Actually i need some advice here, i was debugging one procedure.
    But there was an error i was hitting where exception was raised because no data found.

    When i queried the table, there was no data.

    After trying many different options, i then altered session to american, then the procedure worked fine. And when i queried table after altering session, i could see data.

    alter session set nls_language = 'AMERICAN'

    Im just trying to understand, when do we actually have to alter session. and how do we know what session to alter to?

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    What was the statement that raised the NO DATA FOUND exception like? I suppose it contained the WHERE clause - which one? What data did you search for? Any "special" characters involved? What was the original NLS_LANGUAGE setting?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts