I want to insert an employee's picture in a column in a table in a database. What is the data type I need to assign to the employee table? What is the procedure to upload it? I am using Forms 6i as Front end(GUI).
QUESTION POSED ON: 10 FEB 2005
QUESTION ANSWERED BY: Craig Mullins, Years 2005-2006
Okay, first of all I'm going to say that you should talk to your DBA before monkeying around with a database schema. That said, let's answer the question.
Since you are using Forms, I am assuming you are using an Oracle database. You would need to use a BLOB data type to store images in Oracle. Before changing your schema please consider reading the Oracle documentation for details on how BLOB data is implemented and accessed. It can be tricky to use BLOBs properly. And, once again, let me stress that you'd be better off if you went to your DBA staff for assistance in this matter.
|
|
|
