I have a form to target 2 tables - one for text data, 2nd for documents (BLOB)
- for stroing text data eg. Name, address details etc. - I am using process which executes PL/SQL procedure on passed page item values (in procedure i am calling next val from seq and inserting)
need help if I can use different process on same form item (blob type, file browse) for inserting blob into respective table.
or if i can use same process, how would i pass blob to procedure?
I am able to insert BLOB, if i use table based on blob table only by using Form - Automatic Row Processing (DML) option (identification section). But for other form elements I am using "Sql code" option.