DELETE_OLD_SNAP_RECORDS

[Former Member]

Hello experts, I'm getting an error in this program!

form delete_old_snap_records.

data: reorg_date type d.

data: begin of delt occurs 20.

include structure snap_beg.

data: end of delt.

reorg_date = sy-datum - 28.

select distinct datum uzeit ahost uname modno mandt from snap_beg

up to 200 rows

into corresponding fields of table delt

where datum lt reorg_date and xhold <> 'X'

%_hints oracle 'INDEX("&TABLE&" "SNAP~DSX")'.

loop at delt.

<b>delete from snap</b>

where datum = delt-datum

and uzeit = delt-uzeit

and ahost = delt-ahost

and uname = delt-uname

and modno = delt-modno

and mandt = delt-mandt.

commit work.

endloop.

endform. "delete_old_snap_records

At the bolded area as delete from snap an error is occuring can you please help? This is a standard problem!

Thank you

Tatenda Chaibva

[Former Member]

What is the error?

Rob

[Former Member]

The Is as follows,

Database error 8102 at DEL access to table SNAP

Is this what you are asking?

In addition to this,

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "DELETE_OLD_SNAP_RECORDS" "(FORM)", but it was neither handled

locally nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPMS380 "; its source code begins in line

1031 of the (Include program "MS380F10 ".

null

[Former Member]

If there are no notes, send it to OSS.

Rob

[Former Member]

<b><REMOVED BY MODERATOR></b>

Thanks

Murali Poli

Message was edited by:

Alvaro Tejada Galindo