OraFAQ Forum: Forms » read, display and store image file in database

Home » Developer & Programmer » Forms » read, display and store image file in database (database 11g Rel.2, Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

read, display and store image file in database [message #647564]

Tue, 02 February 2016 04:44

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