Can't deploy if i use more than 5 output in a Procedure.
524091Sep 20 2006 — edited Sep 21 2006Hi,
I have created a procedure with 1 input with 5 Outputs. I could successfully deploy. But on the same procedure I added 1 more output (1 input and 6 outputs). I could not deploy. The error as below:
Name
Action
Status
Log
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 170, column 7:
PLS-00103: Encountered the symbol "IS" when expecting one of the following:
body <an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier>" was substituted for "IS" to continue.
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 1014, column 1:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
begin case declare else elsif end exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
The symbol "exit" was substituted for ";" to continue.
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 1451, column 1:
PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following:
end not pragma final instantiable order overriding static
member constructor map
The symbol "static" was substituted for "PROCEDURE" to continue.
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 1555, column 7:
PLS-00103: Encountered the symbol "IS" when expecting one of the following:
body <an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier>" was substituted for "IS" to continue.
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 1579, column 9:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "exception" was substituted for ";" to continue.
SW_INT_GEOGRAPHIC_ENV_MAP
Create
Warning
ORA-06550: line 1603, column 2:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor
I could not figure out the error.
Thanks
Raj