| How to upload an image in form 6i in Apps [message #489615] |
Tue, 18 January 2011 02:00  |
 |
see23ora
Messages: 1
Registered: January 2011
|
Junior Member |
|
|
Hello,
I have upload an image in forms6i, in oracle apps
On button press event, code is...
DECLARE
V1_PATH VARCHAR2(50);
BEGIN
V1_path := get_file_name('C:\IMAGE', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
DECLARE
image_path VARCHAR2(200);
image_extension VARCHAR2(3);
BEGIN
image_path := v1_path;
image_extension := SUBSTR(v1_path, -3);
READ_IMAGE_FILE(v1_path, image_extension, 'SRF_EIMS_SO.BOH_SHIP_IMAGE');
END;
END;
But it giving error message when preesing the button i.e. FRM-47105: NO image name specified.
Thanks
|
|
|
|
|
|
| Re: How to upload an image in form 6i in Apps [message #490868 is a reply to message #489616] |
Thu, 27 January 2011 16:21  |
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
|
Senior Member |
|
|
try this my dear
declare
dirname varchar2(255);
v_filename varchar2(255);
begin
tool_env.getvar('c:\', dirname);
dirname := dirname || '\bin\bmp';
v_filename := get_file_name(dirname,NULL,
'All Files (*.*)|*.*|' ||
'JPEG Files (*.jpg)|*.jpg|' ||
'Bitmap Files (*.bmp)|*.bmp|' ||
'TIFF Files (*.tif)|*.tif|' ||
'CompuServe Files (*.gif)|*.gif|' ||
'PC Paintbrush Files (*.pcx)|*.pcx|' );
if v_filename is not null then
read_image_file(v_filename,'ANY','pp_foto.foto');
end if;
end;
owais baba
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
