Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle procedure newbie

Re: oracle procedure newbie

From: Jeremy <jeremy0505_at_gmail.com>
Date: Sun, 2 Jul 2006 18:06:45 +0100
Message-ID: <MPG.1f120d787fb42ed398a231@news.individual.net>


In article <1151856151.210287.22080_at_v61g2000cwv.googlegroups.com>, Bulldog says...
> 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.
>

<snip functional spec>
>
> Any assistance is appreciated!
>
>

Makre sure the last line of the "create procedure" statement (I am assuming you are copying/pasting the entire procedure) contains the "/" character. That tells sqlplus to execute the SQL entered.

HTH

-- 

jeremy
Received on Sun Jul 02 2006 - 12:06:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US