Wierdness during script in SQLPlus
I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? 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).
RE: Wierdness during script in SQLPlus
The Doc is the Comments Written in the file Between /* */ That comes in 8i unable to checck in 80... Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Wednesday, May 01, 2002 3:28 PM To: Multiple recipients of list ORACLE-L I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? 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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wierdness during script in SQLPlus
Farnsworth, Dave wrote: I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? Thanks, Dave Related to the now obsolete DOCUMENT SQL*Plus command, once used to echo everything and create (when spooling) kind of SQL tutorials. I have never found it very useful, anyway. Musn't be alone since it is now obsolete. Must be turned on by '/*' somewhere in your script. Keep C style comments INSIDE statements (I only use them for hints, and I try not do it too often). REM can only be used in SQL*Plus scripts. IMHO the best choice for comments is --. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wierdness during script in SQLPlus
Thanks Stephane. That explains it. I'll go with the -- for my comments for version consistancy. Dave -Original Message- Sent: Wednesday, May 01, 2002 8:18 AM To: Multiple recipients of list ORACLE-L Farnsworth, Dave wrote: I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? Thanks, Dave Related to the now obsolete DOCUMENT SQL*Plus command, once used to echo everything and create (when spooling) kind of SQL tutorials. I have never found it very useful, anyway. Musn't be alone since it is now obsolete. Must be turned on by '/*' somewhere in your script. Keep C style comments INSIDE statements (I only use them for hints, and I try not do it too often). REM can only be used in SQL*Plus scripts. IMHO the best choice for comments is --. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Wierdness during script in SQLPlus
Hi Dave, I believe in older versions of sql*plus there was a DOCUMENTATION (DOC) function that would spit comments back to the user with the DOC prompt. I know I've seen this before, a long time ago. It never affected anything I was running tho. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-309-4157 -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 7:28 AM To: Multiple recipients of list ORACLE-L Subject: Wierdness during script in SQLPlus I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wierdness during script in SQLPlus
You are correct that it does not affect my script, it's just annoying. A ctrl-C does break me out of the DOC prompt and puts me back into the SQL prompt. Learned something new. :o) Thanks, Dave -Original Message- Sent: Wednesday, May 01, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Hi Dave, I believe in older versions of sql*plus there was a DOCUMENTATION (DOC) function that would spit comments back to the user with the DOC prompt. I know I've seen this before, a long time ago. It never affected anything I was running tho. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-309-4157 -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 7:28 AM To: Multiple recipients of list ORACLE-L Subject: Wierdness during script in SQLPlus I have a script that I run to update statistics on my databases that is giving me something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what my screen looks like in SQLPlus; SQL analyze table MP2.MOSIA_OUT_POLINE compute statistics; Table analyzed. SQL analyze table MP2.REQORDOP compute statistics; Table analyzed. SQL DOC*/ DOCspool off DOCexit DOC DOC What is happening when the prompt goes from SQL to DOC?? This does not happen on the 8.x databases. The script finishes without errors but I don't know what this is. Any ideas?? 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).