I have used this procedure to retrieve an image onto my forms....
PROCEDURE get_image IS
/* Define the local variables*/
l_filename VARCHAR2(60);
l_type VARCHAR2(10);
l_item_name VARCHAR2(60);
l_path VARCHAR2 (60);
BEGIN
/* Assign the values of the fields to the variables*/
l_filename := :PICS.file_image;
l_type := :PICS.type;
l_path := :PICS.file_path;
/* Assign the variable of the item where the picture will be put in the form*/
l_item_name := 'PICS.pic1';
/* Define the filename as the path, actual name of the file and the type of file,
but concatenating the various
elements from the variables*/
l_filename:= l_path||l_filename||'.'||l_type;
/*Use the build in procedure READ_IMAGE_FILE to retrieve the image from
the file*/
READ_IMAGE_FILE(l_filename,l_type,l_item_name);
EXCEPTION
WHEN VALUE_ERROR THEN
message('Value Error');
WHEN OTHERS THEN
message('Other error');
END;
and i have mapped the columns for image and image name in the form...
but when i click save button ...nothing happens....the images does not gets save into database