I have a procedure for calculating a new column in tables.I want to use  loop for number of columns repeating with same values.

So I just tried with one variable to store  count of columns and then i used that table type count variable as a conditional variable in while loop.Now i got the error

Feature not supported: table variable cannot be compared.

Can anyone help me to resolve the error.

FIDCOUNT=select count(distinct FAMILY_ID) from family;

WHILE :outloop_count<:FIDCOUNT DO

//query

outloop_count:=:outloop_count+1;

END WHILE;

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply