Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Unanswered: Execute Immediate returning row count

    Can you retrieve the number of rows that were affected by a DML statement executed in an Execute Immediate clause?

    ie

    lv_sql := 'Update Table Set Column = Value Where Conditions';

    Execute Immediate lv_sql;

    -- Here I would like to be able to check the number of records affected.

    Any Ideas?

    Thanks,
    Tony

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

    Re: Execute Immediate returning row count

    Use SQL%ROWCOUNT:

    Execute Immediate lv_sql;
    If SQL%ROWCOUNT > 1 then
    ...

Posting Permissions

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