Triggers are wonderful things... Ora-2069 global

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Tue, 9 Jan 2001 11:40:09 -0500
Message-Id: <10736.126161@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07A5A.D4A1B86C
Content-Type: text/plain;

charset="iso-8859-1"

"HELLO! I'm TRIGGER. T-R-I double GUH -ER TRIGGER!"

"You are?" Asked pooh pulling his nose out of the honey jar. "That's nice. What's a trigger?"

"Woo hoo hoo hoo hoo! He asked! WHAT'S A TRIGGER? WHY THAT'S EASY! The wonderful thing about triggers is triggers are wonderful things. Their tops are made out of headers, their bottoms can have lots of strings. They insert, update, delete and more, they're fun, fun, fun, fun, fun the most wonderful thing about triggers is, I'm the only one! Oh, I'm the only one. Grrrarrr"

"Well", said Pooh chuckling, "You are the only one that doesn't work. You can't call a package to update a record."

"I can't call a package?" Asked Trigger. "Of course I can. Calling packages to update records is what Triggers do best! So what's the problem?"

"Well, everytime you try to update across the database link to the other base, you mess it up. You cause an ORA-2069 error", replied Pooh, "I need you to call a routine to update records on this post insert or post update and succeed"

"Update after an insert or update. Why that's what Triggers to best. Here come some inserts and updates, watch me update that other base..."

"Hey you Blokes! C'mon. Update you chump! Global name? My name is global name is Trigger! That's good enough. Let's go. Update." Crash, bang, boom.

"Hmph", said Trigger folding his arms and looking defiant. "Triggers DO NOT like calling an update across a database link."

"Oh bother. Now what do I do?", sighed Pooh.

Just then, the NarrDBAtor made a suggestion. "if you turn to the middle of page 163, Trigger asks the Oracle List if they have seen this before." Trigger jumped up. "HOO HOO! Letters is what Triggers do best. I'll go do it. TTFN. Ta ta for now!" BOING, BOINg, BOIng, BOing, Boing, boing....

So then Trigger did indeed write the Oracle List to ask just that question. Pooh has a trigger that needs to needs to call a package to update a base across a database link. The problem is the "ORA-2069 global_names parameter must be set to TRUE for this operation" error hitting on a table. If the package calls for an insert, it works just fine. If it calls for a delete it works fine. Just on updates it causes this. This is a system at a friends site so I am not sure what kind of paticulars there are. It's an Oracle 8 base updating an Oracle 7 base via the database link. All the bases are on NT. Other packages work to other bases so I am pretty sure the listener stuff is set up right. I do not think they can turn on GLOBAL_NAMES as there are several interfaces going to and from these bases and that may mess some of them up. Anyone have a suggestion? Thank you in advance

--Chris
Chris.Bowes_at_Kosa.com

------_=_NextPart_001_01C07A5A.D4A1B86C
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Triggers are wonderful things... Ora-2069 global_names =
error</TITLE>
</HEAD>
<BODY>

"HELLO!  I'm TRIGGER.  =
T-R-I double GUH  -ER  TRIGGER!"


"You are?"  Asked pooh =
pulling his nose out of the honey jar.  "That's nice.  = What's a trigger?"


"Woo hoo hoo hoo hoo!  He =
asked!  WHAT'S A TRIGGER?  WHY THAT'S EASY!
 The wonderful thing about triggers is =
triggers are wonderful things.
 Their tops are made out of headers, =
their bottoms can have lots of strings.
 They insert, update, delete and more, =
they're fun, fun, fun, fun, fun
 the most wonderful thing about =
triggers is, I'm the only one!  Oh, I'm the only one.  = Grrrarrr"


"Well", said Pooh chuckling, =
"You are the only one that doesn't work.  You can't call a = package to update a record."


"I can't call a package?" =
Asked Trigger.  "Of course I can.  Calling packages to = update records is what Triggers do best!  So what's the = problem?"

"Well, everytime you try to =
update across the database link to the other base, you mess it = up.  You cause an ORA-2069 error", replied Pooh,  = "I need you to call a routine to update records on this post = insert or post update and succeed"

"Update after an insert or =
update.  Why that's what Triggers to best.  Here come some = inserts and updates, watch me update that other = base..."

"Hey you Blokes!  =
C'mon.  Update you chump!  Global name?  My name is = global name is Trigger!  That's good enough.  Let's go.  = Update."  Crash, bang, boom.

"Hmph", said Trigger folding =
his arms and looking defiant.  "Triggers DO NOT like calling = an update across a database link."

"Oh bother.  Now what do I =
do?", sighed Pooh.


Just then, the NarrDBAtor made a =
suggestion.  "if you turn to the middle of page 163, Trigger = asks the Oracle List if they have seen this before."  Trigger = jumped up.  "HOO HOO!  Letters is what Triggers do = best.  I'll go do it. TTFN.  Ta ta for now!"   = BOING, BOINg, BOIng, BOing, Boing, boing....

So then Trigger did indeed write the =
Oracle List to ask just that question.  Pooh has a trigger that = needs to needs to call a package to update a base across a database = link.  The problem is the "ORA-2069 global_names parameter = must be set to TRUE for this operation" error hitting on a = table.  If the package calls for an insert, it works just = fine.  If it calls for a delete it works fine.  Just on = updates it causes this.  This is a system at a friends site so I = am not sure what kind of paticulars there are.  It's an Oracle 8 = base updating an Oracle 7 base via the database link.  All the = bases are on NT.  Other packages work to other bases so I am = pretty sure the listener stuff is set up right.  I do not think = they can turn on GLOBAL_NAMES as there are several interfaces going to = and from these bases and that may mess some of them up.  Anyone = have a suggestion?  Thank you in advance

--Chris
Received on Tue Jan 09 2001 - 10:40:09 CST

Triggers are wonderful things... Ora-2069 global_names error