Re: using SELECT to call a STORED PROCEDURE

A stored procedure that returns a single value will be treated as a virtual function and can be used in select statements. However, when it returns more than one value, it is not a function anymore and you can use only functions in select statements. I believe Universal server has a method that can solve this problem, if you can justify the cost :-) Arun benhen@my-dejanews.com wrote: > Hi there, > > I use Informix online 7.24 > I want to call a store procedure with 'SELECT'. > (I don't want to use 'execute procedure' or 'call') > > I've try this statement : > > select proc_name(param) from dummy_table_with_one_row; > > When the procedure returns ONE value, it works fine, but when > the procedure returns more than one value, I receive the message : > > '684: Procedure (informix.proc_name) returns too many values.' > > As I'm not a SQL guru, I ask if someone could help me to resolve this > problem (any idea or workaround is welcome). > > Thanks already, > > Ben. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum