Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't deploy if i use more than 5 output in a Procedure.

524091Sep 20 2006 — edited Sep 21 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2006
Added on Sep 20 2006
4 comments
4,790 views