RE: PL/SQL
You can enter them directly at the SQL prompt or you can store them in database or keep them in files and run them with the @ command. The choice is yours :O) K. -Original Message- Sent: 05 March 2003 08:50 To: Multiple recipients of list ORACLE-L Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OFF TOPIC: Jedis, etc - was Top 10....
Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. -Original Message- Sent: 25 February 2003 09:39 To: Multiple recipients of list ORACLE-L Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 08:14 To: Multiple recipients of list ORACLE-L Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OFF TOPIC: Jedis, etc - was Top 10....
GRIN... That buzzing sound you just heard was me powering up!! Back off buster ;O) -Original Message- Sent: 25 February 2003 12:24 To: Multiple recipients of list ORACLE-L And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. Damn funny! I agree that there's no such thing as an unofficial religion but surely there is nobody (excepting the heavily medicated and chronically deluded) who truly believes that they are a jedi knight. They must be as much fun as the guys with Klingon dictionaries and transporter rooms in their loft. Mike PS I can feel the take this off-list bar lowering even as I speak. -Original Message- Sent: 25 February 2003 11:20 To: Multiple recipients of list ORACLE-L Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 is beter a cursor or a for loop?
I would suggest that the cursor is the best way to go. -Original Message- Sent: 24 February 2003 08:39 To: Multiple recipients of list ORACLE-L Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure Anyway the specific piece of code in discussion is similar to the following FOR X IN (SELECT X FROM TABLE_NAME WHERE COL1 = 'Something')) LOOP Do a whole lot of stuff in database here.. LOOP END; I would guess that the cursor would follow similar execution criteria but using the cursor syntax. Any ideas? TIA regards Denham Eva Oracle DBA The real problem is not whether machines think but whether men do. - B. F. Skinner _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Borderline OT - Unix for Oracle at home
I've got Suse8.1 setup at home with a DSL connection and am planning on putting Oracle 8 onto the box. Good setup, easily installed. Go for it ;O) -Original Message- Sent: 30 January 2003 15:14 To: Multiple recipients of list ORACLE-L I am looking to add a unix box to my collection of wintel machines at home. It will be used solely for running/testing Oracle, so I don't need bells whistles. My thoughts are either Linux/intel or Sun Ultra workstation. While it would be convenient to be able to network it into a DSL configuration, it is not essential. My original thought was a Linux desktop, but I can also get Ultra 5 or 10 workstations on ebay for less than $500. Anyone having experience good/bad/ugly for this type of task? All tips, challenges, things to consider are greatly appreciated. Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FULL TABLE SCAN?
Use Excel. K. ;O) -Original Message- Sent: 07 January 2003 16:29 To: Multiple recipients of list ORACLE-L Hi How to avoid FULL TABLE SCAN? Thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: echo `date`
eh? Try the key next to '1' (to the left)...all depends on how your keyboard is setup, nationality (of the os, not you :O). -Original Message- Sent: 23 December 2002 06:44 To: Multiple recipients of list ORACLE-L Dear List, I have Korn shell Script that show the date of execution. echo `date` - Start shutdown of oracle DB. Could any body tell me how to display this char ` the quotation for date. I mean which key I have to press in Unix to get this quotation character. I'm working with Unixware7.1 Regards, Ashraf __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Dynamic select query
Try: SQL SELECT * 2FROM shipment 3 WHERE ship_name LIKE '%ABC%'; SHI SHIP_NAME --- -- ABC 1ABC123 DEF ABC1234 GHI 1234ABC K. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 10:39 To: Multiple recipients of list ORACLE-L Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data as follows: SHIP_ID SHIP_NAME - --- ABC 1ABCLMN XYZ 23XYZ1112 ABB 123LM I want to select all the columns in shipment table which has ship_id as string in the ship_name column. For example, ship_id 'ABC' is present in '1ABCLMN'. So that record should be selected. The ship_id string may start from any position and end at any position in ship_name column. So I cannot use the substr function in this case. How do I write the select clause for this requirement? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Recall: Dynamic select query
Thomas, Kevin would like to recall the message, Dynamic select query. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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:
ALTER SESSION SET ORACLE-L NO MAIL ;o) -Original Message- Sent: 06 December 2002 14:19 To: Multiple recipients of list ORACLE-L uh-oh.. here they come.. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 8:35 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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:
Lookup SQL*Loader -Original Message- Sent: 10 October 2002 11:59 To: Multiple recipients of list ORACLE-L Hello all, I have a client who will be doing the data capture and give me the data in a flat file. what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sql query
HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
RE: UNSUSCRIBE
GRIN Hallo, What is UNSUSCRIBE...I have function in Access but cannot find in Oracle? Please help. -Original Message- Sent: 01 October 2002 12:13 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 01, 2002 5:58 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Apologies for Off-Topic Question - Where has Oracle-l-OT gone ?
Nope :O) -Original Message- Sent: 19 September 2002 13:18 To: Multiple recipients of list ORACLE-L Has the Off-Topic group gone ? Steve Parker E Mail: [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Executing a Unix command from database trigger
Check some back emails, I've posted a solution to running Unix commands from pl/sql procedures a number of times. Cheers, Kev. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 16 September 2002 23:58 To: Multiple recipients of list ORACLE-L Hi All, We need to execute some unix commands from PL/SQL code of a trigger? Can I do this just by using host command? host /usr/ucb/mail -s PROD_DB_DOWN [EMAIL PROTECTED] /user/oracle/log/db_down_prod.lst Is there any other way to do this? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: woo hoo
Congrats!!! Hope everything goes well, I'll keep me bits crossed :o) -Original Message- Sent: 31 August 2002 03:18 To: Multiple recipients of list ORACLE-L MY SISTER IS PREGNANT!!! Early days yet, and she will be very very very careful for a long time yet but she's pregnant! Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Thomas, Kevin 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: Host System Commands from PL/SQL blocks
I sent a mail in a while ago that explains how to set up a polling C Shell script that accepts Unix commands coming across a DBMS_PIPE. Essentially, the shell script sits in an infinite loop polling the DBMS_PIPE and taking commands from it, executing them, and then re-runs itself. It can be stopped by passing a command such as SHUTDOWN through the pipe. If you want me to send on the code, drop me a note. Cheers, Kev -Original Message- Sent: 30 July 2002 20:57 To: Multiple recipients of list ORACLE-L OK, I checked Google and my own old mail and I know I've seen this here before, but can't find my notes, so please forgive this same old question... I need to execute a system call from within a PL/SQL block. Specifically, I am looking at starting out report request demons as part of a post startup trigger. Help? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Thomas, Kevin 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 Q: ksh scripting
I get the following output: spauser sh kev.sh + sh kev.sh SQL*Plus: Release 3.3.2.0.0 - Production on Wed Jul 24 09:22:05 2002 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.2.3.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.2.3.0 - Production SQL SYSDATE - 24-JUL-02 SQL Disconnected from Oracle7 Server Release 7.3.2.3.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.2.3.0 - Production spauser So it would appear that your -x will only show the last command from the command line and that was the execution of the shell script. Do you get the same output. K. -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado 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: Thomas, Kevin 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 Q: ksh scripting
Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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 Q: ksh scripting
I'd just do: $ date ;o) -Original Message- Sent: 24 July 2002 14:49 To: Multiple recipients of list ORACLE-L With the addition of the extra quote...this worked fine for me. Kevin, try running it using the korn shell ( ksh instead of sh - bourne shell). If you're just trying to grab the date, though, I'd do it like this: #!/bin/ksh THE_DATE=`sqlplus -s / EOF set heading off set pagesize 0 select sysdate from dual; exit EOF` echo $THE_DATE If you really want the last line, maybe sysdate was just for kicks, you could spool a file before the select, spool off after it, then do a tail -1 on the spool file followed by cleaning it up OR leave it around (i.e. remove the file at the start, rather than at the end) until the next run just in case you have problems you can always go back to see what was there the last time it was run. HTH -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 24, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Hmm, this still doesn't seem to work. -Original Message- Sent: 24 July 2002 10:38 To: Multiple recipients of list ORACLE-L Oops, missed a quotation mark in earlier posting. Should have read: sqlplus -s / EOF | grep -v ^$ | sed -n '$p' select sysdate from dual; exit EOF Regards Chris -Original Message- Sent: 24 July 2002 09:15 To: '[EMAIL PROTECTED]' Ross, You are hitting a couple of problems here: 1 - the 'tail' command needs to be on your first line (sqlplus / EOF | tail -1) 2. However, I suspect this will not give you what you want as sqlplus prints a blank line at the end. Try the following: sqlplus -s / EOF | grep -v ^$ | sed -n '$p select sysdate from dual; exit EOF Grep will remove blank lines - sed will print last line. I'm sure there are many more ways of doing this. HTH, Chris -Original Message- Sent: 24 July 2002 05:53 To: Multiple recipients of list ORACLE-L Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF is ignored. Why? Thanks. Ross #!/bin/ksh #set -x sqlplus / EOF select sysdate from dual; exit EOF | tail -1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ross Collado 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Thomas, Kevin 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: Thomas, Kevin 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
RE: FW: bind vars change explain plan
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: Thomas, Kevin 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: download or upload.
I would say: When you load a text file into the database, you call it download or upload? = upload/insertion When you create a text file from your database you call it download or upload? = download/extraction Cheers, Kev. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: bind vars change explain plan
Your colleague hit the nail on the head. Using bind variables in queries can give the database a hit or miss approach to whether or not it uses indexes. Something to do with how skewed the indexes are also. Regards, Kev. -Original Message- Sent: 22 July 2002 16:08 To: Multiple recipients of list ORACLE-L prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the index. With the bind variable, the optimizer did not have a range of values to work with and therefore did not choose the index in the execution path. I have no knowledge that using bind variables will suppress indexes. Just happened that it did in this case. Also keep in mind that this particular database is using an old version of Oracle (7.3.4). Optimizer got much better in version 8. The list helped me out with a work-around, which was to index-hint the index I wanted. Bind variables are definitely good guys. I highly recommend you continue with your code changes to include binds. Good luck. Barb -- From: oraora oraora[SMTP:[EMAIL PROTECTED]] Reply To: oraora oraora Sent: Sunday, July 21, 2002 8:24 PM To: [EMAIL PROTECTED] Subject: Re: bind vars change explain plan Baker, sorry i did not read the reply to ur query. what was the reply ? will using bind vars suppress index ? kindly let me know b'coz i have also changed my code to SQL with bind vars just now. Regards, prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: Thomas, Kevin 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: OT : Apache version
You could just navigate to the directory it's stored in and it'll be all over the directory names. -Original Message- Sent: 09 July 2002 11:03 To: Multiple recipients of list ORACLE-L Hi Guru, Does anyone know how to find the apache vision in Unix ? Is pkginfo -i |grep -i apache the correct command to find the apache version ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Thomas, Kevin 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: Sql query
SELECT id ,name FROM table_a WHERE EXISTS ( SELECT id FROM table_b ); -Original Message- Sent: 26 June 2002 14:13 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Sql query
Ignore my message when it comes through...I gave you the opposite answer to the one you were looking for! ;o) -Original Message- Sent: 26 June 2002 14:13 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Sql query
Feckmy email to ignore this email arrived before this email didgo figure -Original Message- Sent: 26 June 2002 15:09 To: Multiple recipients of list ORACLE-L SELECT id ,name FROM table_a WHERE EXISTS ( SELECT id FROM table_b ); -Original Message- Sent: 26 June 2002 14:13 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Thomas, Kevin 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: test
very... -Original Message- Sent: 22 May 2002 12:43 To: Multiple recipients of list ORACLE-L Testing . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: [oracle-l-OT] Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A
BM? Bone massage? ROTFL -Original Message- Sent: 30 April 2002 14:13 To: Multiple recipients of list ORACLE-L A I'd say Tim is stuck in Buddhist nondoing-ness while simultaneously missing the point (It's the SageLogix server, STOOPID) and calling the kettle black (don't call me names from your playbook; instead denigrate via condecension and superciliousness) Brown? Maybe this guy needs a good, relaxing BM. And yea, virus scanning that works by blind, utter deletion is frustrating. But Eric, what about this guy's fucking humanity? Back into my cage, etc. -Original Message- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/29/2002 7:47 PM DIKHEAD You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphysical context of your astral plane. ORACLE-L Digest -- Volume 2002, Number 118 -- From: Tim Gorman [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim I don't know if this guy (Evans, David) is subscribed to this list, but if so, please tell your email admin that this stuff sucks. A text file attachment is not automatically equivalent to a virus attachment. If their system wasn't set up by such dikheads, they would know that they can implement packet scanning at the email gateway in a non-intrusive manner that is far more effective than this spam cr*pola. http://www.antivirus.com/products/isvw/ regards, ep Yahoo! Groups Sponsor -~-- Tied to your PC? Cut Loose and Stay connected with Yahoo! Mobile http://us.click.yahoo.com/QBCcSD/o1CEAA/yigFAA/o7folB/TM -~- To talk about oracle database issues: subscribe to [EMAIL PROTECTED] To do the offtopic(OT) thing. post here :) To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Thomas, Kevin 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: pl/sql
I suggest you give me the name of the company you work for and also some information on their current salary rates. Can you let me know when your position becomes available. ;o) -Original Message- Sent: 29 April 2002 15:54 To: Multiple recipients of list ORACLE-L Hallo, I have a package which includes 5 different procedures. I would like an exception which tells me an error message if any of the procedures fail. So if procedure 1 fails I would get an error message or if procedure number 2 would fail, or proc number 3 e tc then I would get an error message, which tells me which procedure that fails. I tried this, but didnt work. Just give me an easy example on this. I tried to look it up in the manual but didnt get it work. Should I put the exception after each procedureis finished. Like this: And should I name the exceptions in different ways, for instance givethem the names EXCEPTIONS1, EXCEPTIONS2 etc. p1 exception p2 exeption p3 exception p4 exception p5 exception Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Ms Access user forum
.! -Original Message- Sent: 26 April 2002 15:13 To: Multiple recipients of list ORACLE-L Hallo, any one whom knows how where to find a good MsAccess user forum where I can ask questions? Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Cronjob
Use vi. -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Brainbench Oracle certifications
I've got a few BB certifications, purely for my own benefit. It doesn't appear as if many employees (in the UK or Scotland anyway) appear to take them seriously. Kev. -Original Message- Sent: 12 April 2002 12:58 To: Multiple recipients of list ORACLE-L Never even heard of it. If it's a valid test (as in - if it measures what it purports to measure) then it's interesting, but if employers have never heard of it it's useless in that regard. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 11, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Subject:Re: Brainbench Oracle certifications One certain company (to remain nameless) is asking employees to obtain at least 4 Brainbench Certifications this year. And that company also uses Brainbench assessment tests for pre-employment screening. So there are certain employers taking advantage of Brainbench. But otherwise, I haven't found my Brainbench certifications to have much meaning to potential employers. Andrey Bronfin wrote: Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at all for it ? Thanks a lot in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Suzy Vordos 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Customize my SQLPlus login
I think you just need to create a script called login.sql in the same directory as you would run SQLPLUS from. Certainly on unix if you login to SQL from a directory that contains a file called login.sql it will process the commands contained within it. HTH Kev. -Original Message- Sent: 26 March 2002 13:38 To: Multiple recipients of list ORACLE-L What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Thomas, Kevin 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: A bit o/t - drinks all round
Congrats Mike! I'll have a Guinness ;o) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 12:03 To: Multiple recipients of list ORACLE-L Just passed my 9i OCP DBA exam. Now I have the whole set. =) For anyone who's interested these are thew resources I used : Oracle 9i New Features - Robert G Freeman ( but GET A SPELLCHECKER Bob! ) Oracle documentation set. Oracle 9i Daily Features articles (http://technet.oracle.com/products/oracle9i/daily/content.html) Oracle-Base 9i New Features Articles (http://www.oracle-base.com/Articles/9i/Articles9i.asp) Plenty of time to play with the database. Sorry this is WAY off topic but anyone who's read this far gets a virtual pseudo-beer. Cheers Mike Hately Now, who's going to offer me a job? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Hately, Choiceline IT Ltd. 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: Thomas, Kevin 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: Scrolling Sideways in SQL*Plus
Change the buffer width in the environment panel. That should do it. Cheers, Kev. -Original Message- Sent: 07 February 2002 11:08 To: Multiple recipients of list ORACLE-L Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: SQL Insert question
You could create a view across these two tables to give you the info you need. Cheers, Kev. -Original Message- Sent: 07 February 2002 14:29 To: Multiple recipients of list ORACLE-L Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table between softwares and licences cols= id, licence_id, software_id i want to populate this table with the ids from softwares and licences, so that if joined together 1 row would reflect a row in the old table sierras. What query can i write for this?? hope all that makes sense! regards IA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: storedProc question
Sameer, What op system are you running with? There is a utility that was posted a few days ago by me that allows you to run any os command from pl/sql as well as sqlplus. I'll try and find the original email I sent out. Cheers, Kev. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 06 February 2002 03:30 To: Multiple recipients of list ORACLE-L Hi all, Is there anyway that i can issue OS related command e.g. rename a file from storedProc. i know is sounds weird, but can we do it. (not HOST command which is specific to sqlplus) any help is appreciated thx sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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: Thomas, Kevin 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).
OT: RE: Email address change
ROTFL.did anyone else receive this TWICE???!!! ;o) -Original Message- Sent: 02 February 2002 12:05 To: Multiple recipients of list ORACLE-L Patrick Housholder's email has been changed to [EMAIL PROTECTED] Please make note of it. This message will only be sent once. [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: How to find out what caused job to fail?
(silence) -Original Message- Sent: 04 February 2002 10:05 To: Multiple recipients of list ORACLE-L Here we go again !!! -Original Message- Sent: 04 February 2002 09:36 To: Multiple recipients of list ORACLE-L But how do I use the alert log and where canI find the trace file? Roland [EMAIL PROTECTED]@fatcity.com den 2002-02-04 01:05 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, you can find the reason in alert log or trace files. -Original Message- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Subject: How to find out what caused job to fail? Hi! Is there a way to find out, why a database job failed? in dba_jobs (or user_jobs), I can only see that it failed, but no indication of the reason why it failed. Any ideas? This is 8.1.7 on Solaris. Thanks, Helmut -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Thomas, Kevin 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: sending email via pl/ sql using query
Suhen, You should be able to pass in the values returned from your query as a 'variable' to the utl_smtp.write_data command. I've used an example from the asktom.oracle.com website ( http://asktom.oracle.com/pls/ask/f?p=4950:8:457115::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:2118740358226,%7Butl_smtp%7D http://asktom.oracle.com/pls/ask/f?p=4950:8:457115::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:2118740358226,%7Butl_smtp%7D ) and added my own bits to it. Hopefully it makes sense, if not try the website...for more info. So for example: create or replace procedure send_mail as CURSOR c_query SELECT data FROM table; l_mailhost varchar2(255) := '10.228.1.75' ; l_mail_conn utl_smtp.connection ; l_message VARCHAR2(n) := 'This mail has been automatically generated by...'; -- for example begin -- Open the cursor in a for loop -- this enables you to build up your l_message variable -- to contain all the data you want to send. -- Of course, you can add more in to this to add static information -- such as l_message could initially contain an opening line like -- 'This mail has been automatically generated by...' and then -- you just build up the rest of the message like so, below...I think! -- FOR r_query IN c_query LOOP l_message := l_message || CHR(13) || r_query.data_element; END LOOP; l_mail_conn := utl_smtp.open_connection(l_mailhost, 25) ; utl_smtp.helo(l_mail_conn, l_mailhost) ; utl_smtp.mail(l_mail_conn, p_sender) ; utl_smtp.rcpt(l_mail_conn, p_recipient ) ; utl_smtp.open_data(l_mail_conn) ; utl_smtp.write_data(l_mail_conn, p_message ) ; utl_smtp.close_data(l_mail_conn) ; utl_smtp.quit(l_mail_conn ); dbms_output.put_line('Message send to the user successfully') ; end ; Hope this helps, Cheers, Kev. my computer beat me at chess but I won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 01 February 2002 03:25 To: Multiple recipients of list ORACLE-L List, I am trying to send email from Oracle when a table is updated. The message must be a dynamic one, so hard coded message will not be allowed. I have created a trigger when the table is updated - that works I am using UTL_SMTP to send emails. - that works However this procedure (send_mail) only has hard-coded messages. - I need it to be a dynamic message, from a query which I already have. The query will return more than 1 row. - So the trigger executes when a column is updated. - A query would be executed giving the required information to be mailed. - email program must kick off, emailing the results of the above query. Any ideas how to do this. Thanks Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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 Book
Hamid, I use the Unix in a nutshell by O'Reilly (ISBN 1-56592-427-4). It pretty much covers all of the basics. Cheers, Kev. -Original Message- Sent: 01 February 2002 16:16 To: Multiple recipients of list ORACLE-L Hi, Anybody knows any good book for Unix Beginner people, If yes Please let me know I really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Thomas, Kevin 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: RTFM questions (formally RE: PL/SQL)
:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Sam Roberts 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: JoJo Al-Zawawi 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: Glenn Travis 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: JoJo Al-Zawawi 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: Thomas, Kevin 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
RE: Pl/sql - shell script
Roland, Please see the example I posted some time ago to this list. I'm sure Sam Roberts will be able to point you in the direction of it. Failing that please see. Date: Tue, 11 Sep 2001 07:20:24 -0700 Hi Roland, Yes it is possible, I have got a piece of code that I got from the site asktom.oracle.com, that allows you to send Unix commands to the shell from within SQL. I'm making the assumption that it's a Unix environment you want to make the call within? If it is, give me a shout and I'll let you have the code... Regards, Kev. A message I sent to you in September last year. And please refer to the page on this mailing list archive site http://www.mail-archive.com/oracle-l@fatcity.com/msg24301.html where I give the code and explain it's usage. Regards. Kev. -Original Message- Sent: 30 January 2002 08:41 To: Multiple recipients of list ORACLE-L Hallo, is there anyone who can tell me if it ispossible run unix shell script from PL/SQL Anyone who has a good example too that I can use. Thanks in advance. Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: RTFM questions (formally RE: PL/SQL)
Don't stop posting. I'm not a DBA either. Don't have any intention of being one. I'm an Oracle duhveloper (as people sometimes point out..LOL). I read this list to get a better understanding of how databases 'hang together'. I never profess to being an expert in DBA related stuff...I'm far, far from that. -Original Message- Sent: 29 January 2002 22:29 To: Multiple recipients of list ORACLE-L Thank you all for your kind replies, and I now definitely know the correct answer to this. Please let me reiterate that I am *not* yet an Oracle dba. I've only been to one class so far, for crying out loud! Obviously it would be better for me to just not post for a while, in any event. No need to keep on responding to this thread. Cheers, JoJo -Original Message- Walt Sent: Tuesday, January 29, 2002 1:46 PM To: Multiple recipients of list ORACLE-L I strongly suggest you not experiment with this on your production database. --Walt -Original Message- Sent: Tuesday, January 29, 2002 1:16 PM To: Multiple recipients of list ORACLE-L I'm a complete newbie, so I may be off-base here, but I believe that truncating a table does not delete any data from the table. It moves the cursor up, thereby closing up the empty space where data has previously been deleted. --JoJo -Original Message- Sent: Tuesday, January 29, 2002 10:46 AM To: Multiple recipients of list ORACLE-L To our resident Oracle Expert who just 6 months (July 26 2001) ago posted the following e-mail If I remember rightly, deleting rows from the table does NOT free up tablespace. In order to do that you have to trunctate the table (although this of course deletes all data from the table)...I can't for the life of me remember how you adjust the space the table is actually using after doing a delete...(to everyone else) would an analyze work? Kev. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: JoJo Al-Zawawi 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: Thomas, Kevin 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: OT: RTFM questions (formally RE: PL/SQL)
. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Sam Roberts 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: Thomas, Kevin 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: OT: RTFM questions (formally RE: PL/SQL)
the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Sam Roberts 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: Thomas, Kevin 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: Thomas, Kevin 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: SQL Loader error
Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Performance Tuning
Binay, The Oracle Performance Tuning book from O'Reilly (ISBN 1-56592-237-9) is an excellent book. Covers just about everything, database, code, environment tuning. Regards, Kev. -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: SQL Loader error
If I remember right, SQL*LOADER has (or used to have) a maximum field size of 256 characters. This can be overcome by specifying the size you want to load like: LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', comments CHAR(xxx) terminated by ',' OPTIONALLY ENCLOSED BY '' ) Where xxx is the size of the field in the table you are trying to load into. Regards, Kev. -Original Message- Sent: 30 January 2002 12:11 To: Multiple recipients of list ORACLE-L heres the ctl LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', commentsterminated by ',' OPTIONALLY ENCLOSED BY '') dat file looks something like: aer100,customer's wish to cancel aer200,etc. Thomas, Kevin [EMAIL PROTECTED]@fatcity.com on 30/01/2002 11:25:34 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Could you post the control file? Kev. -Original Message- Sent: 30 January 2002 09:15 To: Multiple recipients of list ORACLE-L i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Unbreakable Oracle - Metaslink
It was up and running earlier on (8am-1pm GMT) -Original Message- Sent: 30 January 2002 13:15 To: Multiple recipients of list ORACLE-L Seems to be down this morning must be the flu ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: RTFM questions (formally RE: PL/SQL)
Amen! -Original Message- Sent: 29 January 2002 06:20 To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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).
OFF TOPIC: RE: PL/SQL
When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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: PL/SQL
because DUDE! see my earlier explanation! I ask colleagues if I can't find it in the manual...such is the joy of the internet...the pages are bookmarked and are therein front...on my screenwhere I need them! It's not rocket science! -Original Message- Sent: 29 January 2002 03:55 To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: OFF TOPIC: RE: PL/SQL
LOL...where's me soapbox!! I'm having a bad week, and hot-dang if everyone else ain't gonna suffer to!! ;o) TFIC! -Original Message- Sent: 29 January 2002 14:50 To: Multiple recipients of list ORACLE-L Kevin, I am sorry, but you didn't sound holier than thou on that last post. Could you do it a bit differently next time? ;-) WWJD? JWRTFM! -Original Message- Sent: Tuesday, January 29, 2002 9:10 AM To: Multiple recipients of list ORACLE-L Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Seefelt, Beth 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: Thomas, Kevin 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
RE: RTFM questions (formally RE: PL/SQL)
Seriously though... You would of course get as much help as the next person here and I don't think it's out of place for me to say that newbies are always welcome! But it starts to get ridiculous when a poster continually posts questions that can be found on websites similar to your own without having to a) bother writing an email and b) waiting on a reply. The number of posts that can come from one person and be classed as just newbie questions, is finite, after a period of time, that individual can no longer be classed as a newbie! PLUS the fact that we more or less write the goddam applications for these people, why don't they just hire us!!!??? :o| -Original Message- Sent: 29 January 2002 15:41 To: Multiple recipients of list ORACLE-L No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going boy are you stupid / lazy. I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message- Sent: Monday, January 28, 2002 10:20 PM To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: RTFM questions (formally RE: PL/SQL)
And your point caller?? TIC ;o) -Original Message- Sent: 29 January 2002 15:41 To: Multiple recipients of list ORACLE-L No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going boy are you stupid / lazy. I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message- Sent: Monday, January 28, 2002 10:20 PM To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Pl/sql question
Hi Roland, Best way to do this is just set some variables at the start of your code: l_proc_start := sysdate; l_proc_name := 'proc_name'; begin ...commands... exception when exception then l_proc_end := sysdate; SELECT count(*) INTO l_ins_count FROM table being inserted to; INSERT INTO error_table ( proc_name ,proc_start ,proc_end ,proc_count ,proc_err ,proc_err_msg ) VALUES ( l_proc_name ,l_proc_start ,l_proc_end ,l_ins_count ,sqlcode ,sqlerrm ); COMMIT; END; -Original Message- Sent: 28 January 2002 08:40 To: Multiple recipients of list ORACLE-L Hallo, anyone who canhelp me with this? I have PL/sql procedure and if something goes wrong I would like the following things to occur. Please help me with them If some errors occur I want this to happen. - pick out the name of the procedure thatis currently running, -pick out the start_time of the procedure - pick outthe end_time of the procedure when it fails - pick out the number of rows that were inserted inthe insertstatement inthe procedure. - The error code _Th errormessage All these things I want to be inserted in a table. Give me a good example on how to write the code, please. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Pl/sql question
Yea more elegant if you happen to be running Oracle 8.something which unfortunately we're not!! ;o) -Original Message- Sent: 28 January 2002 11:30 To: Multiple recipients of list ORACLE-L Just a note Inserting in an error table in the excpetion clause is a common problem because if something goes wrong and exception was thrown then You usually don't want commit But You cannot insert ereror record without commit So in ancient times there was dbms_pipe etc. Since 8.something You can use autonomous transactions instead, I think it is more elegant solution Gints Plivna IT Sistçmas, MerÃeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Thomas, Kevin Kevin.Thomas@cal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anais.com cc: Sent by:Subject: RE: Pl/sql question [EMAIL PROTECTED] 2002.01.28 11:20 Please respond to ORACLE-L Hi Roland, Best way to do this is just set some variables at the start of your code: l_proc_start := sysdate; l_proc_name := 'proc_name'; begin ...commands... exception when exception then l_proc_end := sysdate; SELECT count(*) INTO l_ins_count FROM table being inserted to; INSERT INTO error_table ( proc_name ,proc_start ,proc_end ,proc_count ,proc_err ,proc_err_msg ) VALUES ( l_proc_name ,l_proc_start ,l_proc_end ,l_ins_count ,sqlcode ,sqlerrm ); COMMIT; END; -Original Message- Sent: 28 January 2002 08:40 To: Multiple recipients of list ORACLE-L Hallo, anyone who canhelp me with this? I have PL/sql procedure and if something goes wrong I would like the following things to occur. Please help me with them If some errors occur I want this to happen. - pick out the name of the procedure thatis currently running, -pick out the start_time of the procedure - pick outthe end_time of the procedure when it fails - pick out the number of rows that were inserted inthe insertstatement inthe procedure. - The error code _Th errormessage All these things I want to be inserted in a table. Give me a good example on how to write the code, please. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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
RE: Unix script
Do some research man!! This stuff isn't hard to find...sheesh!! -Original Message- Sent: 28 January 2002 14:31 To: Multiple recipients of list ORACLE-L Hallo, I have this unix script. I would like to include code which checks if the oracle database is up and running so the procedure konto.fillbotables.anrop doesnt start at all.. I also want an errorlog file to be created. Please tell me how to write the code and where to include it in this shell script. #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl log=/d31/appl/konto/log/ehbgrupp.log sqlplus -s konto/icakort ! set heading off set verify off set feedback off set termout off set pages 0 begin konto.fillbilbotables.anrop; END; / EXIT Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: PL/SQL
RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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 - script
Roland, Try this by setting up environment variables at the top of your script: SERVER1= 10.10.10.10 USER1= 'xxx' PWD1= 'xxx' SERVER2= 10.10.10.20 USER1= 'yyy' PWD2= '' Then have this: ftp -i -n EOF open $SERVER1 user $USER1 $PWD1 cd scripts get file close EOF You can then have a section like the one below if you want to copy to a different server other than the one you are running this script from: ftp -i -n EOF open $SERVER2 user $USER2 $PWD2 cd scripts put file close EOF Both of these can be included in the one shell script. Hope that helps. Kev. 'In Windows no one can hear you scream' __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 09 January 2002 07:16 To: Multiple recipients of list ORACLE-L Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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 - script
Forgot to mention, the 'cd scripts' line in both examples is not required, it's just been left in from the script I copied. oops! K. -Original Message- Sent: 09 January 2002 08:20 To: Multiple recipients of list ORACLE-L Roland, Try this by setting up environment variables at the top of your script: SERVER1= 10.10.10.10 USER1= 'xxx' PWD1= 'xxx' SERVER2= 10.10.10.20 USER1= 'yyy' PWD2= '' Then have this: ftp -i -n EOF open $SERVER1 user $USER1 $PWD1 cd scripts get file close EOF You can then have a section like the one below if you want to copy to a different server other than the one you are running this script from: ftp -i -n EOF open $SERVER2 user $USER2 $PWD2 cd scripts put file close EOF Both of these can be included in the one shell script. Hope that helps. Kev. 'In Windows no one can hear you scream' __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 09 January 2002 07:16 To: Multiple recipients of list ORACLE-L Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Thomas, Kevin 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 - script
Yip, never thought of that one ;o) -Original Message- Sent: 09 January 2002 10:55 To: Multiple recipients of list ORACLE-L It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc Mike From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Unix - script Date: Wed, 09 Jan 2002 00:35:23 -0800 Forgot to mention, the 'cd scripts' line in both examples is not required, it's just been left in from the script I copied. oops! K. -Original Message- Sent: 09 January 2002 08:20 To: Multiple recipients of list ORACLE-L Roland, Try this by setting up environment variables at the top of your script: SERVER1= 10.10.10.10 USER1= 'xxx' PWD1= 'xxx' SERVER2= 10.10.10.20 USER1= 'yyy' PWD2= '' Then have this: ftp -i -n EOF open $SERVER1 user $USER1 $PWD1 cd scripts get file close EOF You can then have a section like the one below if you want to copy to a different server other than the one you are running this script from: ftp -i -n EOF open $SERVER2 user $USER2 $PWD2 cd scripts put file close EOF Both of these can be included in the one shell script. Hope that helps. Kev. 'In Windows no one can hear you scream' __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 09 January 2002 07:16 To: Multiple recipients of list ORACLE-L Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Thomas, Kevin 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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: Thomas, Kevin 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
RE: java stored procedures and running rsh command
Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on the server your COMING from if that makes any sense. Is this correct? Cheers, Kev. 'In Windows none can hear you scream' -Original Message- Sent: 09 January 2002 15:12 To: Multiple recipients of list ORACLE-L You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients of list ORACLE-L I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Kimberly Smith 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: Thomas, Kevin 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: Calling Host
This is something that has appeared on this list a few times. If you check the archives, I posted an explanation on how to do this using a couple of shell scripts and a stored procedure. Regards, Kev. -Original Message- Sent: 17 December 2001 20:35 To: Multiple recipients of list ORACLE-L Hi Listers, Can we call operating system command from store procedure or trigger ? I have created the following simple store procedure : CREATE OR REPLACE PROCEDURE PROCTES is begin HOST('ls'); end; But I got the error : Line # = 3 Column # = 6 Error Text = PLS-00201: identifier 'LS' must be declared Line # = 3 Column # = 1 Error Text = PL/SQL: Statement ignored Thanks for any clue. Aldi _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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: Thomas, Kevin 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: Anybody have an opinion on!
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: Thomas, Kevin 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: Mark Leith 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: Thomas, Kevin 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: Anybody have an opinion on!
Hey Mark, What is the cost for licensing on this product? K. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 12 December 2001 15:15 To: Multiple recipients of list ORACLE-L Hi Dick, My opinion on this tool is extremely high - considering it is in fact not a competitor, but one of the tools we sell :) You won't find it listed on our web site, though it's sister tool (SQLExpert) is listed. My personal opinion is that there is no other tool in the market place that can rival what SQL/DBExpert can provide! Even *after* looking at the competition in depth at the UKOUG on Monday. To give you an idea of what it does: Harvest your SQL / PL/SQL code from the system you are interested in (either from memory, source code, binary files etc.. through a scan or SQL monitor) then submit it to the optimisation engine - which will re-write the SQL statement in as many, semantically equivalent, statements as is possible to return the same output. It will then scan this new set of statements, and show you all of those with alternate execution plans, run them through a batch process to find those with better response/elapsed times, and bingo you have a fully tuned statement. No other tool in the market will actually do this - they add the major hints and alike, and tell you to analyse, or create indexes etc.. I've seen SQLExpert take a SQL statement that did a select from a view, rewrite the view in to the actual statement against the underlying tables, and come back with a 40-45% improvement on response times! It also handles PL/SQL debugging, stored outlines etc. It's priced on a per client basis, so you don't have to buy a license for every instance/server that you want to tune, and it's easy to install and use. To sum up - if you want a SQL *optimisation* tool, then go with SQL/DBExpert! We only sell what we consider to be best of breed tools that are in the market place, as long as they are easy to install/use, and reasonably priced. SQLExpert fitted the bill for us, and it is going down VERY well in the UK market place! There is plenty of info on both leccotech.com, and cool-tools.co.uk for the tools, but if you want any further info, give me a shout direct and I'll see if I can answer any further questions that you have. Regards Mark -Original Message- [EMAIL PROTECTED] Sent: 12 December 2001 13:00 To: Multiple recipients of list ORACLE-L Folks, I found an e-mail in my inbox this morning from my boss about a product called Lecco DB Expert(http://www.leccotech.com/). Anybody ever use this one or have an opinion? Mark, Since this is a competitor to Cool-Tools your welcome to get up on the soap box. Dick Goulet -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Thomas, Kevin 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: DBA Weakest Link
LMAO.. ;o) -Original Message- Sent: 07 December 2001 15:05 To: Multiple recipients of list ORACLE-L Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee 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: Igor Neyman 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: Thomas, Kevin 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 mailing List
I think what you want to do is if [ -d $FILENAME ] then echo the file exists else echo file not found fi $FILENAME is a variable holding the name of the file you are looking for. You can assign a value to it by doing: FILENAME='/tmp/myfile.txt' before the if statement. Regards, Kev. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 05 December 2001 08:10 To: Multiple recipients of list ORACLE-L Hi all, Can someone recommend good unix mailing list by the way how to check the existence of a file ? My logic : if (findThisFile(/tmp/myfile.txt) == 0) echo the file is exists else echo file not found endif what is the unix function for findThisFile() Thank you, Sinardy Hoping Peace in Middle East and the rest of the World -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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: Thomas, Kevin 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 mailing List
Apologies for the last replythe [ -d $FILENAME ] should be [ -a $FILENAME ]. Hope that helps, Cheers, Kev. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 05 December 2001 08:10 To: Multiple recipients of list ORACLE-L Hi all, Can someone recommend good unix mailing list by the way how to check the existence of a file ? My logic : if (findThisFile(/tmp/myfile.txt) == 0) echo the file is exists else echo file not found endif what is the unix function for findThisFile() Thank you, Sinardy Hoping Peace in Middle East and the rest of the World -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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: Thomas, Kevin 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: Update query
SELECT a.sql_basics ,b.chapter3 FROM bookshelf ,b.book WHERE b.chapter3 = 'basic sql constructs' AND a.sql_basics = 'book that should be read before posting requests like this'; ;o) -Original Message- Sent: 05 December 2001 09:55 To: Multiple recipients of list ORACLE-L Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Update query
And yea, I got the syntax wrong ;o)) Don't point it out to methe bad day continues... -Original Message- Sent: 05 December 2001 11:25 To: '[EMAIL PROTECTED]' Importance: High SELECT a.sql_basics ,b.chapter3 FROM bookshelf ,b.book WHERE b.chapter3 = 'basic sql constructs' AND a.sql_basics = 'book that should be read before posting requests like this'; ;o) -Original Message- Sent: 05 December 2001 09:55 To: Multiple recipients of list ORACLE-L Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: UTL_FILE_DIR problem
if I set UTL_FILE_DIR = * would there be any security issue ? In a word yes...this allows read/write access to *all* directories and there is bound to be particular ones you don't want people to see. -Original Message- Sent: 03 December 2001 11:40 To: Multiple recipients of list ORACLE-L Hi all, I got one problem about UTL_FILE_DIR. My oracle version is 8i 8.1.6 Platform is unix sun solaris. I have set UTL_FILE_DIR to : /customer/ShopA and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA When I execute the PL/SQL job through SQLPLUS, I hit error message saying that I can't write to the directory. the /customer/ShopA directory permission is set to 664. Let's say owner is A, and the group is A1 Can I tell the program to access the directory and write to the file as another user ? If I'm not wrong, the program will try to write into the directory using oracle unix account. Note : I don't want to set the write permission to other group. I have tried to include oracle in A1 group using secondary group, but it couldn't work. Can somebody tell me how to let oracle write into the directory and the file as well without changing the directory / file permission. if I set UTL_FILE_DIR = * would there be any security issue ? Any help will be greatly appreciated. Thanks Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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: Thomas, Kevin 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: Crontabs and Oracle
Thanks David, and everyone else for all your help. Unfortunately, I've done all this, specifying the variables etc and it still doesn't appear to like it much! I don't know whether it's because it's written in the CSH and not for KSH...I'll keep looking. Thanks again, Kev. Some mornings it just doesn't seem worth it to gnaw through the leather straps. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 21:21 To: Multiple recipients of list ORACLE-L Thomas, I got called to task before on this, but I didn't save the note, so whoever corrected me, please do so again. In any case, cron jobs in UNIX are (and this is where I was corrected - although what follows should solve your problem) executed by root. This is why Mike suggested running the .profile to properly set up the environment to find and execute sqlplus. The user who owns the cron job is invoked by root without all the proper environmental variables set. As an alternative you can explicitly set your variables at the beginning of the shell script as follows (for ksh): #!/bin/ksh export ORACLE_SID=ifas export ORACLE_HOME=/u001/app/oracle/product/8.1.7 export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin export ORACLE_BASE=/u001/app/oracle export HOME=$ORACLE_HOME cd $HOME Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Thomas, Kevin Kevin.Thomas@cal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anais.com cc: Sent by:Subject: Crontabs and Oracle [EMAIL PROTECTED] 11/28/2001 05:00 AM Please respond to ORACLE-L Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use
RE: Longest SQL statements!!!
I would have just thought that it would be exceptionally inefficient and more practical to divide it into chunks or procedures. More easily maintained etc. -Original Message- Sent: 28 November 2001 17:22 To: Multiple recipients of list ORACLE-L Are there any implications on how long the SQL statement is? The current SQL statements that I am inheritting, is really long. tons of embedded sub queries etc. My first question is are there any known issues with haveing very long SQL statements and if yes what has been a good length other than the fact that it may depend on your SGA. Thanks Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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: Thomas, Kevin 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).
Crontabs and Oracle
Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: [EMAIL PROTECTED] To: apt2 Content-Length: 143 Your cron job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. I put instant coffee in a microwave oven and almost went back in time. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram kumanan.balasundara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, London W6 9EJ Registered in England No 3430894 VAT number - GB 701 8915 43 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Crontabs and Oracle
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Thomas, Kevin 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). This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: who execute scripts in Win NT like Unix!!
Alex, echo spool output.lis sql_file.sql echo SELECT s.sid, sql_file.sql echos.serial#, sql_file.sql echop.pid, sql_file.sql echop.spid, sql_file.sql echos.osuser,sql_file.sql echos.machine, sql_file.sql echos.programsql_file.sql echo FROM v$session s, v$process p sql_file.sql echo WHERE p.addr = s.paddr sql_file.sql echoAND s.schemaname 'SYS'sql_file.sql echo ORDER BY p.spid,s.sid, p.pid, p.spid; sql_file.sql echo exit sql_file.sql echo spool off sql_file.sql sqlplus dbvision/dbvision@t_nhspint @sql_file.sql Put the above commands into a DOS batch file and then run it...you can add in things like SET LINESIZE etc...just the same way as the spool command is written. Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 13 November 2001 23:00 To: Multiple recipients of list ORACLE-L Hi gurus!!! I need execute any scripts in win nt like oracle in unix!!! example: sqlplus user/password fin SELECT s.sid, s.serial#, p.pid, p.spid, s.osuser, s.machine, s.program FROM v\$session s, v\$process p WHERE p.addr = s.paddr AND s.schemaname 'SYS' ORDER BY p.spid,s.sid, p.pid, p.spid; fin @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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: Thomas, Kevin 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: ok..this is funny.. how do you pronounce tuple
Kindof like tooyoupull only different...! ;o) -Original Message- Sent: 14 November 2001 11:05 To: Multiple recipients of list ORACLE-L Yeah - kind of like too-you-pull but a lot quicker.. -Original Message- Lee - lerobe Sent: 14 November 2001 08:30 To: Multiple recipients of list ORACLE-L Hmm, dilemma - neither tyu pul Mainly because thats what my Ingres Course Instructor used in class, many, many years ago. Lee -Original Message- Sent: 14 November 2001 04:55 To: Multiple recipients of list ORACLE-L Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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: Thomas, Kevin 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: Sqlloader
It looks like you have a ' missing check ,'98'!', there is one too few. Cheers, Kev. -Original Message- Sent: 13 November 2001 15:20 To: Multiple recipients of list ORACLE-L Why does this sqlloader ctl file giveme this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S Mercadante, Thomas F [EMAIL PROTECTED]@fatcity.com den 2001-11-13 05:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi Roland, Try using the DECODE statement rather than TRANSLATE: BUT_OMS DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS), The above says: Ifthe value of BUT_OMS='!', change it to '99', elsif the value of BUT_OMS='?', change it to 'No Info', else insert the value provided. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 3:00 AM To: Multiple recipients of list ORACLE-L Hallo all you DBA's How do I write in sqlloader if i want to replace, translate the caracter ? with 'No info' and the character ! with the value '99'. I have this statement already. BUT_OMS TRANSLATE(:BUT_OMS, '!','99'), Thanks in advance Roland S -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: OT : linux flavors
I have to say I use Redhat 7.0 and apart from being a tad over-engineered it's relatively simple to setup. The only problem I encountered was getting the X environment setup (LCD monitor with GeForce card). You get a lot for your money with RedHat and plenty of training courses too. (Although you pay for that through the nose if you go to RedHat!!)... K. -Original Message- Sent: 08 November 2001 17:08 To: Multiple recipients of list ORACLE-L For starters, I'd recomend redhat, it's quite friendly. HTH --Yohans On Thu, 8 Nov 2001, Andrey Bronfin wrote: Dear list ! I've got a question that i realize has no correct answer. I want to install Linux at home on my lousy PC. I have NO-WHATSOEVER experience with Linux , although have some knowledge of Solaris HP-UX. I want to pick up a linux flavor that is : 1) Pretty frequently used one , so i can get tutorials , and there are many experienced users to ask questions , and many answers can be found on the web. 2) Closest one to Solaris (or HP-UX or other big UNIX) . 3) Can run on a PC with little memeory . Than U very much in advance for your time. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yohans Mendoza 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: Thomas, Kevin 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: Concealing SQL Loader password from ps -ef
Jay, Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now that I've found someone that knows ;o) Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 17:56 To: Multiple recipients of list ORACLE-L When running Sql Loader from a Unix script is there a way to code it so that the password will not be displayed when someone does ps -ef? I know how to do it for sqlplus, exp and imp but not sql loader. TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Thomas, Kevin 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: Oracle Reports....
Ah, right! Ok, thanks for that Rachel, I'll have a nosey at them today... ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 17:56 To: Multiple recipients of list ORACLE-L Ah but Kevin, that info stays around even if they are not running the report at that second. so you can do a search in the tables and look for sql that references the tables that have the reporting data in them. won't get you EVERYTHING you need, but it will take you at least one step closer --- Thomas, Kevin [EMAIL PROTECTED] wrote: Thanks Rachel, I'll check these tables to see what dets they hold. The problem I have is that I can't phone the user and say are you running that report, because they have a big nasty lady who will come and bite my head off if she thinks we're actually trying to help!! ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 14:35 To: Multiple recipients of list ORACLE-L you should be able to pull the queries out of v$sql, v$sqlarea and/or v$sqltext --- Thomas, Kevin [EMAIL PROTECTED] wrote: Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, in that the queries contained in them have an average hit rate of less than 2%!!! Guess what, it get's better, they don't have the source code anymore!! Is there a way of either a) re-engineering the executable, or b) a third party tool that will extract the queries or show the report in a text version (?!?). Any thoughts guru-type-people ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Thomas, Kevin 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!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: Oracle Reports....
Thanks Raj, Part of the problem is we don't know what queries actually belong to which report (because the source is missing) and there are probably about 150+ users of this particular system at anytime running queries from SQL, FORMS or REPORTS. Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 19:11 To: Multiple recipients of list ORACLE-L Give a try by tracing the session used by the report. -Original Message- Sent: 25 October 2001 16:05 To: Multiple recipients of list ORACLE-L Thanks Rachel, I'll check these tables to see what dets they hold. The problem I have is that I can't phone the user and say are you running that report, because they have a big nasty lady who will come and bite my head off if she thinks we're actually trying to help!! ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 14:35 To: Multiple recipients of list ORACLE-L you should be able to pull the queries out of v$sql, v$sqlarea and/or v$sqltext --- Thomas, Kevin [EMAIL PROTECTED] wrote: Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, in that the queries contained in them have an average hit rate of less than 2%!!! Guess what, it get's better, they don't have the source code anymore!! Is there a way of either a) re-engineering the executable, or b) a third party tool that will extract the queries or show the report in a text version (?!?). Any thoughts guru-type-people ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Thomas, Kevin 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: Raj Gopalan 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: Instance Name in Sql Prompt
There is a way of changing the prompt when doing a connect, however it's done by running a script called connect. So instead of the usual: SQL connect user/pass@sid You would do: SQL @connect user/pass@sid Try this URL: http://asktom.oracle.com/pls/ask/f?p=4950:8:214627::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:928829365838,%7Bsqlprompt%7D http://asktom.oracle.com/pls/ask/f?p=4950:8:214627::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:928829365838,%7Bsqlprompt%7D Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 25 October 2001 21:15 To: Multiple recipients of list ORACLE-L Thanks to Kevin and all that reply. I noticed when doing a connect inside a session. This will help. Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Dominican Republic 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Kevin Lange Enviado el: Thursday, 25 October, 2001 11:10 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Instance Name in Sql Prompt Ramon; In your startup directory on SQL Plus, you can automatically run a script that will setup the environment like you want it. Its called LOGIN.SQL. Here is a copy of mine: set termout on set pagesize 0 set echo off set feedback off set sqlprompt '' spool c:\temp.sql select 'set sqlprompt '''||name||' '';' from v$database; spool off @c:\temp.sql set pagesize 35 set feedback on set termout off What this does is to take the name of the database from v$database and create a temporary SQL file, then runs it. This will set my prompt to INSTANCE_NAME where INSTANCE_NAME is the name of the database. For example, if I log onto DEV then the SQLPROMPT will be DEV Hope you can use it. Kevin p.s. ... Remember that this only works for the initialization of SQL Plus. If you do a connect inside of your session then the prompt will not change. -Original Message- Sent: Thursday, October 25, 2001 9:35 AM To: Multiple recipients of list ORACLE-L Hi Friends, Excuse me for this dumb question, how do I display the instance name in the sql prompt. Have 3 DB and would like to know to which one I am connected. I mean something like that. DBA1 DBA2 DB01 Regards, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Dominican Republic 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Oracle Reports....
Mark, Yip, this sounds like a plan. As I mentioned earlier though, I don't want to awaken the Kracken! So being sneaky and trying to get the reports is key. As they are the client, I don't actually have access to any of there servers that they hold the reports on, or acccess to PVCS (not that I think they would actually have them in PVCS!!). Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 26 October 2001 11:20 To: Multiple recipients of list ORACLE-L Kevin, Can you not log in as a user yourself and run the reports that you are interested in, then trace your own session to see what SQL is being executed? What I would do: 1) As the report user, run the report you are interested in. 2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your particular session. 2b) set a SQL trace up for your own session, and record what order you ran the reports in, and try to match this up with the SQL in your trace file. Think this will work? Mark -Original Message- Kevin Sent: Friday, October 26, 2001 09:45 To: Multiple recipients of list ORACLE-L Thanks Raj, Part of the problem is we don't know what queries actually belong to which report (because the source is missing) and there are probably about 150+ users of this particular system at anytime running queries from SQL, FORMS or REPORTS. Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 19:11 To: Multiple recipients of list ORACLE-L Give a try by tracing the session used by the report. -Original Message- Sent: 25 October 2001 16:05 To: Multiple recipients of list ORACLE-L Thanks Rachel, I'll check these tables to see what dets they hold. The problem I have is that I can't phone the user and say are you running that report, because they have a big nasty lady who will come and bite my head off if she thinks we're actually trying to help!! ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 14:35 To: Multiple recipients of list ORACLE-L you should be able to pull the queries out of v$sql, v$sqlarea and/or v$sqltext --- Thomas, Kevin [EMAIL PROTECTED] wrote: Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, in that the queries contained in them have an average hit rate of less than 2%!!! Guess what, it get's better, they don't have the source code anymore!! Is there a way of either a) re-engineering the executable, or b) a third party tool that will extract the queries or show the report in a text version (?!?). Any thoughts guru-type-people ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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 Reports....
Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, in that the queries contained in them have an average hit rate of less than 2%!!! Guess what, it get's better, they don't have the source code anymore!! Is there a way of either a) re-engineering the executable, or b) a third party tool that will extract the queries or show the report in a text version (?!?). Any thoughts guru-type-people ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Oracle Reports....
Thanks Amar, I was afraid of that. I'm not too concerned with getting the report from .REP to .RDF, but being able to get any of the query information out of the .REP would be a good start. Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 25 October 2001 14:00 To: Multiple recipients of list ORACLE-L Not having the source code is a handycap situation. If you don't have .RDF, the executable .REP will not be of much help. Afaik, converting .REP to .RDF is not possible. So the only solution as I see it is rebuilding the concerned reports! rgds amar -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, October 25, 2001 3:20 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Instance Name in Sql Prompt
Hi Ramon, You could put this into your login.sql script if you have one. This will automatically take your login name and database and set your sqlprompt accordingly. col user_name new_value user_name col db_name new_value db_name select lower(user) user_name, ltrim(rtrim(lower(global_name))) db_name from global_name; set sqlprompt user_name@db_name HTH Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 25 October 2001 15:35 To: Multiple recipients of list ORACLE-L Hi Friends, Excuse me for this dumb question, how do I display the instance name in the sql prompt. Have 3 DB and would like to know to which one I am connected. I mean something like that. DBA1 DBA2 DB01 Regards, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Dominican Republic 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Code to Validate email addresses
Quite tricky this one...I would imagine there will be a few combinations for valid email addresses, you could try looking at the World Wide Web Consortium page www.w3.org, or some similar site for the standards documents. HTH Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 24 October 2001 14:15 To: Multiple recipients of list ORACLE-L Hi, We have implemented a form that emails reports. The user has to enter his email address. However, we are finding that a lot of users are entering incorrect and invalid email addresses. Obviously, we can do nothing if they enter an incorrect (but syntactically correct) email address. What I am looking for is: 1) A definition of the syntactically correct format of an email address (from some sort of authoritative source) 2) Hopefully some pl/sql code that will validate a sting to see if it is a valid email address. If anyone can assist, I would appreciate it! Regards Oweson Flynn _ Tell me what you think, Captain, I'm all ears - Spock Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn 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: Thomas, Kevin 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: utl_file and record delimters
Does utl_file not just read the file a line at a time and then it is upto you to programmatically divide the data up into it's chunks using substr etc. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 24 October 2001 15:30 To: Multiple recipients of list ORACLE-L I need to use utl_file on a Unix server to process DOS format(CRLF) files. can I sepcify to utl_file waht the record delimiter is...or do I need to convert the files to Unix format before utl_file will read them correctly? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Thomas, Kevin 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: Output to Excel
I believe the error to be where you have: OUT_REC TYPE REGISTRO; it should be: OUT_REC REGISTRO%TYPE; -Original Message- Sent: 04 October 2001 23:10 To: Multiple recipients of list ORACLE-L Hi Jared, Excuse me for contact you directly not throug the list. The past week you post an answer to someone trying to write to excel, I took the example to generate a file comma separated, but getting an error. CREATE OR REPLACE PACKAGE BODY PROCESAR_AGENCIAS AS PROCEDURE GENERAR_FACTURAS ( PGRUPO IN NUMBER,PCOMPANIAIN NUMBER, PFECHA_INICIAL IN DATE, PFECHA_FINAL IN DATE, PAGENCIA IN NUMBER ) AS CURSOR C_FACTURAS IS SELECT F.GRUPO||','|| F.COMPANIA||','|| F.TIPO_FACTURA||','|| F.AGENCIA||','|| F.FACTURA||','|| F.CLIENTE||','|| F.VENDEDOR||','|| F.DOCUMENTO_COBRO||','|| F.FECHA||','|| F.FECHA_PAGO||','|| F.FECHA_VENCIMIENTO||','|| F.ESTATUS_COMISION||','|| F.COMISION_VENDEDOR||','|| F.MONTO||','|| F.MONTO_PAGADO||','|| F.IMPRESA||',' FROM FACTURAS F WHERE F.GRUPO = PGRUPO AND F.COMPANIA= PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL; CURSOR C_ITEM_FACTURAS IS SELECT I.GRUPO||','|| I.COMPANIA||','|| I.AGENCIA||','|| I.TIPO_FACTURA||','|| I.FACTURA||','|| I.LOCALIDAD||','|| I.ARTICULO||','|| I.SECUENCIA||','|| I.COSTO||','|| I.PRECIO_VENTA||','|| I.CANTIDAD||','|| I.ITBIS||','|| I.DESCTO||',' FROM FACTURAS F, ITEM_FACTURAS I WHERE F.GRUPO = PGRUPO AND F.COMPANIA = PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL AND I.GRUPO = F.GRUPOAND I.COMPANIA = F.COMPANIA AND I.TIPO_FACTURA = F.TIPO_FACTURA AND I.FACTURA = F.FACTURA; V_ARCHIVO UTL_FILE.FILE_TYPE; REGISTRO FACTURAS%ROWTYPE; * I declare it here OUT_REC TYPE REGISTRO; * BEGIN -- Loop para el archivo de Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','FACTURAS.TXT', 'W'); FOR FT IN C_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, FT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); -- Loop para el archivo de Item Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','ITEM_FACTURAS.TXT', 'W'); FOR IFT IN C_ITEM_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, IFT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); END GENERAR_FACTURAS; END PROCESAR_AGENCIAS; / PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared How should I Declare it. I did REGISTRO FACTURAS%ROWTYPE; OUT_REC TYPE REGISTRO; Is there something missing ? Any help !! Thanks in Advance, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez 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: Thomas, Kevin 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: Output to Excel
Ooops, Again, if you are actually declaring OUT_REC to be the same as REGISTRO, and REGISTRO is the same as FACTURAS then you could also do: OUT_REC FACTURAS%ROWTYPE; Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 05 October 2001 10:15 To: Multiple recipients of list ORACLE-L I believe the error to be where you have: OUT_REC TYPE REGISTRO; it should be: OUT_REC REGISTRO%TYPE; -Original Message- Sent: 04 October 2001 23:10 To: Multiple recipients of list ORACLE-L Hi Jared, Excuse me for contact you directly not throug the list. The past week you post an answer to someone trying to write to excel, I took the example to generate a file comma separated, but getting an error. CREATE OR REPLACE PACKAGE BODY PROCESAR_AGENCIAS AS PROCEDURE GENERAR_FACTURAS ( PGRUPO IN NUMBER,PCOMPANIAIN NUMBER, PFECHA_INICIAL IN DATE, PFECHA_FINAL IN DATE, PAGENCIA IN NUMBER ) AS CURSOR C_FACTURAS IS SELECT F.GRUPO||','|| F.COMPANIA||','|| F.TIPO_FACTURA||','|| F.AGENCIA||','|| F.FACTURA||','|| F.CLIENTE||','|| F.VENDEDOR||','|| F.DOCUMENTO_COBRO||','|| F.FECHA||','|| F.FECHA_PAGO||','|| F.FECHA_VENCIMIENTO||','|| F.ESTATUS_COMISION||','|| F.COMISION_VENDEDOR||','|| F.MONTO||','|| F.MONTO_PAGADO||','|| F.IMPRESA||',' FROM FACTURAS F WHERE F.GRUPO = PGRUPO AND F.COMPANIA= PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL; CURSOR C_ITEM_FACTURAS IS SELECT I.GRUPO||','|| I.COMPANIA||','|| I.AGENCIA||','|| I.TIPO_FACTURA||','|| I.FACTURA||','|| I.LOCALIDAD||','|| I.ARTICULO||','|| I.SECUENCIA||','|| I.COSTO||','|| I.PRECIO_VENTA||','|| I.CANTIDAD||','|| I.ITBIS||','|| I.DESCTO||',' FROM FACTURAS F, ITEM_FACTURAS I WHERE F.GRUPO = PGRUPO AND F.COMPANIA = PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL AND I.GRUPO = F.GRUPOAND I.COMPANIA = F.COMPANIA AND I.TIPO_FACTURA = F.TIPO_FACTURA AND I.FACTURA = F.FACTURA; V_ARCHIVO UTL_FILE.FILE_TYPE; REGISTRO FACTURAS%ROWTYPE; * I declare it here OUT_REC TYPE REGISTRO; * BEGIN -- Loop para el archivo de Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','FACTURAS.TXT', 'W'); FOR FT IN C_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, FT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); -- Loop para el archivo de Item Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','ITEM_FACTURAS.TXT', 'W'); FOR IFT IN C_ITEM_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, IFT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); END GENERAR_FACTURAS; END PROCESAR_AGENCIAS; / PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared How should I Declare it. I did REGISTRO FACTURAS%ROWTYPE; OUT_REC TYPE REGISTRO; Is there something missing ? Any help !! Thanks in Advance, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez 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: Thomas, Kevin 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: Output to Excel
Err, Actually correcting myself, that should be: OUT_REC REGISTRO%ROWTYPE; K. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 05 October 2001 10:15 To: Multiple recipients of list ORACLE-L I believe the error to be where you have: OUT_REC TYPE REGISTRO; it should be: OUT_REC REGISTRO%TYPE; -Original Message- Sent: 04 October 2001 23:10 To: Multiple recipients of list ORACLE-L Hi Jared, Excuse me for contact you directly not throug the list. The past week you post an answer to someone trying to write to excel, I took the example to generate a file comma separated, but getting an error. CREATE OR REPLACE PACKAGE BODY PROCESAR_AGENCIAS AS PROCEDURE GENERAR_FACTURAS ( PGRUPO IN NUMBER,PCOMPANIAIN NUMBER, PFECHA_INICIAL IN DATE, PFECHA_FINAL IN DATE, PAGENCIA IN NUMBER ) AS CURSOR C_FACTURAS IS SELECT F.GRUPO||','|| F.COMPANIA||','|| F.TIPO_FACTURA||','|| F.AGENCIA||','|| F.FACTURA||','|| F.CLIENTE||','|| F.VENDEDOR||','|| F.DOCUMENTO_COBRO||','|| F.FECHA||','|| F.FECHA_PAGO||','|| F.FECHA_VENCIMIENTO||','|| F.ESTATUS_COMISION||','|| F.COMISION_VENDEDOR||','|| F.MONTO||','|| F.MONTO_PAGADO||','|| F.IMPRESA||',' FROM FACTURAS F WHERE F.GRUPO = PGRUPO AND F.COMPANIA= PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL; CURSOR C_ITEM_FACTURAS IS SELECT I.GRUPO||','|| I.COMPANIA||','|| I.AGENCIA||','|| I.TIPO_FACTURA||','|| I.FACTURA||','|| I.LOCALIDAD||','|| I.ARTICULO||','|| I.SECUENCIA||','|| I.COSTO||','|| I.PRECIO_VENTA||','|| I.CANTIDAD||','|| I.ITBIS||','|| I.DESCTO||',' FROM FACTURAS F, ITEM_FACTURAS I WHERE F.GRUPO = PGRUPO AND F.COMPANIA = PCOMPANIA AND F.AGENCIA = PAGENCIA AND F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL AND I.GRUPO = F.GRUPOAND I.COMPANIA = F.COMPANIA AND I.TIPO_FACTURA = F.TIPO_FACTURA AND I.FACTURA = F.FACTURA; V_ARCHIVO UTL_FILE.FILE_TYPE; REGISTRO FACTURAS%ROWTYPE; * I declare it here OUT_REC TYPE REGISTRO; * BEGIN -- Loop para el archivo de Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','FACTURAS.TXT', 'W'); FOR FT IN C_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, FT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); -- Loop para el archivo de Item Facturas V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','ITEM_FACTURAS.TXT', 'W'); FOR IFT IN C_ITEM_FACTURAS LOOP UTL_FILE.PUT_LINE(V_ARCHIVO, IFT.OUT_REC); END LOOP; UTL_FILE.FCLOSE(V_ARCHIVO); END GENERAR_FACTURAS; END PROCESAR_AGENCIAS; / PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared PL/SQL: Statement ignored PLS-00302: component 'OUT_REC' must be declared How should I Declare it. I did REGISTRO FACTURAS%ROWTYPE; OUT_REC TYPE REGISTRO; Is there something missing ? Any help !! Thanks in Advance, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez 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: Thomas, Kevin 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: Thomas, Kevin INET: [EMAIL
RE: Output to Excel
Ramon, I would add an alias onto the columns you are referencing in your cursors so that they are called something like DATA. This way when you come to reference FT later on you can use FT.DATA as the item to ouput to your file. You appear to be referencing OUT_REC at line 65 incorrectly. OUT_REC is a record containing items of data. As you have opened the cursor on line 63 with the statement FOR FT IN C_FACTURAS, you have now assigned all the values that will be returned from the cursors into FT. In order to output the details that are now held within FT, line 65 should read something like: UTL_FILE.PUT_LINE(V_ARCHIVO, FT.DATA); You really don't need OUT_REC anymore as you never move data into it. I hope this makes sense, I'm never very good at explaining things... ;o) Regards, Kev. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 05 October 2001 15:06 To: Multiple recipients of list ORACLE-L Thomas, I keep getting the error LINE/COL ERROR - 65/4 PL/SQL: Statement ignored 65/36PLS-00302: component 'OUT_REC' must be declared 72/4 PL/SQL: Statement ignored 72/37PLS-00302: component 'OUT_REC' must be declared SQL Any suggestion, Gracias Ramon Estevez Dominican Republic [EMAIL PROTECTED] 1 CREATE OR REPLACE PACKAGE BODY PROCESAR_AGENCIAS AS 2 PROCEDURE GENERAR_FACTURAS 3( PGRUPO IN NUMBER,PCOMPANIAIN NUMBER, 4 PFECHA_INICIAL IN DATE, PFECHA_FINAL IN DATE, 5 PAGENCIA IN NUMBER ) AS 6 CURSOR C_FACTURAS IS 7 SELECT F.GRUPO||','|| 8F.COMPANIA||','|| 9F.TIPO_FACTURA||','|| 10F.AGENCIA||','|| 11F.FACTURA||','|| 12F.CLIENTE||','|| 13F.VENDEDOR||','|| 14 -- ZONA||','|| 15F.DOCUMENTO_COBRO||','|| 16F.FECHA||','|| 17F.FECHA_PAGO||','|| 18F.FECHA_VENCIMIENTO||','|| 19F.ESTATUS_COMISION||','|| 20F.COMISION_VENDEDOR||','|| 21F.MONTO||','|| 22F.MONTO_PAGADO||','|| 23F.IMPRESA||',' 24 -- ITBIS||','|| 25 -- DESCTO||',' 26 FROM FACTURAS F 27WHERE 28 F.GRUPO = PGRUPO AND 29 F.COMPANIA= PCOMPANIA AND 30 F.AGENCIA = PAGENCIA AND 31 F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL; 32 CURSOR C_ITEM_FACTURAS IS 33 SELECT I.GRUPO||','|| 34I.COMPANIA||','|| 35I.AGENCIA||','|| 36I.TIPO_FACTURA||','|| 37I.FACTURA||','|| 38I.LOCALIDAD||','|| 39I.ARTICULO||','|| 40I.SECUENCIA||','|| 41I.COSTO||','|| 42I.PRECIO_VENTA||','|| 43I.CANTIDAD||','|| 44I.ITBIS||','|| 45I.DESCTO||',' 46 FROM FACTURAS F, ITEM_FACTURAS I 47WHERE 48 F.GRUPO = PGRUPO AND 49 F.COMPANIA = PCOMPANIA AND 50 F.AGENCIA = PAGENCIA AND 51 F.FECHA BETWEEN PFECHA_INICIAL AND 52 PFECHA_FINAL AND 53 I.GRUPO = F.GRUPOAND 54 I.COMPANIA = F.COMPANIA AND 55 I.TIPO_FACTURA = F.TIPO_FACTURA AND 56 I.FACTURA = F.FACTURA; 57 V_ARCHIVO UTL_FILE.FILE_TYPE; 58 REGISTRO FACTURAS%ROWTYPE; 59 OUT_REC REGISTRO%TYPE; 60 BEGIN 61 -- Loop para el archivo de Facturas 62 V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','FACTURAS.TXT', 'W'); 63 FOR FT IN C_FACTURAS 64 LOOP 65 UTL_FILE.PUT_LINE(V_ARCHIVO, FT.OUT_REC); 66 END LOOP; 67 UTL_FILE.FCLOSE(V_ARCHIVO); 68 -- Loop para el archivo de Item Facturas 69 V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','ITEM_FACTURAS.TXT', 'W'); 70 FOR IFT IN C_ITEM_FACTURAS 71 LOOP 72 UTL_FILE.PUT_LINE(V_ARCHIVO, IFT.OUT_REC); 73 END LOOP; 74 UTL_FILE.FCLOSE(V_ARCHIVO); 75 END GENERAR_FACTURAS; 76* END PROCESAR_AGENCIAS; SQL / Warning: Package Body created with compilation errors. SQL SHOW ERRORS Errors for PACKAGE BODY PROCESAR_AGENCIAS: LINE/COL ERROR - 65/4 PL/SQL: Statement ignored 65/36PLS-00302: component 'OUT_REC' must be declared 72/4 PL/SQL: Statement ignored 72/37PLS-00302: component 'OUT_REC' must be declared SQL Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Thomas, Kevin Enviado el: Friday, 05 October, 2001 4:15 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Output to Excel I believe the error to be where
RE: Unix Cron Job
Have you tried using CRONTAB. It's very, very easy (given my lack of Unix knowledge!!). Just do a: $ man crontab in unix for more details. K. -Original Message- Sent: 03 October 2001 17:21 To: Multiple recipients of list ORACLE-L Hi List, I am not a Unix person and want to scheduled a batch job to run on Unix machine every night at 1:00 AM, if you have any script for this or similar really appreciate. Thanks in Advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Thomas, Kevin 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: init.ora file and UTL_FILE package
cuell!!! ;o) -Original Message- Sent: 03 October 2001 18:06 To: Multiple recipients of list ORACLE-L Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Steve Smith 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: Thomas, Kevin 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
RE: init.ora file and UTL_FILE package
Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Dynamic Sql
Hi, What exactly would you like to know about dynamic sql? Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 09:30 To: Multiple recipients of list ORACLE-L Hi Lisits I would appreciate any feed back on this topic. dbms_sql.open_cursor dbms_sql.parse dbms_sql.define_column dbms_sql.execute_and_fetch dbms_sql.column_value dbms_sql.close_cursor Regrds NItheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar 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: Thomas, Kevin 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).