Andreas Sheriff wrote:
> "Bulldog" <jfrancis5_at_woh.rr.com> wrote in message
> news:1151856081.725109.213410_at_m79g2000cwm.googlegroups.com...
>> 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!
>>
>
> May I suggest SQL Developer? It's a free tool from Oracle that should
> alleviate the pain and sufferings of some Oracle newbies.
You may. But as an instructor I insist my students use SQL*Plus
precisely because of the pain and suffering. Not because I am a
sadist but rather because more learning takes place.
--
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
Received on Mon Jul 03 2006 - 11:29:13 CDT
