komeny wrote:Always post code using <tt>\
We use Oracle 220.127.116.11.0 with Application Express 4.1.1.00.23.
In an 'On Load - After Header' process, we commented out a piece of code:
</tt> tags as described in the FAQ.
/* IF :APP_TEAM_COMPATIBILITY = 0 THEN :P613_DELETABLE := 0; END IF; */
After 'Apply Changes' we haven't got any error message. The process was tested, and it worked well. Then, in the production system, dozens of users got this errormessage:Post the complete process code, with and without the comments.
ORA-06550: Zeile 43, Spalte 3: PLS-00103: Encountered the symbol ";" when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge The symbol "exit" was substituted for ";" to continue.
We deleted the commented part, and now it works again.
Could you please explain what happened?
Is that allowed to use /**/-type comments in processes?
SELECT ... INTO ... FROM .... WHERE ....; SELECT COUNT(*) INTO ... FROM ... WHERE ....; IF :P613_ITEM1 < :P613_ITEM2 THEN :P613_DELETABLE := 1; ELSE :P613_DELETABLE := 0; END IF; IF :P613_ITEM3 IS NULL THEN :P613_DELETABLE := 0; END IF; /* IF :APP_TEAM_COMPATIBILITY = 0 THEN :P613_DELETABLE := 0; END IF; */