APEX

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!

Automatic Row Processing fetch error (ORA-00936: missing expression)

507059Dec 14 2006 — edited Mar 22 2007

Hi there,

I have a bit of a problem setting up automatic row processing. The Apex processing is causing an error, but I'm not sure what PL/SQL code is being run (obviously, I don't have access to the Apex code) and all I get is the error following:

0.13: Processing point: AFTER_HEADER
0.13: ...Process "Notes load": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:PUPIL_NOTE:P29_PUPIL_ID:PUPIL_ID:P29_ACHIEVEMENT_SET_ID:ACHIEVEMENT_SET_ID
0.16: Show ERROR page...

and then the following exception report on the page:

ORA-06550: line 1, column 17: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 9: PL/SQL: SQL Statement ignored

Can anyone tell me how I can diagnose the problem?

Many thanks,

Robert

Message was edited to change subject

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2007

Added on Dec 14 2006

#apex-discussions

16 comments

4,007 views