Database Trigger not fireing In Delete Mode

Title: RE: Avoding Mutation of Table trigger Hi all, I have row level table trigger to fire on DELETE or INSERT or UPDATE Mode . It has to fire on certain condition, meaning I have a WHEN condition also. WHEN Condition is like : when ( NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not

Avoding Mutation of Table trigger

it ? TIA Regards. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Data Base Link

/Listner is running or Not ? TIA, Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to Compile Pro*c

. Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production Any help is appreciated. Thanks in advance. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Cost of Porting Oracle to a different Unix !!!

FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Email from PL/SQL

Title: RE: Changing Java pool size to 0 Hi all, Using UTL_TCP (andthru other package like utl_smtp) I can send Email. But the problemI find is - I can send mail in the name of someone else mail ID. I would like to know from you - Why PL/SQL allow me to send mail impersonating someone

Set of DML in One Logical Transaction

will be fired to TAB1 (cur_amt) and that will Complete the transaction. How do I achieve it ? Thanks in Advance. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: How to make DBA cannot 'see' User's Tables?

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Re:Please Advice on Performance Tuning

!! Therefore, go back and analyze the SQL. I'd be suprised if you could not reduce the run time by 50% or more right there. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] (N J Neog) Date: 4/26/2001 9:25 PM Hi all, We have got a Payroll

Re: Please Advice on Performance Tuning

option. When you compare the two, it should tell you what they are doing differently and what you're biggest time waster is. Regards, David A. Barbour Oracle DBA, OCP N J Neog wrote: Hi all, We have got a Payroll Application develeoped in-house. It takes 30-34 Minutes to Run

Could not Connect to 8.1.6

Hi all, We 3 Oracle server as follows. A. Oracle8 Enterprise Edition 8.0.5 B. Oracle8i Enterprise Edition 8.1.5 C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. All are in Digital Unix The problem is Froma Unix user ifmy ORACLE_HOME is pointing to database A(8.0.5) or

Please Advice on Performance Tuning

Hi all, We have got a Payroll Application develeoped in-house. It takes 30-34 Minutes to Run this Batch Application.General feeling is - it should be able to process itwithin 10-15 Minutes may be less than that. I am to look into this problem and give a solution to it. Steps I had