Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Trying to send stored proc output to a file

5 views
Skip to first unread message

Sanford

unread,
Aug 30, 1999, 3:00:00 AM8/30/99
to
How do I redirect/save the result of a query to a text file, from within a
stored procedure?

I am looking for the equivelent of specifying the spool file in Oracle
SQLPLUS or PL/SQL.

Thanks.

Alexandre Tchepak

unread,
Aug 31, 1999, 3:00:00 AM8/31/99
to
I'm afraid you have to use some combination of xp_cmdshell extended stored
procedure and osql utility.

Alexander

Sanford <jsan...@murraysdiscount.com> wrote in message
news:EICy3.347$tW6...@news.flash.net...

Russell Bride

unread,
Aug 31, 1999, 3:00:00 AM8/31/99
to

Alexandre Tchepak schrieb in Nachricht <7qf3a0$a41$1...@rweb.cnt.ru>...

>I'm afraid you have to use some combination of xp_cmdshell extended stored
>procedure and osql utility.
>
>Alexander

In 6.5 use ISQL from the shell and either shell redirection (>) or the -o
parameter. /R

0 new messages