ODAC, insert into BLOB field through other schema, grants

Iasen · Post by **Iasen** » Mon 11 Jul 2005 14:28

Dear Support,
I have a problem with ODAC 4.50 when I want to insert into BLOB field. The test case is:
1. I connected (without Net option) to schema A.
2. From schema B I call procedure, which insert into table BLOB data
In the insert there is returning of the BLOB.
3. I get error ORA-00942 table or view doesn't exist.

A. When I remove the returning option there is no error but the blob is not written.

B. When I move the procedure in the schema A it's working OK.

I don't know what is the problem and what I have to grant to schema A in the situation described in the test case.

Best regards,
Iasen

Alex · Post by **Alex** » Tue 12 Jul 2005 14:45

I suggest you to use TemporaryLob feature, please see http://crlab.com/forums/viewtopic.php?p=4055#4055 topic in our forum.