Re: oracle procedure newbie

Bulldog wrote:
> Hello,
>
> I am trying to write a procedure using oracle sql plus. Everytime I
> run the create procedure command, I just get another sql line like its
> not ending. Here is what I am trying to do, maybe that will help.
>
> Create a stored procedure with a single input parameter that allows the
> user to supply a product code. Within the procedure, I want to execute
> a SELECT that retrieves the description and price of the product from
> the PRODUCT table with a code matching the one supplied by the user. I
> also would like an exception section that traps the NO_DATA_FOUND error
> and indicates to the user that the product code that he or she supplied
> is invalid.
>
> Any assistance is appreciated!

What, exactly, have you written in this 'create procedure' statement?

David Fitzjarrell Received on Mon Jul 03 2006 - 14:29:56 CDT