Wednesday, August 6, 2014

How to Read Image File at Oracle Forms 10g ?

I heard and answered lot's of question. How i read image file from file system to Database in oracle forms 10g ?
Here is the solution.
First of all you have to configure webutil correctly. You need to configure formsweb.cfg, webutil.cfg
Attach the webutil.pll library at your forms. Make object group and subclass of webutil.pll
Now add a puss button to your form and write the following code at When-Button-Pressed trigger
--------------------------------------------
declare
 vfilename varchar2(300);
begin
 vfilename := client_get_file_name(file_filter => 'jpg(*.jpg,*.gif)|*.*');
 if vfilename is not null then
 client_image.read_image_file(vfilename,substr( vfilename,instr( vfilename, -1)),'COMPANY_INFO_MST.CIM_LOGO');
 client_image.write_image_file(vfilename,'','COMPANY_INFO_MST.CIM_LOGO'); 
 end if;
 
end;
-----------------------------------
set the following property of the image item.
image format: TIFF
sizing style: Adjust

Related Posts:

  • Alert Use this alert and example for a for loop :          SET_ALERT_PROPERTY('ALT_TWO',ALERT_MESSAGE_TEXT,'Do you want to Send Requisition ?');          V_ALERT:=SHOW_ALERT('A… Read More
  • All link for oracle learning foxinfotec http://psoug.org https://www.tek-tips.com https://www.guru99.com https://hasanjawaid.blogspot.com /http://sql-plsql.blogspot.com/ http://sql-plsql.blogspot.com/ http://naveen-plsql.blogspot.com/ http://www.askhar… Read More
  • logon page center window. Call procedure in when new form instance CENTER_FORM('WINDOW1',0); PROCEDURE CENTER_FORM(MyWindowName IN varchar2,UpperMargin IN number) IS x number(6); y number(6); BEGIN SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,TITLE,'Indi… Read More
  • Query Optimization Link youtube to learn :   ##   Oracle Advanced SQL Optimization Techniques         blogs.oracle.com Cursor for loop : SELECT-INTO SELECT-INTO offers the fastest and simplest way to f… Read More
  • https://javidhasanov.files.wordpress.com/2012/01/expert-oracle-database-architecture.pdf Read More

0 comments:

Post a Comment