Weird Error

Hi, me again.
I am hoping someone could advise me on this problem I am having. I am playing with form now and doing loading / retriving images and data. Everything is fine, once I do the form and all, I am able to retrive and view the image on the FIRST execute query. However, when I exit from the form runtime, and re-enter form runtime nd perform an execute query again, it comes up with this error.

SELECT ROWID,BLOB_TYPE,BLOB_ID,DESCRIPTION,BLOB_DATA FROM AV_DATA WHERE blob_type = 'IMAGE'

The file is :

 Name                       Null?    Type
 ------------------------------- -------- ----
BLOB_ID                  NOT NULL NUMBER(10)
 BLOB_TYPE            NOT NULL VARCHAR2(10)
 DESCRIPTION        NOT NULL VARCHAR2(25)
 BLOB_DATA                  LONG RAW

The data within is as follows:
  BLOB_ID   BLOB_TYPE  DESCRIPTION             B
-------- ---------- ------------------------- -
     1001          IMAGE              FirstBoot                 4
     1000          IMAGE              Startup                   4

Does anyone know why the form runtime will be ok on the first run and dies on the second run ? It is the same error with sounds as well.

I have play around it a bit more and I have found it is coming up with two errors, I am hoping me telling them will help someone give me an answer.

The first error seems to be when I have sucessfullly perform the Query, sto the query, reperform it and this comes up.

ORA-03113: end-of-file on communication channel

When I try to perform the query AGAIN, this error comes up

ORA-01041: internal error. hostdef extension doesn't exist

Anyone knows what I need to do ? I am thinking I need to reset something, perhaps a pointer or something.

Arthur Received on Sat Oct 21 2000 - 15:45:49 CEST