RE: Avoding Mutation of Table trigger
use PL/SQL table or temporary table -Original Message- Sent: Tuesday, August 20, 2002 1:58 PM To: Multiple recipients of list ORACLE-L Hi, This problem/solution may be posted earlier, but would like to hear a solution from you. I have two table say TAB1 and TAB2. TAB2 is a detail of TAB1 table. 1. TAB1 Pk_key numnber(10) AMTnumnber(14,2) ... More colums pk_key is Primary Key. 2. TAB2 Pk_key numnber(10) PK_slnumber(2) AMTnumnber(14,2) ... More colums 1. pk_key + pk_sl is Primary Key. 2. pk_key is foreign key to tab1 Now I would like to write a trigger in TAB2 for INSERT and UPDATE operation which will update the AMT coloum of TAB1. The value to be updated is sum of AMT coloumn of TAB2 for the PK_KEY value. i.e. select sum(amt) into tot from TAB2 where PK_KEY= :NEW.PK_KEY; Since TAB2 is currently being modified it can not be read. so, how to solve 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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: Atul Kumar Srivastav 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 from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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).
RE: how to schedule an execution in PL/SQL
write a procedure (p1) to check the condition and based upon the condition call packaged procedure (p.p2) from it. use dbms_job to schedue the execution of procedure p1. Atul -Original Message- Sent: Tuesday, August 20, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Any idea how to schedule the execution of a PL/SQL package? and if a certain condition is acomplished to execute again (later in the night) the same package until the same condition is not anymore fulfilled? In PL/SQL not using a script for the operating system for example. Ciprian MAFTEI Telequote Network Computer Systems Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mac 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 from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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: Atul Kumar Srivastav 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 from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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).
SCO UNIX
Hi everybody, Could anybody tell which is the latest version of SCO UNIX. and does Orale 8i DB works on that. Any info of Oracle on SCO unix. Thanx in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav 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 from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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).
RE: rbs oracle data block corrupted
version : 8.1.6 -Original Message-From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]]Sent: Sunday, June 30, 2002 12:13 AMTo: Multiple recipients of list ORACLE-LSubject: Re: rbs oracle data block corruptedHi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
oracle installation problem
when we install oracle 8.1.6 on Windows NT following error occoured. ora-01503 : create control file failed after instalation following message desplayed - global db name :ghytwo database system identifier(sid);orcl internal account password:oracle sys acc pas. :change_on_install system account password :manager Also listener.ora file not genereted(empty) Please suggest solution. It is urgent. Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav 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 from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB 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).