CODEWITHSUNDEEP
oracle-databasestored-procedurestoad
Virendra Kumar
Virendra Kumar

Reputation: 13

Display result of Stored Procedure

I creates a procedure using Toad Client that is

create or replace procedure getuid(eid_pro varchar2)is 
l_value number;
begin
select  uniqueid 
into l_value 
from enrollment 
where eid=eid_pro;
end ;

When I execute it by Followings

begin
getuid('245698154');
end;

It executed successfully but result is not displayed in data grid. Please help me in this

Upvotes: 0

Views: 105

Answers (2)

anudeepks
anudeepks

Reputation: 1132

In that case please use a function and then you can use it in a select statement which can show the result in the grid.

create or replace function getuid(eid_pro varchar2) return number is 
l_value number;
begin
select  uniqueid 
into l_value 
from enrollment 
where eid=eid_pro;
return l_value;
end ;


select getuid('245698154') from dual;

Upvotes: 0

Rene
Rene

Reputation: 10541

Turn the procedure into a function.

create or replace function getuid(eid_pro varchar2) return number is
   l_value number;
begin
   select uniqueid
     into l_value
     from enrollment
    where eid = eid_pro;

   return l_value;
end;

And then select the function.

select getuid('245698154') from dual;

Upvotes: 1

Related Questions