From: sjakobson@my-dejanews.com
Subject: Re: Pl/Sql and Win NT
Date: 1998/12/05
Message-ID: <749tsp$5m9$1@nnrp1.dejanews.com>#1/1
References: <74222d$1ef$1@galaxy.us.dell.com>
X-Http-Proxy: 1.0 x15.dejanews.com:80 (Squid/1.1.22) for client 209.109.241.130
Organization: Deja News - The Leader in Internet Discussion
X-Article-Creation-Date: Sat Dec 05 00:14:19 1998 GMT
Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)


Carlos,
you can use SQL*Plus bind variables:

VARIABLE p_return_code NUMBER;
BEGIN
stored_proc(:p_return_code);
END;
/
COLUMN p_return_code NEW_VALUE p_return_code NOPRINT
SELECT :p_return_code p_return_code FROM dual;
EXIT &p_return_code

Solomon Yakobson.


In article <74222d$1ef$1@galaxy.us.dell.com>,
  "Carlos A. Gonzalez" <carlos_a_gonzalez@us.dell.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own