Naming return values in Stored Procedures

[TimMcOwan]

Hi All,

I'm new to stored procedures in Informix, but I've written one that does the job I need it to do...except one thing.

When the stored proc returns values, it doesn't assign a name to the values it returns. The stored proc I'm talking about returns multiple values (for the purposes of this thread, lets just say they're "CustomerID" and "OrderID") and, when I run it in dbaccess, it just outputs:

(expression) ABBE03
(expression) 928378

I need to somehow label the return values so that it will show

CustomerID ABBE03
OrderID 928378

Please help folks, I'm nearly there!

 

[olded]

Unfortunately, Informix stored procedure return values are returned ordinally and not by name. You just have to know that expression 1 is the customerid, and expression 2 is the orderid.

I wish there was a ready solution, but I don't know of one. If you find a solution, I'd be interested in knowing about it.

Regards,

Ed

 

[mberni]

Hi there!

You do not say which Informix-Version you are using, but in my current environment (9.40UC2X3) there IS a solution for that.

The code would look like this:

create procedure myproc()
returning integer [b]as CustomerID[/b], 
          integer [b]as OrderID[/b]

return 1000,100;

end procedure;