RE: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Goulet, Dick
set feedback off

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L


Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed. 

Could anyone tell me how to avoid that message?.

This is how my sql looks like

set linesize 200
set trimspool on
set verify off echo off 
set serveroutput on

spool c:\mudhalvan\test.txt

declare

 
begin


end;

/

spool off

Thank You

Mudhalvan M.M   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
  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: Goulet, Dick
  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: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Stephane Faroult
-
>From: "Mudhalvan, Moovarkku"
><[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Tue, 06 Jan 2004 00:49:25
>
>Hi,
>I am trying to spool the result from PL/SQL
>procedure. At the
>end of result I am getting PL/SQL successfully
>completed. 
>
>Could anyone tell me how to avoid that
>message?.
>

a) Make the procedure fail
-- or --
b) set feedback off

SF
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Prem Khanna J
Hi Mudhalvan , 

set feed off ;

did u try this  ? not sure though   : )

Regards,
Prem.

>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
>>Behalf Of Mudhalvan, Moovarkku
>>
>>Hi,
>>  I am trying to spool the result from PL/SQL procedure. At the
>>end of result I am getting PL/SQL successfully completed. 
>>  
>>  Could anyone tell me how to avoid that message?.
>>
>>  This is how my sql looks like
>>
>>  set linesize 200
>>  set trimspool on
>>  set verify off echo off 
>>  set serveroutput on

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Mudhalvan, Moovarkku
Dear Raj

Thank you so much. Yeah it is working fine

-Original Message-
Sent: Tuesday, January 06, 2004 6:05 PM
To: Multiple recipients of list ORACLE-L


set feedback off

Raj

-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L


Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed. 

Could anyone tell me how to avoid that message?.

This is how my sql looks like

set linesize 200
set trimspool on
set verify off echo off 
set serveroutput on

spool c:\mudhalvan\test.txt

declare

 
begin


end;

/

spool off

Thank You

Mudhalvan M.M   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
  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).


**
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney work product or exempt from disclosure under applicable law. If
you have received this message in error, or are not the named
recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.

**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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: Mudhalvan, Moovarkku
  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: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Charu Joshi
SET FEEDBACK OFF

Regards,
Charu.

-Original Message-
Behalf Of
Mudhalvan, Moovarkku
Sent: 06 January 2004 14:19
To: Multiple recipients of list ORACLE-L

Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.

Could anyone tell me how to avoid that message?.

This is how my sql looks like

set linesize 200
set trimspool on
set verify off echo off
set serveroutput on

spool c:\mudhalvan\test.txt

declare


begin


end;

/

spool off

Thank You

Mudhalvan M.M
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mudhalvan, Moovarkku
  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).

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*

Visit us at http://www.mahindrabt.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Charu Joshi
  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: How to remove PL/SQL successfully completed Message

2004-01-06 Thread Jamadagni, Rajendra
set feedback off

Raj

-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L


Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed. 

Could anyone tell me how to avoid that message?.

This is how my sql looks like

set linesize 200
set trimspool on
set verify off echo off 
set serveroutput on

spool c:\mudhalvan\test.txt

declare

 
begin


end;

/

spool off

Thank You

Mudhalvan M.M   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
  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).

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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).


How to remove PL/SQL successfully completed Message

2004-01-06 Thread Mudhalvan, Moovarkku
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed. 

Could anyone tell me how to avoid that message?.

This is how my sql looks like

set linesize 200
set trimspool on
set verify off echo off 
set serveroutput on

spool c:\mudhalvan\test.txt

declare

 
begin


end;

/

spool off

Thank You

Mudhalvan M.M   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mudhalvan, Moovarkku
  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).