Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003

    Unanswered: Does DB2 stored procedure support CURSOR type?

    In Oracle stored procedure we can use a user defined cursor type as parameter type, for example:

    create or replace package ENTITYSP as
    type ob_rec IS REF CURSOR;
    PROCEDURE ENTITYSP(ob_output out ob_rec);
    end ENTITYSP;

    Does DB2 stored procedure also support this kind of cursor type as parameter type?

    Thanks alot for the help

    Last edited by Melvine; 12-28-05 at 07:16.

Posting Permissions

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