Wednesday, November 30, 2005

Parameterized queries against Oracle...Again!

So here is round 2...

You can also do a parameterized query against Oracle Execute SQL Task. Here is the scoop:

  1. Make sure you are using the Microsoft Driver for OLE should be using this all the time except for one place...we'll talk about that later.
  2. Create your query, and use ?'s for where your parameters go.
  3. Map the parameters on the Parameters option tab. Make sure that you get the datatypes correct and that Oracle will often expect DB_Decimal for most numbers.
And off you go!



Post a Comment

<< Home