Re: Passing Data from Table Triggers

If you can call the procedure from within the trigger, use the variable as a parameter. Otherwise assign it to a variable defined in a package specification.
This should be available everywhere.

Hth,

Sybrand Bakker, Oracle DBA

<mmoore96_at_my-deja.com> wrote in message news:8qr1r1$rhm$1_at_news.netmar.com...
> I've got a situation I'm sure someone has delt with. I have a table with
 a
> PK populated by a trigger. How do I communicate that PK number to a
> different procedure or trigger? I saw one example that was confusing and
> left me sure this can be done, but without a clue how to do it.
>
> Thanks,
> Mike
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> NewsOne.Net is FOR SALE. Click below for details.
> http://cgi.ebay.com/aw-cgi/eBayISAPI.dll?ViewItem&item=446657012
Received on Tue Sep 26 2000 - 23:41:37 CEST