Home » SQL & PL/SQL » SQL & PL/SQL » cannot conver from BLOB TO RAW (oracle 9i database)
cannot conver from BLOB TO RAW [message #305314] Mon, 10 March 2008 06:59 Go to next message
najeebusmani
Messages: 2
Registered: March 2008
Location: kabul
Junior Member

i want to convert blob to raw or long raw but giving small buffer error

please help me out

thanks in advance
Re: cannot conver from BLOB TO RAW [message #305315 is a reply to message #305314] Mon, 10 March 2008 07:01 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Can you please post your code with the complete error stack?
Re: cannot conver from BLOB TO RAW [message #307242 is a reply to message #305315] Tue, 18 March 2008 04:15 Go to previous messageGo to next message
najeebusmani
Messages: 2
Registered: March 2008
Location: kabul
Junior Member

hi Frank Naude

can u please right down some sample script

so i can get an idea


thanks in advance

Re: cannot conver from BLOB TO RAW [message #307244 is a reply to message #307242] Tue, 18 March 2008 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
FIRST, post your code, THEN we can help you.

Regards
Michel
Re: cannot conver from BLOB TO RAW [message #317306 is a reply to message #305314] Wed, 30 April 2008 07:22 Go to previous message
kmazumder
Messages: 1
Registered: April 2008
Junior Member
You receive the error message as an attempt was made to convert BLOB to RAW where the BLOB size was bigger than the buffer limit for RAW data type.

Use DBMS_LOB.substr function to convert the BLOB to RAW.
Previous Topic: How to generate XLS from SQL*Plus?
Next Topic: Query optimization
Goto Forum:
  


Current Time: Wed Dec 07 06:45:07 CST 2016

Total time taken to generate the page: 0.11362 seconds