Gurus,

I'm new to oracle and I'm trying to right an SP that returns certain values.

Please let me know how this could be written better

CREATE OR REPLACE
procedure CATTRAC_PROC
as
begin
select stbkeyi from stb where
STBBEZC = ' ';

select a.STBBEZC from stb a,
bld b
where
b.bldfnmc = '12345' and b.bldfnmc = '32'
and b.BLDSTBKEYI = a.STBKEYI;
commit;
END;