Page 1 of 1

UPDATE SQL Message "Lob locator should be inited"

Posted: Wed 13 Dec 2006 16:17
by DVE
IN This example on ApplyUpdates have got message
: "Lob locator should be inited"

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

Code: Select all

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)= 

Posted: Thu 14 Dec 2006 09:32
by Plash
We cannot reproduce the problem. Please send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

Posted: Fri 15 Dec 2006 11:32
by DVE
We use version 5.55.1.24

Maybe it fixed in new version?

What version do you use?

Posted: Fri 15 Dec 2006 14:05
by Plash
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.