makasih pak bowo atas responnya...
tapi bukan itu yang saya maksud...
maksud saya adalah cara menyimpan file image ke dalam tabel database lewat
oracle form..
maaf kalo saya salah menjelaskan :)
ini adalah potongan script saya..
--create table foto_kar_mf ( nik varchar2(11) primary key, Foto blob)
--create or replace directory my_files as '/export/home/tkyte/public_html';
declare
l_blob blob;
l_bfile bfile;
begin
insert into foto_kar_mf values ( '940130', empty_blob() )
returning foto into l_blob;
l_bfile := bfilename( my_files, '940130.bmp' );
dbms_lob.fileopen( l_bfile );
dbms_lob.loadfromfile( l_blob, l_bfile,
dbms_lob.getlength( l_bfile ) );
dbms_lob.fileclose( l_bfile );
end;
saat script itu saya jalankan lewat SQL plus berhasil, kemudian saya ingin
jalankan script tsb lewat oracle form..saya lewatkan di item button (
triggernya WHEN-BUTTON-PRESSED ), keluar error :
Implementation Restriction:'DBMS_LOB.FILE_READONLY':Cannot directly access
remote package variable or cursor..
itu yang bikin saya bingung...:(
thanks...
~boy~
----- Original Message -----
From: "Yulius Wibowo" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, December 13, 2005 1:51 PM
Subject: [indo-oracle] Re: insert image di form
> Saya kasih hint-nya saja ya ?!
>
> "READ_IMAGE_FILE"
>
> Bowo
>
>
> --- In [email protected], "boy" <[EMAIL PROTECTED]> wrote:
>>
>> Salam,
>>
>> Rekan2 mo nanya nich..
>>
>> gimana caranya insert image lewat form..? saya udah coba lewat
> sqlpus sukses, giliran saya pindahin ke lewat form kok gagal..
>> pesen errornya :'
>> Implementation Restriction:'DBMS_LOB.FILE_READONLY':Cannot directly
> access remote package variable or cursor..
>>
>> pless help me..
>>
>> thanks...
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
