Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> procedure builder help!
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