Re: Passing whole row from one procedure to other procedure

SQL> CREATE OR REPLACE
  2  PROCEDURE b( p emp%ROWTYPE ) IS
  3  BEGIN
  4    DBMS_OUTPUT.PUT_LINE( 'Name is ' || p.ename );
  5  END;  
  6  /

Procedure created.

SQL> CREATE OR REPLACE
  2  PROCEDURE a IS
  3    v_emp_row emp%ROWTYPE;
  4  BEGIN
  5    SELECT * INTO v_emp_row FROM emp WHERE empno=7900;
  6    b( v_emp_row );
  7  END;
  8  /

Procedure created.

SQL> exec a
Name is JAMES

PL/SQL procedure successfully completed.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].