| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Triggers are wonderful things... Ora-2069 global_names error
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_01C07A84.884774F0
Content-Type: text/plain;
charset="iso-8859-1"
Now THERE's an intriguing thought -- Winnie the Pooh and Britney Spears collaborating on a music video. I remember my old Winnie the Pooh had a bare midriff too. In fact, it wasn't wearing any pants. And - oh, never mind.
Gosh, I wonder what Eric's friends would say about a society that embraces Winnie the Pooh and Britney Spears as its resident God and Goddess? :>)
--Walt (Gettin' back in the groove) Weaver Bozeman, Montana, USA
-----Original Message-----
From: Bowes, Chris [mailto:Chris.Bowes_at_kosa.com]
Sent: Tuesday, January 09, 2001 1:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Triggers are wonderful things... Ora-2069 global_names error
No, that message comes from having an 18 month old whose favorite words are
"winnie" for Winnie the Pooh and Britney for Britney Spears. I thought that
since I had a trigger calling package question, that the winnie angle was
better than singing a refrain of
"Sometime it works, sometimes it don't, sometimes I'm afraid to look, but
all I really want is for it to work and stop screwing up, no more 2069. Oh
someone please help me now" sung to the tune of Sometimes...
In reality though, I do really have a site that has a trigger calling a package that is updating a table across a database link and is dieing with an ORA-2069. Other packages in this system can update across the link, and this package will insert and delete just fine. It is dieing only on the updates to this one table. So if anyone has any suggestions (they can't enable global names) on where to look I really would appreciate it.
--Chris
Chris.Bowes_at_Kosa.com
-----Original Message-----
From: Rocky Welch [mailto:rockyw_99_at_yahoo.com]
Sent: Tuesday, January 09, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Triggers are wonderful things... Ora-2069 global_names error
Not much going on at Kosa these days, Chris? ;o)
"Bowes, Chris" <Chris.Bowes_at_kosa.com> wrote:
"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
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
Do You Yahoo!?
Yahoo! <http://photos.yahoo.com/> Photos - Share your holiday photos
online!
------_=_NextPart_001_01C07A84.884774F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD><BODY>
<BR><FONT face=Arial size=2>Chris.Bowes_at_Kosa.com</FONT> </DIV> <DIV> </DIV> <BLOCKQUOTE>
<P>Not much going on at Kosa these days, Chris? ;o)<BR>
<P> <B><I>"Bowes, Chris" <Chris.Bowes_at_kosa.com></I></B> wrote:
<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>
<META content="MS Exchange Server version 5.5.2650.12" name=Generator><BR>
<P><FONT face=Arial size=2>"HELLO! I'm TRIGGER. T-R-I double
GUH -ER TRIGGER!"</FONT> </P><BR>
<P><FONT face=Arial size=2>"You are?" Asked pooh pulling his nose
out of the honey jar. "That's nice. What's a trigger?"</FONT>
</P><BR>
<P><FONT face=Arial size=2>"Woo hoo hoo hoo hoo! He asked!
WHAT'S A TRIGGER? WHY THAT'S EASY!</FONT> <BR><FONT face=Arial
size=2>The wonderful thing about triggers is triggers are wonderful
things.</FONT> <BR><FONT face=Arial size=2>Their tops are made out of
headers, their bottoms can have lots of strings.</FONT> <BR><FONT
face=Arial size=2>They insert, update, delete and more, they're fun, fun,
fun, fun, fun</FONT> <BR><FONT face=Arial size=2>the most wonderful thing
about triggers is, I'm the only one! Oh, I'm the only one.
Grrrarrr"</FONT> </P><BR>
<P><FONT face=Arial size=2>"Well", said Pooh chuckling, "You are the only
one that doesn't work. You can't call a package to update a
record."</FONT> </P><BR>
<P><FONT face=Arial size=2>"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?"</FONT></P><BR>
<P><FONT face=Arial size=2>"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"</FONT></P><BR>
<P><FONT face=Arial size=2>"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..."</FONT></P><BR>
<P><FONT face=Arial size=2>"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.</FONT></P><BR>
<P><FONT face=Arial size=2>"Hmph", said Trigger folding his arms and
looking defiant. "Triggers DO NOT like calling an update across a
database link."</FONT></P><BR>
<P><FONT face=Arial size=2>"Oh bother. Now what do I do?", sighed
Pooh.</FONT> </P><BR>
<P><FONT face=Arial size=2>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....</FONT></P><BR>
<P><FONT face=Arial size=2>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</FONT></P! !><BR>
<P><FONT face=Arial size=2>--Chris</FONT> <BR><FONT face=Arial
size=2>Chris.Bowes_at_Kosa.com</FONT> </P></BLOCKQUOTE><BR><BR>Rocky
Welch<BR>Senior Consultant - Internet Services Group<BR>Arthur Andersen
Received on Tue Jan 09 2001 - 15:38:40 CST
 |
 |