Re: oracle procedure newbie

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 3 Jul 2006 17:44:07 -0400
Message-ID: <XZOdnXITMPE1EjTZnZ2dnUVZ_tGdnZ2d@comcast.com>

"Bulldog" <jfrancis5_at_woh.rr.com> wrote in message news:1151962599.511921.97320_at_v61g2000cwv.googlegroups.com...
: CREATE PROCEDURE DISPLAY_PRODUCT @PRODUCT_CODE VARCHAR(5)
: AS
: BEGIN
: IF NOT EXITS(SELECT 1 FROM CIS269_PRODUCT WHERE
: PRODUCT_CODE=@PRODUCT_CODE)
: BEGINRAISEERROR('NO DATA FOUND.',16,1)
: RETURN1
: END
:
:

since this is not PL/SQL syntax, you must have gotten a lot of errors

have you read any PL/SQL references? that would be the absolute 1st place to start

++ mcs Received on Mon Jul 03 2006 - 16:44:07 CDT