Page 1 of 1

Error while applying support packages

Posted:
by 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.

Re: Error while applying support packages

Posted:
by 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 .