Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pl/Sql and Win NT

Re: Pl/Sql and Win NT

From: Jim <lermontovb_at_hotmail.com>
Date: 1998/12/02
Message-ID: <01be1e01$9db46b40$ef5795c1@roark>#1/1

I believe the version of Oracle server you're using has a built in package called UTL_File which allows Oracle to write to the file system on the server. I've never actually used it myself (don't think the DBAs would let us but from what I've read it doesn't seem to difficult). Try Oracle Built-in Packages by Steven Feuerstein for more detail. Aside from that I gues you'd have to get an app polling for the output file on your server (VB app running as a service maybe). Jim

Carlos A. Gonzalez <carlos_a_gonzalez_at_us.dell.com> wrote in article <74222d$1ef$1_at_galaxy.us.dell.com>...
> Gentlemen:
>
> How do I pass a return code from PL/SQL to the operating system ?
>
> Other than using Pro*C, Pro*..., is there any technique to let the O/S
 know
> about the results
> of executing a given stored procedure ?
>
> My O/S is Win NT 4 and Oracle ver 7.3.4
>
> Thanks
>
>
>
  Received on Wed Dec 02 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US