ORA-22275 inserting CLOB with odac 6.80.0.48 on bcb2009

albourgz · Post by **albourgz** » Fri 25 Sep 2009 07:38

I have the following table:

SQL> desc cec.messagesservice;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DTMESS                                    NOT NULL TIMESTAMP(6)
 PRIORITY                                  NOT NULL NUMBER(1)
 MESSAGE                                   NOT NULL CLOB
 ID                                        NOT NULL NUMBER(20)
 STATUS                                             VARCHAR2(20)

I have a datamodule with a TOraSession, a TSmartQuery with as sql:

Code: Select all

select a.rowid, a.* from cec.messagesservice a ORDER BY  priority,ID

and CachedUpdates false, a TOraDataSource, a TCRDBGrid, and a TDBNavigator.
There is a Before insert trigger on this table to initialize the id:

Code: Select all

BEGIN
	if :new.id is null then   
		SELECT CEC.SEQMessagesService.NEXTVAL INTO :new.id FROM DUAL;
	end if;
END ;

When Opening form, I Open() The smartQuery.

In bcb 6, this program worked fine (with an older version of odac)
In bcb2009, using odac 6.80.0.48, when opening form, display works, but clicking on '+' button in navigator to add a record shows the following exception (before typing any value!):
Project Model.exe raised exception class EOraError with message 'ORA-22275: l'indicateur de localisation LOB indiqué n'est pas valide'.
(ORA-22275: invalid LOB locator specified).

Plash · Post by **Plash** » Mon 28 Sep 2009 08:59

We could not reproduce the problem. Check if the problem occurs after you disable the trigger.

Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

albourgz · Post by **albourgz** » Mon 28 Sep 2009 10:32

In fact, the problem is not due to the trigger.
It is due to the default value for the clob:
empty_clob()

I can send a sample if you give me an e-mail address.
PS: using bcb6 and odac 5.55.1.26, I have no problem with this default value.

Plash · Post by **Plash** » Tue 29 Sep 2009 07:34

Our e-mail address is support*devart*com.