Re: file random write access from within a database

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 11 Mar 2011 14:18:11 -0300
Message-ID: <AANLkTi=z26UVgNpRmqU3m1tPm0iQTUVEi7whFqBN0uLb_at_mail.gmail.com>

You can call an external program and code that in C... it would be platform-dependant or would require recompile if you can code platform agnostic C.

hth
Alan.-

2011/3/11 Subodh Deshpande <deshpande.subodh_at_gmail.com>

> Hi Sokolowski,
>
> you have a file that you will upload with utl file and then latter at any
> point of time, you want to change few contents of the uploaded file. is it
> so..I do not think its possible..cause this uploaded file becomes a data
> element of certain object and associated datafile.
>
> Quote
> 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.
> UnQuote
>
> This is what something similar happen in Automated storage managed
> tablesapces but oracle archicture takes care of it..
>
> thanks..subodh
> 2011/3/11 Remigiusz Sokolowski <remigiusz.sokolowski_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
>>
>>
>>
>
>
> --
> ==============================
> DO NOT FORGET TO SMILE TODAY
> ==============================
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 11 2011 - 11:18:11 CST