473,473 Members | 2,092 Online

Sign in
Join

Home Posts Topics Members FAQ

Oracle blob error

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.

Nov 22 '05 #1

Subscribe Reply

1

6031

On Wed, 27 Aug 2003 06:43:38 -0700, "Mohammad" <Mo********@yahoo.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...b;en-us;322796
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

Oracle blob error

by: Mohammad | last post by:

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

Reading Blobs From Oracle

by: Ken | last post by:

Hello, I'm trying to read a Blob from Oracle and then write it to an audio file(.AU). I'm using Visual Studio.Net 2003 (VB). I can't seem to get my code to work. Will someone take a look at it...

Oracle Stored Procedures VERSUS SQL Server Stored Procedures

by: jrefactors | last post by:

I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...

Using C# to insert blob into Oracle

by: Chris Fink | last post by:

I have setup an Oracle table which contains a blob field. How do I insert data into this field using C# and ADO.net?

accessing blob fileds from oracle

by: Chenna Sudarsan | last post by:

Hello, I am connecting to Oracle9.2 database from VB6.0 using MSDAORA provider. I am using ADO2.5. When I try to access a blob column of oracle I am getting the below mentioned error. ...

Retrieving Oracle BLOB

by: Peter Afonin | last post by:

Hello, I have Word documents stored in the Oracle database in the BLOB field that I need to retrieve. I've found the way of doing it: While dr.Read sName = dr("TE_PM_ATTACH_NAME") bLob =...

BLOB with oracle stored proc

by: Biztalk Migration | last post by:

I am new to using BLOB with oracle stored proc. I dont knw how to set the size of the buffer which seems to overflow no matter what i used to pass it. I am getting an error ...

retrieving BLOB from Oracle

by: matt | last post by:

hello, im doing my first ASP.NET app that inserts & retrieves files from Oracle (no need for a discussion on *that*!). i learned first-hand of the somewhat awkward technique for inserting...

Python Oracle 10g odbc blob insertion problem

by: Godzilla | last post by:

Dear all, I cannot find a solution for my problem with inserting a blob object (>4000 in length) into an ORACLE database via ODBC. I have tried the two ways of inserting the blob object (a...

inserting images from PictureBox in to the oracle database

by: Harshadcode | last post by:

Hi, This is HARSHAD, I am creating a project in VB.NET for managing details like photos of criminals. but i am facing problems in converting a image in to filestream so that it can be inserted in...

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us