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

    Unanswered: Informix - procedure

    hi,

    I'm new in INFORMIX and i want to know wether Informix procedures are able to return a result set (a list of employees for example).

    if yes how it works ?

    I looked for this in some documentation but i didn't find any information about it.

    please if you can confirm me .

    thanks in advance,

  2. #2
    Join Date
    Jul 2002
    Posts
    1

    procedures are able to return a result set

    Hi,
    first , in procedure body, you must use
    CREATE PROCEDURE func_name (input_params)
    RETURNING output_params
    ...
    FOREACH
    ( put return value to output_params )
    RETURN output_params WITH RESUME
    ...
    END PROCEDURE

    then, Call the procedure use
    PREPARE ps FROM "EXECUTE PROCEDURE func_name (input_params)"
    DECLARE cur CURSOR FOR ps
    so, you can get the values of procedure's result set.

Posting Permissions

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