Home » SQL & PL/SQL » SQL & PL/SQL » BLOB TOO LARGE
BLOB TOO LARGE [message #4090] Thu, 07 November 2002 16:18 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 #4092 is a reply to message #4090] Fri, 08 November 2002 00:12 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
use package dbms_lob to load blob

Report message to a moderator

Previous Topic: cursors and all_tables
Next Topic: cartesian product ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 07:31:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.