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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Syntax a Package with Procedures in Oracle. Any Ideas?

Re: Syntax a Package with Procedures in Oracle. Any Ideas?

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Thu, 20 May 1999 09:39:23 +0100
Message-ID: <udAJFHA7o8Q3EwgF@ahardy.demon.co.uk>


In article <f2F03.764$S6.99452_at_news.uswest.net>, James Thompson <james.thompson_at_noridian.com> writes
>Two Questions.
>
>1.)What is the correct syntax for creating a package that contains
>procedures inside of it?

[snip]
>END EE_PACKAGE;
>CREATE PACKAGE BODY EE_PACKAGE AS
I assume that you are just loading the above script using SQL*PLUS or similar?

The problem is that you haven't told the system to run the first create statement before you've handed it the second one. It is still parsing the statement and knows that the second use of the word 'CREATE' is wrong there.

Simple fix, from the above...

>END EE_PACKAGE;

/
>CREATE PACKAGE BODY EE_PACKAGE AS
The '/' tells system to run the command stored in the buffer so far i.e. the first create command. It can then continue with the second create command.
--
Andy Hardy. PGP key available on request


Received on Thu May 20 1999 - 03:39:23 CDT

Original text of this message

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