Toad World® Forums

Crash on failure to update remote data


#1

Hello,

Today, I encountered (and could reproduce) a crash in build 1028: when updating over a db_link and encountering a failure (in my case, a foreign key problem), SqlNav crashes - see attached (part of a) screenshot
image002.jpeg


#2

Hi, I have no idea why SQL Nav is not handling gracefully this error over db_link?
We have to investigate.
Can you provide

  • more details about your environment (Oracle Client and Server),
  • more details (steps) about updating over db_link?

Thanks,


#3

Andrew,

Here’s how I could reproduce it:

  1. On the remote database, create a table with a PK, like this:

CREATE TABLE TEST
( nr NUMBER(2)
, nm VARCHAR(100)
)
/

ALTER TABLE TEST
ADD CONSTRAINT test_pk PRIMARY KEY (nr)
USING INDEX
/

INSERT INTO TEST VALUES (1, ‘ONE’)
/
INSERT INTO TEST VALUES (2, ‘TWO’)
/

COMMIT
/

  1. On the local database, you need to create a package/function/procedure that first updates/inserts some data and then triggers an exception (here, a PK failure):

CREATE OR REPLACE PROCEDURE f_test
AS
BEGIN
INSERT INTO test@db_link_rdrt VALUES (0, ‘ZERO’); – will succeed
INSERT INTO test@db_link_rdrt VALUES (1, ‘UN’); – will fail (PK)
INSERT INTO test@db_link_rdrt VALUES (2, ‘DEUX’); – see how good my French is?
COMMIT;
END;
/

  1. On the local database, execute the procedure

BEGIN
f_test;
END;
/

  1. Crash.

BTW: the requested client/server info:

Client: 9.2.0.7
Local DB: 9.2.0.7 Standard Edition
Remote DB: 9.2.0.8 Enterprise Edition

Edit: added DB versions/client


#4

Hi Dominique,

I managed to reproduce this issue in my machine. it will be fixed shortly. Thanks for the info.

Gwen