Hi All,
I have following questions about stored procedures in Ingres.
1. How can I get field names for the return row from row producing stored
procedure?
For example, lets say you have a stored procedure which returns multiple rows
with 'result row(...)' and 'return row(...)' statements.
Sample:
Create procedure rowproc ... as
... result row (char(10), varchar(50), char(3)) ...
begin
...
for
select userid, username, dept
into :a, :b, :c
from personnel
...
return row (:a, :b, :c);
endfor;
...
end;
My client is Visual Foxpro 8.0 (VFP) and I Ingres ODBC on Windows XP machine.
When I call this procedure from VFP-ODBC-Ingres, the resulting table fields (in
VFP) I get are as follows:
result_element0, result_element1, result_element2
Since, I refer to the result columns with their names, I would like the name of
the return fields to be userid, username, dept.
2. Is stored procedure parameter value case-sensitive? Can we change this
behavior through environment vars?
Thanks in advance.
Best Regards,
Javed Dalwai,
_______________________________________________
Users mailing list
Users@ingres.ca.com
http://ingres.ca.com/mailman/listinfo/users
