Using a procedure [message #37208] |
Thu, 24 January 2002 09:30 |
epro
Messages: 11 Registered: January 2002
|
Junior Member |
|
|
Hi
I have a procedure, it gives out 2 values, by taking a parameter. I want to capture those 2 values in 2 variables. could you suggest a way.
Thanks
|
|
|
Re: Using a procedure [message #37210 is a reply to message #37208] |
Thu, 24 January 2002 10:27 |
Jon
Messages: 483 Registered: May 2001
|
Senior Member |
|
|
In SQL*PLUS
VARIABLE MONTH NUMBER; (or VARCHAR2(n))
VARIABLE YEAR NUMBER;
EXECUTE MYPROC(:MONTH,:YEAR);
PRINT MONTH
PRINT YEAR
|
|
|