Arun Bhat K

• Aug 11th, 2014

 

In order to upload a file into Forms from DB server, WebUtil can be utilised.

Kumar Manoj

 Profile Answers by Kumar Manoj 

• Jan 24th, 2016

 

Can you explain in detail.

PULKIT_MEHTA

 Profile Answers by PULKIT_MEHTA 

• Jan 28th, 2016

 

Below is brief description
To enable webutil, do following:
1) Attach webutil_lib.pll library into the form
2) Subclass webutil object group
3) Move webutil block as last block
You can use webutil_file_transfer package and client_to_db or client_to_db_with_progress function. It will upload file from client to BLOB D/B column

Guru Prasad

• Mar 27th, 2016

 

Here is a sample code for Forms 6i

Example Builtin Function to Popup the windows explorer from Forms

Code
PROCEDURE get_client_filename IS


l_filename VARCHAR2(200);


BEGIN


l_filename := client_get_file_name ( directory_name => 


, file_name => NULL


, file_filter => PRO Files (*.PRO)|||tr||lower(:block.fieldname)||:block.fieldnamel||*.PRO|


, message => NULL


, dialog_type => NULL


, select_file => NULL );


:bl_laboratorio.file_name := l_filename;


END;