Re: Stored Proc Question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 30 Jul 1999 18:43:51 +0200
Message-ID: <933353024.1717.0.pluto.d4ee154e@news.demon.nl>

You can only return variables with a function. As you need to have it in korn shell, why don't you just use dbms_output.put_line. Redirection works with sqlplus! call it as follows
sqlplus -s <uname>/<pw>@<database> @<yourscript> and the normal banner/signon message is suppressed and you will have the variable only.

Hth,

Sybrand Bakker, Oracle DBA

<jane604_at_my-deja.com> wrote in message news:7nsc3v$fmc$1_at_nnrp1.deja.com...
> I'm new at using oracle and I have a question
> about using stored procedures.
> I've written a very simple stored proc that
> selects a field into a variable. I want to
> return that variable to a korn shell. When I try
> using RETURN <var_name> I get the message
> PLS-00372: In a procedure, RETURN statement
> cannot contain an expression.
>
> My question is can you only use a RETURN
> statement with functions? I tried using OUT, but
> since I need the variable for a script, I can't
> get a handle on the variable that way.
>
> Any suggestions?
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 30 1999 - 11:43:51 CDT