D'Arcy from Winnipeg
Solution Architecture, Business & Entrepreneurship, Microsoft, and Adoption

Saving to an Oracle Blob field using DAAB

Monday, August 20, 2007 4:55 AM

Been working on a file-upload feature on my current web app project, with the catches being

1) We're saving the file to an Oracle BLOB field
2) We're using the Data Access Application Block

If this was using the Microsoft or Oracle data providers, we'd be able to specify Blob as the parameter type being passed into the stored proc...but we can't with the built in type list.

The way around this is to specify the datatype as DBType.Binary and pass in a byte array representing the file.



No comments posted yet.

Post a comment