on 10-01-2013 7:43 PM
All,
I have written a simple abap code to select messages in error in Java Stack from tabel BC_MSG:
REPORT zjava_msg_status1.
TABLES : trfcqstate, sxmspmast, sxmspemas.
DATA: BEGIN OF ty_bc_msg,
t_msg_id TYPE c,
t_direction TYPE c,
t_to_service_name TYPE c,
t_from_service_name TYPE c,
t_action_name TYPE c,
t_status TYPE c,
t_sent_recv_time TYPE trfcqstate-arfcdatum,
t_tran_delv_time TYPE trfcqstate-arfcdatum,
t_schedule_time TYPE trfcqstate-arfcdatum,
t_recv_action_name TYPE c,
t_recv_action_type TYPE c,
END OF ty_bc_msg.
DATA F3 VALUE ' ERROR '.
EXEC SQL PERFORMING LOOP_OUTPUT.
SELECT MSG_ID INTO :ty_bc_msg FROM SAPDEVDB.BC_MSG WHERE
STATUS = :F3
ENDEXEC.
FORM LOOP_OUTPUT.
WRITE: ty_bc_msg-t_msg_id.
ENDFORM.
But I am getting the following error on the highlighted line when I execute this program:
Please advice.
Hi Vicky,
Tell your basis team to check these notes
Note 834917 - Oracle Database 10g: New database role SAPCONN
Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.