Oracle blob error

[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.

[Paul Clement]

Re: Oracle blob error

On Wed, 27 Aug 2003 06:43:38 -0700, "Mohammad" <Mo_Moattar@yah oo.com> wrote:

¤ 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 ~~~ pclement@amerit ech.net
Microsoft MVP (Visual Basic)