Home » Developer & Programmer » Forms » read, display and store image file in database (database 11g Rel.2, Forms 10g)
read, display and store image file in database [message #647564] Tue, 02 February 2016 04:44 Go to next message
oralover2006
Messages: 144
Registered: January 2010
Location: India
Senior Member
hi all,

i want to read image file, display in Forms 10g and store it in Database 11g. i downloaded an example from internet, it reads image file, display name with full path but can't display in Image Item on Forms. Showing Error: 100501: non-Oracle exception
DECLARE
	l_file_name varchar2(200);
BEGIN
	:global.user_home := webutil_clientinfo.get_system_property('user.home');
	l_file_name := client_get_file_name(directory_name => :global.user_home
                                    ,file_name      => null
                                    ,file_filter    => 'GIF Files (*.gif)|*.gif|JPEG Files (*.jpg)|*.jpg'
                                    ,message        => null
                                    ,dialog_type    => null
                                    ,select_file    => null
                                    );
  :EMPLOYEE_INFORMATION.file_name := l_file_name;
  if l_file_name is not null
  then
  client_image.read_image_file ( l_file_name, substr ( l_file_name, instr ( l_file_name,'.')+1), 'EMPLOYEE_INFORMATION.EMP_PIC' );
end if;
  
END;


what i am missing or any mistake... please help.

regards.

[Updated on: Tue, 02 February 2016 05:55]

Report message to a moderator

Re: read, display and store image file in database [message #647567 is a reply to message #647564] Tue, 02 February 2016 07:20 Go to previous message
oralover2006
Messages: 144
Registered: January 2010
Location: India
Senior Member
Problem solved... just changed client_image.read_image_file to read_image_file and it display image and saved.

regards.
Previous Topic: condition in execute query
Next Topic: form not showing in IE11 browser
Goto Forum:
  


Current Time: Thu Mar 28 20:48:03 CDT 2024