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 -> procedure builder help!

procedure builder help!

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/04/29
Message-ID: <33664A3E.2781@garland.dnr.state.sc.us>#1/1

Can someone please tell me why I am getting this error?

here is the package spec:

00001 package nws is

00002  	type t_network is table of network%ROWTYPE
00003  		index by binary_integer;
00004  	type int_array is table of integer
00005  		index by binary_integer;
00006  	gnetwork	t_network;
00007  gdatemask varchar2(35) := 'mm/dd/yyyy';
00008  gcirrus_user	cirrus_users%ROWTYPE;
00009  cirrus_station	varchar2(20);
00010  cirrus_group	varchar2(20);
00011  bad_cookie	exception;
00012  gremote_addr	cirrus_users.remote_addr%TYPE;
00013 gstation_metadata varchar2(35) := 'CLIMATE.TD3200STN'; 00014 procedure get_network(pucan_id in varchar2); 00015 procedure request_form(pucan_id in varchar2,

        pnetwork_id in varchar2);
00016 procedure get_data(pvariable_id in owa_util.ident_arr,

00017  	pucan_id in varchar2,pstart_date in varchar2,
00018  	pend_date in varchar2,paction in varchar2,
00019  	pgroupby in owa_util.ident_arr,pdetail in varchar2);
00020 end nws;

<b>Here is the error I get when I try to load it:<b>

PL/SQL> .load STORED PROGRAMUNIT DEVELOPER.NWS NAMESPACE / SPECIFICATION Loading stored Package Spec NWS...
ERROR 103 at line 2, column 26
  Encountered the symbol "OF" when expecting one of the following:   "("
  Fatal syntax error, unable to recover

Any help is greatly appreciated,

                Steve Edwards Received on Tue Apr 29 1997 - 00:00:00 CDT

Original text of this message

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