| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
