"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.
--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---
WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup
Received on Mon Jul 03 2006 - 02:43:16 CDT
