Re: Interesting problem...?

I believe that prior to 8i you can't have (or at least I seem to remember in training classes be advised against it) more than one "large" column per table. Make a new table that foreign key references the report_no column and hang the photo off of it. I would also recommend changing the column type of your photo to BLOB as you have done with the sound clip.

"H Smith" <hsmith00_at_prodigy.net> wrote in message news:bTEH6.2541$Q97.538680426_at_newssvr10-int.news.prodigy.com...
> Platform-
> ORA Forms 6.0.8 ORA DATABASE 8.0.5 on NT
> Question-
> Has anyone ever had a problem saving an Image and Sound in the same
 table.
> The table structure is as follows:
>
> Name Null? Type
> ------------------------------- -------- ----
> REPORT_NO NOT NULL NUMBER
> MEDIA_ID NOT NULL NUMBER(2)
> MEDIA_TYPE NOT NULL VARCHAR2(5)
> MEDIA_TITLE NOT NULL VARCHAR2(20)
> MEDIA_DESC NOT NULL VARCHAR2(250)
> MEDIA_PHOTO LONG RAW
> MEDIA_LOC VARCHAR2(30)
> MEDIA_SOUND BLOB
>
> I'm using the Oracle forms default to load into the database. Yet I get
 "end
> of communications channel"
> when I Save. But, only when I try to save a "Sound" alone. I can save an
> Image & Sound or just an Image,
> but not just a Sound alone....
>
>
> MetaLink is not really helping me on this...I'm hoping a true Guru can...
>
> thanks
>
>
>
Received on Fri May 11 2001 - 14:13:07 CEST