Re: Interesting problem...?
Date: Tue, 01 May 2001 22:22:10 -0700
Message-ID: <3AEF9982.63313C7_at_exesolutions.com>
H Smith wrote:
> 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
No. But then I would never put a LONG RAW and a BLOB into the same table. Why did you?
Put the photo into a BLOB also.
Daniel A. Morgan Received on Wed May 02 2001 - 07:22:10 CEST