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

    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;
    /

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

    Thanks alot for the help

    Melvine
    Last edited by Melvine; 12-28-05 at 08: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
  •