Parameter Store procedure

[mktilu]

hi

can any one tell me how to run the store procedure where one of its parmeter has OUT and when i execute i want to get the values .

Its argent reply.

[chandu031]

Hi,

Here's an example:

declare count1 number;
begin
sample_procedure(count1);
dbms_output.put_line(count1);
end;

[debasisdas]

procedure
===========
CREATE OR REPLACE PROCEDURE PROC1(NUM NUMBER,NAME OUT VARCHAR)
IS
BEGIN
SELECT ENAME INTO NAME FROM EMP WHERE EMPNO=NUM;
END;
------------
execution
-------------------
declare
n varchar2(10);
begin
proc1(7788,n);
dbms_output.put_line(n);
end;




hope u find the trick
all the best

[debasisdas]

ex-2
-----------

 
create or replace procedure testproc(no emp.empno%type,rec out emp%rowtype)
 is
 cursor c is select * from emp where deptno=no;
 begin
 open c;
 loop
 fetch c into rec;
 exit when c%notfound;
 DBMS_OUTPUT.PUT_LINE(rec.empno||'       '||rec.ename||' ' ||rec.job||' ' ||rec.sal);
 end loop;
 close c;
 end ;
-----------------------------------
TO EXECUTE
-----------------------------------
 declare
 r emp%rowtype;
 begin
 testproc(10,r);
 end;
 
 

now try few more yourself