Oracle blob error

M

Mohammad

hi

when i try to send a blob or Longraw value with more than
32k as parameter to stored procedure in oracle 9i, the
following exception raise

"ORA-01460 : Unimplemented or Unreasonable conversion
requested"

please help me for solving this problen.
 
P

Paul Clement

¤ hi
¤
¤ when i try to send a blob or Longraw value with more than
¤ 32k as parameter to stored procedure in oracle 9i, the
¤ following exception raise
¤
¤ "ORA-01460 : Unimplemented or Unreasonable conversion
¤ requested"
¤
¤ please help me for solving this problen.

If I remember correctly, this is a limitation using PL/SQL stored procedures and a Long Raw data
type.

See if the following helps (for BLOBS):

HOW TO: Pass a BLOB as a Parameter to an Oracle Package by Using the .NET Managed Provider for
Oracle
http://support.microsoft.com/default.aspx?scid=kb;en-us;322796


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to insert BLOB in Oracle 3
BLOB storage ADO.NET 5
Oracle CLOB parameter limit? 2
Problem With Clob and Blob 1
ORA-01460: unimplemented or unreasonable conversion requested 1
Passing morethan 32 KB Data to a Stored Procedure using ODP.Net Provider. 5
Turning a Word Document into a Blob 6
Insert 3 Gb binary file to oracle blob using Ado.net oracleclient 1

Top