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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL\SQL package creation

Re: PL\SQL package creation

From: george lewycky <gelewyc_at_nyct.com>
Date: 22 Sep 2004 13:32:54 -0700
Message-ID: <68aecc05.0409221232.407c8e54@posting.google.com>


You need to create the PACKAGE before the PACKAGE BODY

George  

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<Xf6dnTIpMZkQEczcRVn-rQ_at_comcast.com>...
> "DCP" <vaagh_at_hotmail.com> wrote in message
> news:f5c10fa85d76815cf0463b1e210193d3_at_localhost.talkaboutdatabases.com...
> | Hi,
> |
> | I have following code:
> | (seems very simple but tricky)
> |
> |
> | 1-- create or replace package testNameConcate
> | 2-- is
> | 3-- function disp(Name varchar)
> | 4-- return varchar;
> | 5-- end testNameConcate;
> | 6-- /
> | 7-- create or replace package body testNameConcate
> | 8-- is
> | 9-- function disp(Name varchar)
> | 10-- return varchar
> | 11-- is
> | 12-- nm varchar(25);
> | 13-- begin
> | 14-- nm='Hello ' || Name;
> | 15-- return nm;
> | 16-- end testNameConcate;
> | /
> |
> | As u see "/" is need at line 6 other wise it gives me an error
> |
> | PLS-00103: Encountered the symbol "CREATE" at line 7
> |
> | but sill this code is giving me a same error, and now it has problem with
> | "/" and error is
> |
> | PLS-00103: Encountered the symbol "/" at line 6
> |
> | What am i missing here?
> |
> |
>
> code is fine -- it's probably the way you're running it. i would assume that
> you've got all this code in the SQL buffer and then attempt to execute it as
> if it is a single SQL statement -- it's actually two SQL statements, so you
> need to save it to a named script file (not the default afiedt.buf that gets
> created when you do a plain EDIT in SQL*Plus) and then use '@filename' or
> 'start filename' to execute the script
>
> also: user varchar2 instead of varchar -- oracle's been saying the following
> since v7 or v6:
>
> "VARCHAR Datatype
> "The VARCHAR datatype is currently synonymous with the VARCHAR2 datatype.
> Oracle recommends that you use VARCHAR2 rather than VARCHAR. In future
> releases, VARCHAR might be defined as a separate datatype used for
> variable-length
> character strings compared with different comparison semantics."
>
> ++ mcs
Received on Wed Sep 22 2004 - 15:32:54 CDT

Original text of this message

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