Page 1 of 1
Posted: Thu Jan 16, 2003 7:19 am
by WoMaWil
There are some rules, how to do it and it will work. Wheter you read the manual or tell us your command, so that we can help you.
Wolfgang
Posted: Thu Jan 16, 2003 7:57 am
by chulett
Basic rule you seem to be running afoul of is to have the same number of bound variables as columns in the stage. For example, for six columns referenced in the stage you must include :1 thru :6 in the custom sql.
-craig
Posted: Thu Jan 16, 2003 11:40 am
by badhri
You have 59 columns in the query and you have reference ionly from :1 to :58. I guess you are missing on column.
Badhri ..
Posted: Wed Jan 22, 2003 9:26 am
by cthuga
I got the same problem when I wanted to use Oracle's sequences.
You must not define the column that will contain the values of the sequence in the column definition. just put it in User-Defined SQL, and It will work.