CODEWITHSUNDEEP
sqlinformix
user867621
user867621

Reputation: 1197

Informix stored procedure errors

I am trying to create a simple procedure that looks for a fname and lname when given a number

create procedure _lookup_name (_no int)
select (fname || ' ' || lname)  from table where number = _no;
end procedure;

I keep getting an error saying that "INTO TEMP table required for SELECT statement.

Upvotes: 1

Views: 885

Answers (2)

Rendon
Rendon

Reputation: 1

maybe :

define var1 char(30);
define var2 char(30);
create procedure _lookup_name (_no int)
    select (fname || ' ' || lname) into var1,var2 from table where number = _no;
end procedure;

Upvotes: 0

kentcdodds
kentcdodds

Reputation: 29021

You need to put the results of the select statement into a variable or table. See: w3schools (into table) or here temp table in memory

Upvotes: 1

Related Questions