package compilation problem
I am having a package compilation problem . The package is like below CREATE OR REPLACE PACKAGE PKG_POSNS_TEST as TYPE cur_acct_checking_posn is REF CURSOR; PROCEDURE CHECKING_ACCT_POSN_TEST( in_position_as_of_date IN BUSY_DAY.RPT_DT%TYPE, out_rcur_acct_noninvst_posn OUT cur_acct_checking_posn, out_error_code OUT VARCHAR2); END PKG_POSNS_TEST; / CREATE OR REPLACE PACKAGE BODY PKG_POSNS_TEST as PROCEDURE CHECKING_ACCT_POSN_TEST( in_position_as_of_date IN BUSY_DAY.RPT_DT%TYPE, out_rcur_acct_noninvst_pos OUT cur_acct_checking_posn, out_error_code OUT VARCHAR2) AS BEGIN OPEN out_rcur_acct_noninvst_pos FOR SELECT DISTINCT P.ACCT_KEY, P.POSN_AS_OF_DT, P.POSN_PRD_TYPE_CD, P.POSN_SEQ_NBR, ' ' AS DESCRIPTION, A.ACCT_NBR as ACCTNUM, P.CURR_YLD_PCT AS YIELD, P.NOM_ACCR_INT_AMT, ' ' AS INTPAIDYTD, -- not available in database. P.NOM_UNT AS OPENINGBAL, (P.NOM_UNT+P.NOM_ACCR_INT_AMT) AS ACCTBAL, ' ' AS UNCLFUND, -- not available in database. (P.NOM_UNT+P.NOM_ACCR_INT_AMT) AS PREVMENDACCTBAL, -- is this correct or should it be for previous monthend. A.ACCT_OPEN_DT AS ACCTOPENDT, P.ANL_PCT_RT AS ANLPCTRT, ' ' AS INTFREQ, -- not available in database. (P2.NOM_UNT+P2.NOM_ACCR_INT_AMT) AS CHKPLUSBAL FROMPOSN P, POSN P2, -- for Checking plus ACCT_PORTFOLIO A WHERE A.ACCT_KEY IN (1,2,3) AND A.ACCT_KEY = P.ACCT_KEY AND P.ASSET_SUB_CLAS_CD = 'CH' -- Checking AND P.POSN_AS_OF_DT = in_position_as_of_date AND P.ACCT_KEY(+) = P2.ACCT_KEY AND P.ASSET_SUB_CLAS_CD = 'CHKPLU' -- Checking Plus AND P.POSN_AS_OF_DT = in_position_as_of_date ORDER BY DESCRIPTION; EXCEPTION WHEN NO_DATA_FOUND THEN CLOSE out_rcur_acct_noninvst_pos; out_error_code := SQLCODE; WHEN OTHERS THEN CLOSE out_rcur_acct_noninvst_pos; RAISE_APPLICATION_ERROR (-2, SQLCODE || SQLERRM); END; END PKG_POSNS_TEST; / the error it is giving is PLS-00323: subprogram or cursor 'CHECKING_ACCT_POSN_TEST' is declared in a package specification and must be defined in the package body can anyone help, vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vijaya Chander V.S 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).
Unix related - need some info
Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: distributed timeout error
Thanks for the input, Michael. You are correct in your error number assumption. It is the 2064 error. We did set the 2064 event in a logon trigger and last week and got a trace, not much help there either. I tried to get the analyst to choose between oradebug and dbms_system.set_ev so that I could set it independently of the session, but we finally just put a good old alter session in our load script. We ran a 10053 trace since the problem seems that it might be some sort of parse error on the source side. We wanted the 10046 trace to see exactly where the error was occuring since it is in a stored procedure and what it was waiting on. In working the theory that it might be object/stats/parse related I rebuilt the tables and recreated the indexes, no effect. The strange thing is that this error just started showing up two weeks ago, in two stored procedures (both doing the same thing, different tables) having the exact same frequency, scope, and duration of error. There must be a connection, but unfortunately this is a very hot problem for us and I don't have the window to figure it out. It is too bad, it is a very good puzzle. Almost hate to solve it with an upgrade. The main reason that I am upgrading is that Oracle support has tentatively identified a possible bug (although it is internal, so no details) that will be fixed by 8.1.7.4. Their position is that unless I upgrade they won't pursue this further. So, upgrading I am, even though I do not feel that they have really nailed the problem, but they won't give further support. Reasonable on their part, since they might find that we have a bug that is already solved. jack --- Michael P Sale [EMAIL PROTECTED] wrote: Ahh yes, the elusive Why. If you are already working with support then I would set an errorstack on the ora-2064 error number you are getting(I suspect that is what it is, you never say). This will give them extensive information as to the state of the call at the time of the error. If you are running a high enough version of the db this statement will work: alter system set events '2064 trace name errorstack level 3'; Otherwise you can set it in the init.ora: event = 2064 trace name errorstack level 3 Where 2064 is the error number you are getting. You can also set it at the session level with the alter session syntax and on another session with oradebug. This is obviously the much more painful route. The 10053 would only be relevant if you were running into a CBO issue, not likely unless you are running with certain events and/or underscore parameters in place, and the 10046 should show the sql being run (if taken at the proper level) but not why the error message, only that this particular sql was run and resulted in this error. An upgrade to address this problem directly might not solve it **UNLESS** you are running into bug 2140287 CREATE TABLE AS SELECT WITH DECODE CORRUPTING DATA (see the 8.1.7.4 patchset readme or metalink note 120613.1). In which case you could possibly have serious issues that would require you move to this patchset!!! Either way, the errorstack will give you the why even though only Oracle support or development would likely be able to interpret this for you. Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Silvey Sent: Friday, June 21, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Oracle support is saying much the same thing. They are advising an upgrade to 8.1.7.4 (from 8.1.7.2). Doesn't give us the reason WHY it is happening, but it might fix it. We have run 10053 and 10046 traces and can see no obvious issues. --- Michael P Sale [EMAIL PROTECTED] wrote: Without seeing more information, I have seen this type of a response where either the instance is not registered with the listener, or the db is not accepting connections for a variety of reasons (e.g. no more memory all the way to the db is shut down). Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Silvey Sent: Friday, June 21, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Listers, We have two stored procedures that are suddenly throwing random distributed operation not supported errors. These pieces of code are doing an insert into as select across a database link. The data is being pushed, not pulled. They have been running for months in production without a problem. Suddenly, they start throwing these errors, but will often succeed on the retry. Anyone have a similiar problem? thx, jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael P Sale INET: [EMAIL PROTECTED] Fat City
Re: Log file synch / direct path writes
Just how large is your overly large log buffer? 10 meg? 100 meg? 1 Gig??? ( ok, I've never heard of one this big, but you never know ;) Jared On Friday 21 June 2002 12:48, Erik Williams wrote: I have an instance that is waiting on log file synchs. I suspect that the waits are a result of a overly large redo log buffer. There are also considerable waits on direct path writes. The redo logs are on QuickIO, so I assume that the writes LGWR is writing asynchronously and not a source of the log file synchs. I want to be sure that the log file synchs and direct path writes are not related before I begin to experiment with the size of the redo log buffer. How can I be sure that the waits are being caused by DBWR and not LGWR? What are possible fixes for the direct path writes if it is the DBWR causing them? Multiple DBWR? The datafiles are not on QuickIO, just the redo. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Which Unix command (part 2)
I finally checked this out. Awesome script Brian! Jared On Monday 29 April 2002 14:36, [EMAIL PROTECTED] wrote: Here is another jewel I picked up from the shell news groups years and years ago. 6409:oracle@bart cat dtree #!/bin/ksh # usage: vtree [-a] [dir] : make a tree printout of the specified directory. [ X$1 = X-a ] andfiles=ON shift [ $# = 0 ] set . set X $@ until shift [ $# = 0 ] do [ ! $# = 1 ] echo cd $1 || continue echo ${BOLD}--- ${PWD} in KBytes ---${PLAIN} du -k ${andfiles:+-a} | sort +1f | awk '{ print $2 - $1 }' | sed \ -e 's/^\([0-9]*\) \(.*\)$/\2 \ (\1)/' \ -e s#^$1## \ -e 's#[^/]*/\([^/]*\)$#|\1#' \ -e 's#[^/]*/#| \ \ \ #g' | awk -F- '{printf (%10s %s\n, $6, $1) }' done Brian P. MacLean Oracle DBA, OCP8i Brian P MacLean To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] 04/29/02 01:17 Subject: Re: Which Unix command(Document link: Brian P MacLean) PM I build/keep several functions in my .profile file (see below). They are all simple enough to call at anytime. Have fun Function Description findc find files findl find large files findn find files created/accessed in the last day findo find open files function findc { find . -name *${1}* -print 2/dev/null | more } function findl { OPT_d=. OPT_s=1 OPT_n=38,12 while getopts d:ns:h option do case ${option} in d) OPT_d=${OPTARG} ;; n) OPT_n=63,60 ;; s) OPT_s=${OPTARG} ;; h | \?) echo usage: findl [-h] [-d starting directory] -n [-s size_meg] echo-d defaults to the current directory echo-n default sort is by size, if -n is specified then the sort is by path and name echo-s list files greater than or equal to 'n' meg, defaults to 1 return;; esac done DMY=$(echo ${OPT_s} | tr [0-9] [\0*10]) if [ ${#DMY} -ne 0 ] then echo Invalid value for option -s; return fi [ ${OPT_s} = ] v_size=1048576 || v_size=$((${OPT_s} * 1048576)) find ${OPT_d} -size +${v_size}c -type file 2/dev/null | \ xargs -n 20 ls -Fla {} 2/dev/null | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) }' 21 | \ sort -k .${OPT_n} } function findn { find . -name *${1}* -ctime -1 -type f -print | sort | while read F do echo $(ls -Fla ${F}) $(fuser ${F} 2/dev/null | cut -c1-60) done | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s %s %s %s %s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) }' 21 | sort -k .38,12 } function findo { find . -name *${1}* -ctime -1 -type f -print | sort | while read F do v_CNT=$(fuser ${F} 2/dev/null | wc -w) if [ ${v_CNT} -ne 0 ] then echo $(ls -Fla ${F}) $(fuser ${F} 2/dev/null | cut -c1-60) fi done | \ awk '{printf (%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s %s %s %s %s %s %s %s %s %s %s %s %s\n, \ $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) }' 21 | sort -k .38,12 } Brian P. MacLean Oracle DBA, OCP8i Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.com cc: Sent by: Subject: WHich Unix command [EMAIL PROTECTED] om 04/29/02 12:08 PM Please respond to ORACLE-L Hi Which unix command(On Solaris) is used to find latest biggest files on whole server? or Which unix command(On Solaris) is used to find latest biggest files on particular disk partition? Thx -seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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
Re: Oracle AQ MQ Series
On Wednesday 19 June 2002 13:21, Khedr, Waleed wrote: Do you know of any product that could act as a listener for Oracle AQ to provide an interface layer that act similar to MQ Series so that these applications that work with MQ could work directly with Oracle AQ? Try Tibco. Jared Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: SEQ#, DUAL and Oracle literacy
LOL! I had to ponder this for a few seconds. Good one Steve. Jared On Tuesday 18 June 2002 14:23, Orr, Steve wrote: Here's a performance tuning query to help identify the problem: SELECT column_name The problem is the... FROMdba_tab_columns WHERE owner='SYS' AND table_name = 'DUAL' / :-) -Original Message- Sent: Tuesday, June 18, 2002 2:13 PM To: Multiple recipients of list ORACLE-L So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Re:RE: Alternative to Crystal Reports
My personal favorite. If you want pretty charts, learn Perl and use DBD::Chart. Amazingly easy to do. Jared On Friday 21 June 2002 06:48, Loughmiller, Greg wrote: Alternative to Crystal: The Cheap Man's Reporting when you have no capital/software budget sql*plus formatting via Unix scripts to html format:-) greg -Original Message- Sent: Friday, June 21, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Also thing big $$. Business Objects is much more expansive. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 21, 2002 12:50 AM Business Objects is good although the learning curve is pretty big. Although it is like anything and you have to watch the SQL statements that are used. We had a client bring there production system to its knees with a few poorly designed reports. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: Alternative to Crystal Reports Date: Thu, 20 Jun 2002 14:18:42 -0800 Chris, Until some fool gives the general user this tool as a general purpose query tool. Then all hell breaks out. Dick Goulet Reply Separator Author: Bowes; Chris [EMAIL PROTECTED] Date: 6/20/2002 1:33 PM I have yet to see something that I cannot do in Crystal Reports. However, I don't write the reports off of tables, I use stored procedures to query and process the records and return cursors to the crystal report. That way all the data is massaged and pre-formed and the report is but a template. When done this way, you can send in parameters to determine what to do with the data before it gets to the report. I'll have the same query with differing where clauses and use something like if i_date is not null then use query one which has a date range find else use query2 which ignores date. Or you can create a query of groups and summaries and send it to Crystal and Crystal will look at each summarized record as if it was just another record from the base. Using stored procedures, you can do unions, summaries, calculated fields, dummy fields, literals, etc and crystal can handle it no problem. It is quite robust when done this way. --Chris Reply Separator Author: Steve McClure [EMAIL PROTECTED] Date: 6/20/2002 10:17 AM Several times in the past I have seen folks on this list refer people to a reporting product to use as an alternative to Crystal reports. Apparently I didn't think I would need it, cause I usually save posts with information I am likely to forget.(So Yeah, I do save a lot of posts) Well now Crystal is being touted here as a possible solution for a new client's reporting requirements. We have been unable to convince Oracle Reports to perform in the way we would like, so we need an alternative. The good thing is that the new client is a large one, so my company will actually be able to invest in a nicer product. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: 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). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Alternative to Crystal Reports/TITLE /HEAD BODY PFONT SIZE=2I have yet to see something that I cannot do in Crystal Reports.nbsp; However, I don't write the reports off of tables,
Re: Log file synch / direct path writes
result of a overly large redo log buffer. How large is it? How can I be sure that the [direct path write] waits are being caused by DBWR and not LGWR? In v$session_wait, for the direct path write wait event P1 is the file number. Waits for DBWR will be associated with a different set of files than waits for LGWR. Set up a loop to query v$session_wait every 5 seconds -- INSERT INTO test_table SELECT P1 FROM v$session_wait WHERE wait equals direct path write. Let it run for a while to collect values of P1 for this wait event into your test table. Then SELECT from the test table, doing a group by and count(*), so you can see which files are involved with these waits. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: SEQ#, DUAL and Oracle literacy
On Wednesday 19 June 2002 00:48, Farnsworth, Dave wrote: Hallo, What is dual? Are you a dummy? ;) g -Original Message- Sent: Tuesday, June 18, 2002 2:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: SEQ#, DUAL and Oracle literacy
if not Janus, how about Narcissus? On Friday 21 June 2002 08:53, Sakthi , Raj wrote: Next thing you know some of the management types may take offence to that column name...!!( However clearly it depicts them..!!) Lets rename the table as Janus after the 2 faced greek GOD. ( Jared since we ARE discussing DUAL this is not OT is it.?.;) ) RS --- Alexandre Gorbatchev [EMAIL PROTECTED] wrote: And one column :))) SQL describe dual Name Null? Type - DUMMY VARCHAR2(1) -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 21, 2002 10:28 AM RS wrote: What kinda name is dual...sounds suspicious..;) Especially when you consider that DUAL has ONE record only :-)) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 21, 2002 5:58 AM While you are at it can you fix that name too...? What kinda name is dual...sounds suspicious..;) RS --- Khedr, Waleed [EMAIL PROTECTED] wrote: So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Khedr, Waleed 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: Yechiel Adar 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
Re: package compilation problem
Check the spelling on your variables. In the package header, you have out_rcur_acct_noninvst_posn. In the package body, you define it as out_rcur_acct_noninvst_pos. Dennis Vijaya Chander V.S wrote: I am having a package compilation problem . The package is like below the error it is giving is PLS-00323: subprogram or cursor 'CHECKING_ACCT_POSN_TEST' is declared in a package specification and must be defined in the package body can anyone help, vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler 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: DUAL related
Kinda neat. Thanks! Patrice. -Original Message- Sent: Saturday, June 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L For those who want to optimize select something from dual, look at the following link... http://www.oracledba.co.uk/tips/dual_speed.htm Regards, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: Boivin, Patrice J 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).
Urgent - Upgrade from 8.1.6 to 8.1.6.3
Hi, I have upgraded two databases from 8.1.6 to 8.1.6.3. After upgrade I ran catalogand catproc.sql for both of them. For first database ir ran fine. But for the second one it never started. So I cacelled that one. I started again and now it is been 20-25 minutes. But, stll there is no activity. Am I hitting some bug or something?? Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Urgent - Upgrade from 8.1.6 to 8.1.6.3
On Sat, Jun 22, 2002 at 05:48:19PM -0800, [EMAIL PROTECTED] wrote: Hi, I have upgraded two databases from 8.1.6 to 8.1.6.3. After upgrade I ran catalogand catproc.sql for both of them. For first database ir ran fine. But for the second one it never started. So I cacelled that one. I started again and now it is been 20-25 minutes. But, stll there is no activity. Am I hitting some bug or something?? -- check the alert log, what is it say it is doing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Unix related - need some info
On Sat, Jun 22, 2002 at 09:38:25AM -0800, Vladimir Barac - posao wrote: Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... try using top * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? look at /etc/syslog.conf which will tell you where your system messages are, there should be some helpful info there. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Unix related - need some info
On Solaris ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM -opmem,pcpu,user,args use: psrinfo -v prtconf | grep Mem format uname -a HTH Richard -Original Message- Sent: Saturday, June 22, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: Ji, Richard 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: OTN discount code.
OTN CODE USE OPP and get 35% discount - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:03 PM It used to be 'OTN20' a while ago but not finding anymore on Oracle sites.(old one was 'S36'). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 10 Jun 2002 13:33:58 -0800 List, someone pl.. tell me the new OTN discount code for OCP exam?? she is such a pig_headed, insists on the code...damn.. Thanks, Sunil Nookala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Mushtaq A Safina 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: OTN discount code.
Use OPP and get 35% discount - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:03 PM It used to be 'OTN20' a while ago but not finding anymore on Oracle sites.(old one was 'S36'). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 10 Jun 2002 13:33:58 -0800 List, someone pl.. tell me the new OTN discount code for OCP exam?? she is such a pig_headed, insists on the code...damn.. Thanks, Sunil Nookala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Mushtaq A Safina 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: OTN discount code.
Hello, Can anyone just use the OPP code for exam discounts or do you have to be a somebody to be allowed to use it? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).