Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: Exception for stored procedure

    hi all, if my stored procedure is returning more than 1 record.. how should i increase my fetch?

    Exception
    When too_many_rows then
    ????---> what should I put?
    end;

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Exception for stored procedure

    Originally posted by cheers
    hi all, if my stored procedure is returning more than 1 record.. how should i increase my fetch?

    Exception
    When too_many_rows then
    ????---> what should I put?
    end;
    TOO_MANY_ROWS is raised when you use SELECT...INTO and it returns more than 1 row. SELECT...INTO should only be used where 1 row is expected. If you want to return more than one row you would normally use a cursor. Or you could use BULK COLLECT INTO with PL/SQL tables to get multiple rows.

Posting Permissions

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