Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Question Unanswered: Stored Procedures, please

    I'm very new in informix, and I want to know if I can have output parameters in a stored procedure like:

    CREATE PROCEDURE TEST (A INT , B INT OUT)

    thanks,

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    One can have both inbound and outbound parameters for a Stored Procedure.

    Example:
    create procedure test (a int) returning int;

    You may look at the link below, which points to an official documentation on informix spl in pdf format. The title of the e-book is Informix Guide to SQL and the 8th chapter deals with creating and Using Stored Procedures.

    http://www-3.ibm.com/software/data/i.../4366-pdf.html

    Regards,
    Shriyan

Posting Permissions

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