UPDATE SQL Message "Lob locator should be inited"

DVE · Post by **DVE** » Wed 13 Dec 2006 16:17

IN This example on ApplyUpdates have got message
: "Lob locator should be inited"

WHY ??????
And HOW FIX IT ???

begin

IF :ACTION = 2 THEN

UPDATE nodes_path
SET
  TD = sysdate - 1/86400
WHERE
  rowid = :RD
RETURNING
  TD
INTO
  :TD;

END IF;

IF :ACTION =3  THEN

UPDATE nodes_path
SET
  GRAPH = :GRAPH,
  ANODE = :ANODE,
  BNODE = :BNODE,
  DSC = :DSC,
  PL_SQL = empty_clob()
WHERE
  rowid = :RD
RETURNING
  FD,PL_SQL
INTO
  :FD,:PL_SQL ;

END IF;

end;

:ACTION(FLOAT,IN)=2 
:RD(VARCHAR[18],IN)='AAAHa3AAJAAAAFsAAa' 
:TD(DATE,IN)='01.01.3000' 
:WHO(FLOAT,IN)=119 
:N(FLOAT,IN)=80 
:GRAPH(FLOAT,IN)=10 
:ANODE(FLOAT,IN)=7 
:BNODE(FLOAT,IN)=6 
:DSC(VARCHAR[0],IN)= 
:FD(DATE,IN)='13.12.2006' 
:PL_SQL(CLOB,IN)=

Plash · Post by **Plash** » Thu 14 Dec 2006 09:32

We cannot reproduce the problem. Please send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

DVE · Post by **DVE** » Fri 15 Dec 2006 11:32

We use version 5.55.1.24

Maybe it fixed in new version?

What version do you use?

Plash · Post by **Plash** » Fri 15 Dec 2006 14:05

Information that you have provided in the first post is not enough to reproduce the problem. We need to know the value of the SQL property of the query, Pascal code that you use and script to create the nodes_path table. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.