Home » SQL & PL/SQL » SQL & PL/SQL » Using a procedure
Using a procedure [message #37208] Thu, 24 January 2002 09:30 Go to next message
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 Go to previous message
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
Previous Topic: Time Question
Next Topic: error
Goto Forum:
  


Current Time: Thu Mar 28 19:06:30 CDT 2024