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 -> oracle web server

oracle web server

From: Vaidhyanatha K Kumar <kumar_at_engr.orst.edu>
Date: 1998/02/11
Message-ID: <34E252EB.588@engr.orst.edu>#1/1

Hi everbody,
'
I am new to Webserver. I am trying to install/run the owains.sql from sqldba. I have the PL/SQL module installed. When i run a file to create a package. I get these errors.

Can anyone help me out??

Thanks
VAidhy

SQLDBA> CREATE OR REPLACE PACKAGE phone_pkg AS
     2> 
     3>                 TYPE person_rec_type IS RECORD              --
person-info record
     4>                    (person_id       NUMBER(6),
     5>                     last_name       VARCHAR2(15),
     6>                     first_name      VARCHAR2(15),
     7>                     title           VARCHAR2(8),
     8>                     user_name       VARCHAR2(8),
     9>                     address         VARCHAR2(12),
    10>                     url             VARCHAR2(20));
    11> 
    12>                 PROCEDURE get_person_by_name(name IN VARCHAR2);
    13> 
    14>                 PROCEDURE display_person_head(ctitle IN
VARCHAR2);
    15>
    16>                 PROCEDURE display_person_rec(person_rec IN
person_rec_type);
    17> 
    18>                 PROCEDURE display_person_end;
    19> 
    20>             END phone_pkg;
    21> /
CREATE OR REPLACE PACKAGE phone_pkg AS
                                    *

ORA-00900: invalid SQL statement Received on Wed Feb 11 1998 - 00:00:00 CST

Original text of this message

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