Re: oracle procedures

Bulldog wrote:
> I am new at writing oracle procedures via sql plus and am running into
> issues. Here is what I am trying to accomplish.
>
> 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!

Look at the demo's in Morgan's Library at www.psoug.org under PROCEDURES. If you have an actual problem beyond just wanting someone to do your work for you post the specific problem, your code, and your Oracle version.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org