VERY quick question for the masters...

How can I make a function out of this statement?

select REF(d) from departments d where d.Name = 'Computer Science'

PS This doesn't work:

create or replace function get_dref (name IN VARCHAR) RETURN REF department IS
 d_ref REF department;
begin
 select REF(d) into d_ref from departments d where d.Name = name; 5 end get_dref;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 17:19:46 CDT