I want to attach files in my form like gmail
the procedure to attach and retrieve files.
Where are the files stored and where do you want them attached?
Do you want a functionality that allows the user to send an email and attach a file from a local directory?
I want to insert into a table with column datatype blob and i want to attach in oracle forms 11g.
Use the WEBUTIL_FILETRANSFER package from webutil, there are procedure CLIENT_TO_DB and DB_TO_CLIENT to upload and download file to/from the db.
You've got a full example here
For the retrieve part, if you're not intending to simulate an edit attachment feature, I think it's more direct if you save local (webutil_file_transfer.DB_To_Client_with_progress) and open with this built-in:
web.show_document ('file:///'||l_fichero, '_self');