Home » Developer & Programmer » Forms » Image not saving (Windows XP DB 8i - forms 6i)
Image not saving [message #353658] Tue, 14 October 2008 08:57 Go to next message
*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 #353827 is a reply to message #353658] Wed, 15 October 2008 04:53 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you do the job? Which code do you use (if any)?

Is there any error message while committing changes you've made? If so, which one?
Re: Image not saving [message #353835 is a reply to message #353827] Wed, 15 October 2008 05:13 Go to previous messageGo to next message
*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 #353913 is a reply to message #353835] Wed, 15 October 2008 10:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did someone, while you were on vacation, do something with the table? For example, wrote a database trigger which deletes the image as soon as it gets inserted?
Re: Image not saving [message #354022 is a reply to message #353913] Thu, 16 October 2008 02:24 Go to previous messageGo to next message
*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 Go to previous message
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).
Previous Topic: HOW TO CREATE A VERTICAL MENU
Next Topic: create database trigger
Goto Forum:
  


Current Time: Sat Feb 15 01:34:01 CST 2025