Stored Proc Question

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 - 09:16:42 CDT