Re: Database Triggers

Posted by Phindile on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-Triggers-tp4289p4298.html

I got the following messages:

compiled (with errors)

and it's followed by another message which only says "compiled" without (with errors).

I did an insert in the PERSALNO column on the DUMMY_PER_GEN_DET table

I checked the DUMMY_PERSON table, and noticed that it had updated the PERSALNO column.

There's no indexes on the table, let me look into indexing right now.

On Tue, Nov 7, 2017 at 11:51 AM, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

What?
you say, you had compilation error?
So your update problem solved?

Please clarify that first.

After that, answer the following..

What update are you doing? How many rows are there in the table? What columns are there and what about the indexes on that table? How many indexes and what are the size of them?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Database-Triggers-tp4289p4295.html

To unsubscribe from Database Triggers, click here.
NAML