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
-----------

Expand|Select|Wrap|Line Numbers

  
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

Parameter Store procedure

Post your reply

Similar topics