Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create Function issue

Create Function issue

From: farhan <fshah01_at_hotmail.com>
Date: 11 Apr 2002 09:12:32 -0700
Message-ID: <81fe0b7a.0204110812.560b7ae9@posting.google.com>


what is wrong with following Function?

CREATE OR REPLACE FUNCTION PartLookUp(partno varchar2) RETURN varchar2 AS
begin
 select part_id, replacement_part_id from parts where part_id=partno;

  if parts.replacement_part_id <> '' then

       call PartLookUp(parts.replacement_part_id);   end if;

  return parts.parts_id;

end Received on Thu Apr 11 2002 - 11:12:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US