ODAC, insert into BLOB field through other schema, grants
Posted: 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
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