Hi
When I use an Oracle OCI stage the job runs fine but when using ODBC stage with write option I get an error
Can somebody suggest me what is this error APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle driver]Invalid precision value. Error in parameter 5.
Thanks
Arif
ODBC error
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It means the fifth parameter marker in the SQL. If this is Oracle SQL, the fifth parameter marker is :5 but, if this is ODBC SQL, the fifth parameter marker is ? (as are all the other parameter markers).
Is the column in the Oracle table defined as VARCHAR2(50)? That is, does the metadata in your job match what's really out there in the table. Does the schema for that link specify string[max=50] for that field?
Once everything matches perfectly you should not see any warnings.
Is the column in the Oracle table defined as VARCHAR2(50)? That is, does the metadata in your job match what's really out there in the table. Does the schema for that link specify string[max=50] for that field?
Once everything matches perfectly you should not see any warnings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.