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

Report message to a moderator

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 .

Report message to a moderator

Previous Topic: Arrays and functions
Next Topic: Re: how to build a dynamic query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 02 15:02:03 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.