I am using ADO.NET and the OracleClient class to call Oracle 9i stored procedures. Unfortunately there seems to be a limit to the size of a parameter you can pass in. This seems to be 32K !!!
I am working with blob objects, and have used the code in the following article to pass a blob object into a stored procedure (i.e. to add an image to a table):-
However if the parameter you pass in is > 32k, Oracle gives the following error:-
"ORA-01460: unimplemented or unreasonable conversion
Does anyone know if there is a way round this?