LOB Support with Object Types?

From: Michael Schaefers <schaefe3_at_cs.uni-bonn.spam-remove.de>
Date: Mon, 17 Jan 2005 12:11:22 +0100
Message-ID: <csg6gs$v96$1@f1node01.rhrz.uni-bonn.de>

I have problems accessing a BLOB within an object type (Oracle 10g on a Linux machine).

Consider a simple type

CREATE TYPE foo AS OBJECT (
x int,
b BLOB,
) NOT FINAL INSTANTIABLE; The BLOB has to be accessed within an external C routine. To achieve this, I pass a foo object to a procedure similar to this:

PROCEDURE bar (f OUT foo) IS EXTERNAL

LANGUAGE C [...] When I try to execute the following SQL-Statement I get an error when opening the BLOB with OCILobOpen():

DECALRE
f foo;
BEGIN
<packagename>.bar(f); *** C-Error is risen here [...]
END; The error message says "ORA-22275: invalid LOB locator specified"

One reason might be that, since my object f does not yet exist in any table, the BLOB can not be accessed.

Does anybody have a clue?
Regards,
Michael Schaefers Received on Mon Jan 17 2005 - 05:11:22 CST