file random write access from within a database

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 11 Mar 2011 14:14:04 +0100
Message-ID: <4D7A201C.8050003_at_nordea.com>



hi,

I wonder if it is possible to write to a file from within a database at the chosen position.

What I want to achieve is to modify a kind of header of simple text file (few tens of MB in size).
I could read it to a LOB/table/buffer/whatever, modify few bytes and write it back to the file in its entirety. But this is rather unacceptable solution - I would rather imagine I open a file, set a position, write few bytes at this position (adding or eventually replacing some bytes on specified length), close a file.

I tried fseek, but it works in the Read-like mode only, as I get ERROR at line 1:

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 1219
ORA-06512: at "REMS.WRITE_AT", line 16
ORA-06512: at line 1


Regards
Remigiusz

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, 
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, 
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, 
o kapitale zakładowym i wpłaconym w wysokości: 227.593.500,00 złotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 11 2011 - 07:14:04 CST

Original text of this message