March 16th, 2005, 12:55 PM
|
|
|
|
error: exceeding simultaneous session per user limit
ok i have a table called branch on TWO different db. i hav created two db link, one from each db to the other!
i have also created a trigger that will copy the row to the branch in other db.
trigger:
Code:
create or replace trigger insertBranchVal
before insert or update on Branch
for each row
declare
eID number;
eName varchar2(20);
eLocation varchar2(15);
BEGIN
eID := :NEW.Branch_No;
eName:= :New.Name;
eLocation:= :New.Location;
Insert into Branch@Greenwich values (eID, eName, eLocation);
END;
/
this shows no errors, but when i do an insert on branch i get the error "session per user limit"!
Last edited by paulh1983 : March 16th, 2005 at 02:34 PM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
