Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Performance & Availability
This discussion is archived
on Jun 6, 2012 8:24 AM by 941905
Apply Error - ORA-00936
Feb 21, 2012 3:04 PM
I have several of these error messages a day. They appear in the .trc file as follows:
PARSE ERROR #12:len=83 dep=1 uid=0 oct=7 lid=0 tim=1298603162899498 err=936
DELETE /*+ restrict_all_ref_cons */ FROM "SATURN"."SSRRTST" WHERE and rownum < 2
XCTEND rlbk=1, rd_only=0
XCTEND rlbk=1, rd_only=1
Streams : knalsptxn
error 936 during error queue execution or user function.
*** 2012-02-20 14:27:18.809
ORA-00936: missing expression
Basically there is a WHERE clause with no specified criteria. Has anyone seen this and know where to start to fix the problem?
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Apply Error - ORA-00936
Jun 6, 2012 8:24 AM
in response to
Execute this statement and re-execute all apply error.
DBMS_APPLY_ADM.SET_PARAMETER(apply_name => '<...>',parameter => '_DYNAMIC_STMTS',value => 'N');