Error while applying support packages

[karthik532]

Hi,

I want to know how to delete table entries( in pat03 and pat01) if support package is strucked.
Thanks in advance.

Regards,
karthik.

[shankar dora]

if it is sql .open sql studio manager
run new query there u have to give the below

delete from sid.PAT01 where STEPCOND='?' and the execute .it will show u 1 row deleted
delete from sid.PAT03 where STATUS='?' and the execute .it will show u 1 row deleted

if oracle login

sqlplus "/as sysdba"

delete from sapsid.PAT01 where STEPCOND='?'
delete from sapsid.PAT03 where STATUS='?'

this should clear ur queue .