Bug in OCI Stage ???

WoMaWil · Post by **WoMaWil** » Thu Jan 16, 2003 7:19 am

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

chulett · Post by **chulett** » Thu Jan 16, 2003 7:57 am

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

badhri · Post by **badhri** » Thu Jan 16, 2003 11:40 am

You have 59 columns in the query and you have reference ionly from :1 to :58. I guess you are missing on column.

Badhri ..

cthuga · Post by **cthuga** » Wed Jan 22, 2003 9:26 am

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.