I am using the OleDb provider for Oracle. 
The bind variable should be a question mark ? not :DEPTCODE

The bind variable :DEPTCODE would be valid for System.Data.OracleClient

See full walk through here: http://www.fullstackbusinessdesign.com/forums/ORA-01008.html

Many thanks to Prashant Kumar for this solution.
http://forums.asp.net/members/Prashant%20Kumar.aspx

Access/Pass variable between windows form and DataSet TableAdapter SQL where clause
I have a '99 Jetta TDI (diesel) with a cracked oil pan.  I'm looking for the sequence of tightening the bolts and the torque needed for each bolt.  I've been doing to google-fu but can't seem to find it. Does anyone specifically know these details, or where I can maybe find this?

Note: Can someone with priv please put 'oil-pan' and 'bolt-sequence' as tags :)
