Home » Developer & Programmer » Forms » Display image item from database reading all type of image (server 2016)
Display image item from database reading all type of image [message #681452] Sat, 18 July 2020 15:33
saskico
Messages: 1
Registered: July 2020
Junior Member
Hello ,
i'm using webutil to upload all kind of images to database .

DECLARE
l_success boolean;
l_filename nVARCHAR2(500);
V_FILE_NAME VARCHAR2(500);
BEGIN

l_filename := client_get_file_name( directory_name => null,
file_name => NULL,
file_filter => NULL,
MESSAGE => NULL,
dialog_type => NULL,
select_file => NULL);

:file_name:= substr(l_filename,instr(l_filename,'\',-1)+1) ;

:TABLE_NAME:=nvl(:parameter.p_TABLE_NAME,'GL');
:INT_TABLE_RECID:=nvl(:parameter.p_INT_TABLE_RECID,0);

if :INT_FILE_ID is null then
select nvl(max(INT_FILE_ID),0)+1 into :INT_FILE_ID from LNT_FILES;
select nvl(max(TRANS_NUMBER),0)+1 into :TRANS_NUMBER from LNT_FILES
where TABLE_NAME=:parameter.p_TABLE_NAME;
end if;

:system.message_level:=25;
post;
----------------------------------------------------------------------

l_success := webutil_file_transfer.Client_To_DB_with_progress(clientFile => l_filename ,
tableName => 'LNT_FILES',
columnName => 'ATTACHED_FILE',
whereClause => 'INT_FILE_ID =' ||:INT_FILE_ID,
progressTitle => 'uploading,
progressSubTitle => 'Loading File Please Wait....',
asynchronous => false,
callbackTrigger => null);

if l_success then
message('File uploaded successfully into the Database');
elsif not l_success then
message('File upload to Database failed');
end if;
:system.message_level:=0;
EXECUTE_QUERY;
LAST_RECORD;
EXCEPTION WHEN OTHERS THEN
MESSAGE('File upload failed: ' || SQLERRM);

END;

everything is working fine, all files uploaded
in the form there is image display item,but when execute query only shows images which is in BMP extension ... i want to the display item to show all kind of images extension (bmp,jpg,gif...).
any help please ..

I'm using oracle forms 12c (12.2.3.0)
oracle database 12.2.1

Thanks in Advance
Previous Topic: frm-40654: record updated by another user
Next Topic: fnd_message.set_string
Goto Forum:
  


Current Time: Fri Mar 29 01:15:19 CDT 2024