I am passing a SQL statement to a function as a parameter and then
executing it via a call like
OPEN curs1 FOR EXECUTE sql_str;
Since I won't know in advance the fieldnames being passed by the SQL
string, I'd like to dereference the column fields by position. Can anybody
tell me the syntax for doing this? Doesn't seem to be much documentation
on dereferencing info returned by a cursor. I can fetch into either a
record variable or a row variable, whichever works.
TIA,
Mike
|