Home > Default > Help! Trying to write to a BLOB column

Help! Trying to write to a BLOB column

November 30Hits:0
Advertisement
I am trying to write to a BLOB column.
I insert a row with an empty BLOB (using the emppty_blob())
I then get the locator of the blob by using a select statement
that is marked 'for update' (autocommit is set to 'false')
I use the blob.getBinaryOutputStream() method to get an
outputstream and when I write outputstream.write(byte[], 0,
length) nothing happens!?
(I am trying to write a simple byte array {1,2,3,4,5,6,7,8,9,0})
Please help!
Thanks,
Eli
null

Answers

Hi,
just to exclude a simple possibility:
did you call "commit" after you've inserted/updated
the blob field?
If yes, could you please post your code?
Eli (guest) wrote:
: I am trying to write to a BLOB column.
: I insert a row with an empty BLOB (using the emppty_blob())
: I then get the locator of the blob by using a select statement
: that is marked 'for update' (autocommit is set to 'false')
: I use the blob.getBinaryOutputStream() method to get an
: outputstream and when I write outputstream.write(byte[], 0,
: length) nothing happens!?
: (I am trying to write a simple byte array
{1,2,3,4,5,6,7,8,9,0})
: Please help!
: Thanks,
: Eli
null

Read other 2 answers

Tags:

Related Articles

  • Error while importing a table with BLOB columnOctober 11

    Hi, I am having a table with BLOB column. When I export such a table it gets exported correctly, but when I import the same in different schema having different tablespace it throws error IMP-00017: following statement failed with ORACLE error 959: "

  • How to view PDF files strored in a BLOB columnOctober 11

    Hi all, I want to display a PDF file, stored in a BLOB column, in a form or through a JavaBean. But the problem is more complicated then that. I do not want to retrieve the PDF file in the application server that show it through a browser. Actually,

  • Getting errors while writing to a BLOB column using PrepareStatementOctober 11

    Hello, I am getting the following errors when I am trying to insert in a BLOB in the oracle 9i database: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 205 ORA-22

  • Index creation on Blob columnOctober 11

    I am new to InterMedia. I am trying to create an index on a blob column. I am getting a error - Can you please suggest me the solution of this problem. Thanks....... The following statement(s) failed to execute successfully. CREATE INDEX temp.ind1 ON

  • How to read BLOB column from a table in SQL or PL/SQLOctober 11

    I have table which is having one BLOB data type column . Ihave inserted few rows in that table . Now i want to see wheather BLOB column has been inserted properly or not . How to read that column through SQL or PL/SQL. Can anyone help me to do this.Y

  • Associative array type for each blob column in the tableOctober 11

    i am using the code in given link http://www.oracle.com/technology/oramag/oracle/07-jan/o17odp.html i chnages that code like this CREATE TABLE JOBS JOB_ID VARCHAR2(10 BYTE), JOB_TITLE VARCHAR2(35 BYTE), MIN_SALARY NUMBER(6), MAX_SALARY NUMBER(6), JOB

  • Need to create link to Word Doc in blob column in search results reportOctober 11

    I got the Oracle Text boolean search of word documents in a blob column of a table working. Now I need to be able to create a link in the results report. I know that Oracle creates a link for each document in the column when you attach a file, I just

  • Search a text in a multiple tables and one table has BLOB columnOctober 11

    Hi, I couldn't find a solution/examples for below scenario in oracle text documentation or related forums. I need to search a text in a multiple tables,in that one table has blob column which is used to store the documnents(pdf,doc,jpg..etc) and othe

  • How to create a dynamic hyperlink which point to a BLOB columnOctober 11

    Hello, I am fighting with the issue for about 2 days. My purpose is to use Oracle Report Builder to build a report of our employee directory which contains employee's information and also employee's picture. The requirement is that our report is goin

  • How to create dynamic link which point to a BLOB column in reportOctober 11

    Hello, I am fighting with the issue for about 2 days. My purpose is to use Oracle Report Builder to build a report of our employee directory which contains employee's information and also employee's picture. The requirement is that our report is goin

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.499 s.