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 5/25/2008 10:03:44 PM
Hi,
I find your url from forums.asp.net
This statement "select new_time(sysdate,'EST','GMT') into Result from dual;" does not work, but when changed to
"select new_time(sysdate,'EST','GMT') from dual;" executes perfectly. I am using oracle 10.2.
Could you plz tell me where is the problem
"
|
Posted on 8/6/2008 5:38:04 AM
Your method to get Oracle UTC date is wrong (only works for Eastern Standard...).
What you should do :
select cast(sys_extract_utc(systimestamp) as date) from dual;
|
Posted on 7/1/2010 10:03:40 AM
Hi,
I was also facing this same problem and found a good solution of passing more than 32K of data to oracle stored procedure. I ahve used ODP.net instead of Oracle client. ODP.net allows you to pass more than 32k to stored procedures. You can easily find free downloads for ODP.net on google.
|