Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Trigger Problem updating same table

 
   Database Forums (Home) -> Oracle RSS
Next:  Taking benefit from datawarehousing  
Author Message
Launch201




Joined: Aug 04, 2005
Posts: 1



(Msg. 1) Posted: Thu Aug 04, 2005 9:41 am
Post subject: Trigger Problem updating same table

I have a trigger which I want to update certain colums of the row being updated based on data entered into the first column. The table is being updated from an external datasource using HS.

Here is my trigger:

CREATE OR REPLACE TRIGGER "SYSADM"."TESTUPDATE" BEFORE
UPDATE ON "Test"
FOR EACH ROW BEGIN
UPDATE "SYSADM"."Test"
SET "SYSADM"."Test"."Name" =
(select "NAME" from JonLP#txt@JonLP
where "ROWNUMBER" = :NEW."RowNumber")
where "SYSADM"."Test"."F_DocumentID" = :NEW."F_DocumentID";
END;

When I attempt to update a column in "Test" I get the following error:

ORA-02041: client database did not begin a transaction
ORA-06512: at "SYSADM.TESTUPDATE", line 2
ORA-04088: error during exacution of trigger "SYSADM.TESTUPDATE"


Any help would be greatly appreciated.

 >> Stay informed about: Trigger Problem updating same table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Weird problem: Update statement updating records it should.. - We recently upgraded to 10g. An update statement that previously worked fine is giving an error. Having looked at what it's doing all I can say is it's very weird The syntax of the update is: update table1 -- THIS UPDATES 54 RECORDS set....

Updating Multiple Columns in Multiple Rows - /* I'm having trouble updating multiple non-nullable columns in multiple rows in a single table, using 2 different tables to get the correlating data, in a single statement. Tables and 2 of the statements I've attempted are below: I want to update the 7...

Error updating materialized view - Hi all, I'm trying to update a materialized view: EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C'); This commands hangs for a very long time (no idea if it'll ever complete). Hm, reminds me of the halting problem. When I terminate it with a..

Trigger deleting :new value - Hello I have an update trigger that is for each row. The goal is to detect if a timestamp field is updated, if not updated it with system timestamp. My problem is the value of this field is lost and I end up with null value in the table. I am attaching....

Conditional Trigger - Hello all, I have the following task: I have a table with two fields, ISBN (NUMBER 9), TITLE and PERIODICAL_OWNER (NUMBER 9). I am trying to create a trigger that checks on insert, that the ISBN being entered is not already in the table but if it does,....
   Database Forums (Home) -> Oracle All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]