RE: pL/SQL PROCEDUR
The proximity of the words "BLOB" and "porn" is unpleasantly evocative... -Original Message- Sent: 26 March 2002 19:25 To: Multiple recipients of list ORACLE-L ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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 off
Re: pL/SQL PROCEDUR
[EMAIL PROTECTED] wrote: > you forgot DNA sample. Rachel's good, but come-on! not THAT good. wanna bet?;-) PS for those of you who remember and were following my job saga, we were sold yesterday. well, partly sold anyway. the closing is 4/10 and we're still not sure if there will be any jobs after that date with either the new company or with the bankruptcy trustee. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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 PROCEDUR
you forgot DNA sample. Rachel's good, but come-on! not THAT good. -Original Message- Sent: Tuesday, March 26, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Even though I am beyond lazy, I don't write any code, or RTFM (remind us of someone??)...I did manage to steal some auditing triggers from Rachel C. and place them on the new table. When Tom inserted those nasty pictures, the trigger fired and emailed Tom's name, address, phone number, height, weight, SSN, finger prints, rental eye scan and picture to the FBI... Rachel writes some pretty powerful triggers... -Original Message- Sent: Tuesday, March 26, 2002 2:25 PM To: Multiple recipients of list ORACLE-L ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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]
RE: pL/SQL PROCEDUR
Even though I am beyond lazy, I don't write any code, or RTFM (remind us of someone??)...I did manage to steal some auditing triggers from Rachel C. and place them on the new table. When Tom inserted those nasty pictures, the trigger fired and emailed Tom's name, address, phone number, height, weight, SSN, finger prints, rental eye scan and picture to the FBI... Rachel writes some pretty powerful triggers... -Original Message- Sent: Tuesday, March 26, 2002 2:25 PM To: Multiple recipients of list ORACLE-L ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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 your
RE: pL/SQL PROCEDUR
ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: pL/SQL PROCEDUR
And do you expect a link or a real example script??? On Tue 26. March 2002 19:29, you wrote: > Can someone please create a table for me? Umm...I need last and first name > columns. I don't want the DDL, I want you to connect to my database and > create it for me. I need this done yesterday. > > Thanks, really, thanks. Hurry up!! > > -Original Message- > Sent: Tuesday, March 26, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > LMAO > > Obligatory Oracle Question: > > Does anybody have a sample init.ora file that they use for a 9.0.1 > instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my > desktop PC play database.. > > -Original Message- > [EMAIL PROTECTED] > Sent: 26 March 2002 16:39 > To: Multiple recipients of list ORACLE-L > > > > Roland, > > What a surprise! I thought you were moving to an Access list? Because > I've taken a rather perverse interest in the questions you ask, I'll give > you a hint: triggers and exception handling. > > By the way, if no one has answered your question regarding a "table of > table definitions", it's probably because they are suffering from shock. > You are the DBA, are you not? This information already exists in a number > of cleverly designed Oracle supplied views. I suggest you become familiar > with the DBA_ views and the V$ views. A simple SQL query (which of course > you'll ask for someone to provide an example) should get you all the > information your heart desires. > > Study your craft my friend. > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > Roland.Skoldbl > [EMAIL PROTECTED] To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR > om > > > 03/26/2002 > 12:23 AM > Please respond > to ORACLE-L > > > > > > > Hallo, > > > Can anyone give me an example on a pl/sql code, which does the following: > > > > I have 4 procedures, and I want the following to be logged in a status > > table. > > > > Procedure names > > Start_time of procedure > > End_time_of procedure > > Error_code(if anything goes wrong) > > Error_message > > > > Please give me example onhow to write the code and also tell me how to > > pick > > > out the procedure_name, start_time of_procedure, end_time_ptocedure, > > error_code, error_message. > > > > Thanks in advance.And just dontgive me a link, i wantthis real example > > too. > > > Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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 PROCEDUR
Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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: Grabowy, Chris 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 PROCEDUR
LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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).
Re: pL/SQL PROCEDUR
Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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: 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).
pL/SQL PROCEDUR
Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > 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).
Re: PL/SQL - procedur
Because it stores only seconds and if your procedure's runtime is short (< 1 sec) you will get the same numbers. Other problem is: if you call same procedure in LOOP, you will get 1 - 2 - 5 ... 15 ... 500 records with same value in start and end time column. And (I think so) there's no way how to get the order of inserting of these records. JP On Mon 25. March 2002 16:03, you wrote: > Jan, > > Could you explain why you say not to use the DATE datatype? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI > USA > > > -Original Message- > Sent: Monday, March 25, 2002 6:33 AM > To: Multiple recipients of list ORACLE-L > > > Look at Exception in PL/SQL and how to use it. > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817 >/ a77069/11_elems.htm#8355 > > And don't use 'date' type of variable to store start time and end time of > your procedures. > > JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: PL/SQL - procedur
>Could you explain why you say not to use the DATE >datatype? > >Rich Jesse >System/Database Administrator >[EMAIL PROTECTED] Quad/Tech >International, Sussex, WI USA Because of the 1s precision limit. The obvious workaround is to have PL/SQL procedures which always take more than say 10mn to run. Stephane Faroult Oriole Corporation Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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 - procedur
Jan, Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 25, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/ a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 - procedur
Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP On Mon 25. March 2002 12:23, you wrote: > Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance. > > Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
PL/SQL - procedur
Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me example onhow to write the code and also tell me how to pick out the procedure_name, start_time of_procedure, end_time_ptocedure, error_code, error_message. 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).