Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail From: "baka" Newsgroups: comp.databases.oracle.server Subject: Re: PL/SQL : serveroutput on inside begin..end block Possible ? Impossible?? Date: 7 Jul 2005 17:23:36 -0700 Organization: http://groups.google.com Lines: 24 Message-ID: <1120782216.125988.246530@g44g2000cwa.googlegroups.com> References: <1120632470.390863.80300@g43g2000cwa.googlegroups.com> <1120637544.661569.158750@g43g2000cwa.googlegroups.com> <-5qdnbQMtPSCTFbfRVn-iQ@comcast.com> NNTP-Posting-Host: 131.248.58.242 Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1120782221 23898 127.0.0.1 (8 Jul 2005 00:23:41 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 8 Jul 2005 00:23:41 +0000 (UTC) User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g44g2000cwa.googlegroups.com; posting-host=131.248.58.242; posting-account=-jCrTwwAAACrq_3DA8otYT2rkxEie5P7 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246819 Dear all Mark C. Stock =E3=81=AE=E3=83=A1=E3=83=83=E3=82=BB=E3=83=BC=E3=82=B8: > so, if you are trying to control SQL*Plus behavior with a SQL*Plus comman= d, > that command cannot be executed by the database > > ++ mcs Thank you very much for giving me the advise. I will utilize the glogin/login.sql's A tiny advise can save lot many hours, in some cases days. You are all great people. PS: When i was writing a trigger to set date depending on the region/user login and execute some particular scripts. i.e If a person login from japan Date should be set as per the Japanese env. USA ... etc. In the same way i was thinking with SERVEROUTPUT ON.OFF Thanks again