Large Blob Data problem in Oracle stored procedure
Posted on 6/18/2008 3:50:01 AM
in #ASP.NET 2.X
Hi,
Few days back I was working with Oracle database and one of my stored procedures which was inserting a blob data to the database. But I started getting a strange when the data in the blob data type got large. For large blob data I was getting the following error.
ORA-01460: unimplemented or unreasonable conversion requested.
The system would work consistently for small files but for large files I was getting this error. After Doing a bit of Google I found that this is a drawback of using stored procedure in Oracle database. If you try to pass over 32 Kb (or greater than 32512 char of string) then oracle will give this error in case of Blob data type.
The only simple solution I found for the problem was to use inline query to the database for updating large Blob data. There is no restriction on the inline query.
Regards
Vikram
|
Posted on 7/24/2008 8:53:38 AM
Is this problem in 10g too?
|