Procedures question
From: James Cummings <jc1635_at_home.com>
Date: Fri, 30 Nov 2001 02:57:22 GMT
Message-ID: <mACN7.133867$pb4.80498227_at_news2.rdc2.tx.home.com>
James Cummings
"Chaos, panic, disorder.... my work is done." Received on Fri Nov 30 2001 - 03:57:22 CET
Date: Fri, 30 Nov 2001 02:57:22 GMT
Message-ID: <mACN7.133867$pb4.80498227_at_news2.rdc2.tx.home.com>
This may be simple, but it's beating me about the head.
As a simple example, what I'd like to do is create a procedure
that has an OUT variable of some sort that is basically a RECORD.
Given that my table has a department id, a first and last name, etc.
Something like:
( v_dept_id IN department_table.dept_id%TYPE,
dept_row OUT department_table%ROWTYPE)
IS
PROCEDURE foo
BEGIN
SELECT *
INTO dept_row
FROM department_table
WHERE dept_id = v_dept_id
ORDER BY lastname;
END foo;
I've beat around and let it beat on me, and I know this is
probably simple, but I'm in a mental block right now over it.
Could someone tell me where I'm missing the point?
James Cummings
"Chaos, panic, disorder.... my work is done." Received on Fri Nov 30 2001 - 03:57:22 CET