Archives of the TeradataForum
Message Posted: Fri, 27 Apr 2001 @ 16:10:20 GMT
I am not sure what you mean by "refers to more than one local variable." But, the cursor should only be used to qualify the name of a column named in the SELECT.
You should be able to do something like the following within your FOR / END FOR loop that defines the cursor:
/* MyCursor_name established in the FOR statement */
as well as:
INSERT into my_other_table values (Mycursor.column_name2, Mycursor.column_name1);
I hope this helps. Otherwise, you might want to post that portion of your procedure.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|