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>*/
> DOC>spool off
> DOC>exit
> 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: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DFarnsworth_at_Ashleyfurniture.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).