Home » SQL & PL/SQL » SQL & PL/SQL » using procedure
using procedure [message #37207] Thu, 24 January 2002 09:24 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 procedure [message #37222 is a reply to message #37207] Fri, 25 January 2002 00:51 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
create procedure pro_1(a number,b varchar2) as
declare
a1 number;
b1 varchar2(100);
begin
a1:=a;
b1:=b;
--proceed further .
Previous Topic: Arrays and functions
Next Topic: Re: how to build a dynamic query
Goto Forum:
  


Current Time: Mon Sep 21 10:55:43 CDT 2020