Home » SQL & PL/SQL » SQL & PL/SQL » Blob too large
Blob too large [message #40851] Thu, 07 November 2002 16:20 Go to next message
JAIME BOCANEGRA
Messages: 2
Registered: November 2002
Junior Member
I HAVE A TABLE WITH A SINGLE COLUMN (BLOB). I TRY TO USE A STORED PROCEDURE TO INSERT A ROW, BUT WHEN I EXECUTE IT, IT FAILS WITH THE MESSAGE "ORA-01401: inserted value too large for column".

I DONT KNOW WHAT TO DO: THE DATA TO BE INSERTED IS A IMAGE (280 bytes). Can you help me? Do i have to set the size of the blob datatype?

Thanks.

Report message to a moderator

Re: Blob too large [message #40866 is a reply to message #40851] Fri, 08 November 2002 08:03 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
use DBMS_LOB package

Report message to a moderator

Previous Topic: Error trapping in an Oracle Stored Procedure
Next Topic: Re: Error trapping in an Oracle Stored Procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 05:34:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.