Re: Pl/Sql and Win 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_at_galaxy.us.dell.com>,   "Carlos A. Gonzalez" <carlos_a_gonzalez_at_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 Received on Sat Dec 05 1998 - 00:00:00 CST