Image not saving [message #353658] |
Tue, 14 October 2008 08:57  |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Dear all,
im getting a strange problem....i have the below table
SQL> DESC EMPLOYEE
Name Null? Type
------------------------------- -------- ----
EMPID NOT NULL VARCHAR2(10)
DEPT_ID NOT NULL NUMBER(15)
DEPT_NAME VARCHAR2(40)
WORK_LOCATION NOT NULL VARCHAR2(30)
EMP_NAME NOT NULL VARCHAR2(50)
DOB DATE
JOB_TITLE VARCHAR2(30)
SUPERVISOR VARCHAR2(40)
JOINING_DATE DATE
OFF_MOB VARCHAR2(15)
OFF_TEL VARCHAR2(15)
EXT# VARCHAR2(10)
OFF_MAIL VARCHAR2(60)
PERSONAL_MOB VARCHAR2(15)
HOME_TEL VARCHAR2(15)
PER_EMAIL VARCHAR2(60)
EMP_PIC BLOB
NATIONALITY VARCHAR2(30)
Im able to insert data & image and i can save but when im querying same new record there is no pic only data available...any suggetion why this happen?
Regards
|
|
|
|
Re: Image not saving [message #353835 is a reply to message #353827] |
Wed, 15 October 2008 05:13   |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi Little,
i have the below table...
EMPID NOT NULL VARCHAR2(10)
DEPT_ID NOT NULL NUMBER(15)
DEPT_NAME VARCHAR2(40)
WORK_LOCATION NOT NULL VARCHAR2(30)
EMP_NAME NOT NULL VARCHAR2(50)
DOB DATE
JOB_TITLE VARCHAR2(30)
SUPERVISOR VARCHAR2(40)
JOINING_DATE DATE
OFF_MOB VARCHAR2(15)
OFF_TEL VARCHAR2(15)
EXT# VARCHAR2(10)
OFF_MAIL VARCHAR2(60)
PERSONAL_MOB VARCHAR2(15)
HOME_TEL VARCHAR2(15)
PER_EMAIL VARCHAR2(60)
EMP_PIC BLOB
NATIONALITY VARCHAR2(30)
on my vacation it works fine after returning from vacation i dont no what happned...editing and inserting data is ok if i put any image of picture in emp_pic its also saves the current session and giving message trasaction applied and saved after query the same record there is no pic/image and the strange thing is there no any error. for inserting picture im using the below code.
declare
filename VARCHAR2(256);
begin
filename := GET_FILE_NAME(File_Filter=> 'All Files (*.*)|*.*|');
READ_IMAGE_FILE(filename, 'ANY', 'EMD_PIC');
end;
what can i do?
strange things are coming in my application even i create new another form the same table it giving same error. current session save and after querying no pic record found only other fields are displaying like empid,deptno etc etc...
any help little....
Regards
|
|
|
|
Re: Image not saving [message #354022 is a reply to message #353913] |
Thu, 16 October 2008 02:24   |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
No little im the only one....who can handle all the tasks....and the another point it was displaying the pictures when i inserted before my vacation yoiu got any clue dear why this happening?
Regards
|
|
|
Re: Image not saving [message #354116 is a reply to message #354022] |
Thu, 16 October 2008 08:14  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
No idea; although, you might try to recompile this form (Compile All (Ctrl + Shift + K)); sometimes such a trivial action helps (although I'm not sure it will do any good in your case too).
|
|
|