On Tue, 7 Apr 1998 16:27:33 -0400, "Jeff" <jsouthworth_at_dsitopdog.com>
wrote:
>Help. I'm trying to create a procedure that returns values from a select.
>I would like to pass the procedure an account number, then pull back Name
>and address info based on the number. I am having a terrible time trying to
>get this accomplished. Any help is greatly appreciated.
>
>Thanks,
>Jeff
>
>
Try
CREATE OR REPLACE PROCEDURE myproc(nAccount in number, vName out
varchar2, vAddress out varchar2) IS
BEGIN
SELECT name, address
INTO vName,vAddress
FROM emp;
END;
Received on Wed Apr 08 1998 - 01:30:31 CDT
