Forum Stats

  • 3,816,521 Users
  • 2,259,200 Discussions
  • 7,893,502 Comments

Discussions

PLS-00103 error while execute the Package Body

3004
3004 Member Posts: 204,171 Green Ribbon
Hi Experts,
Iam facing problem while execute the package have more than 70 (IN) parameters and 1 (OUT) parameter, If i reduce the parameter below 70 and execute the same it works fine. Most of them are RAW datatype. Pasted below the error occured during the execution of the package

EXEC PKG01_INSERTFORMS.PKG01_PROC08_INSERT532('test',...,:var);

=======================
ERROR at line 1:
ORA-06550: line 1, column 258:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute cast trim forall
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
============================

Pls help me to overcome this issue, Thanks in advance

Regards,
Vijay
This discussion has been closed.