SQL Statement not allowed

[Former Member]

I am using the sender jdbc sender adapter.

I had given the SQL Query:

EXECUTE xyz;

i am getting SQL Exception.

SQL Statement not allowed in adapter monitoring.

Gaurav

[bhavesh_kantilal]

Gaurav,

Which DB are you trying to access?

Oralce Stored Procedures are supproted on Sender JDBC adapter only from Sp16 onwards.

Also, you need not give the semicolon. the statement should be,

EXECUTE SPNAME

Regards

Bhavesh

[moorthy]

Hi,

Which database you are using ?

Are you executing the Stored Procedure ?

check out this for the syntax etc-

http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Moorthy

[Former Member]

Hi Gaurav,

try to process your statement with a different tool;e.g. TOAD

or ask your database employees if the can execute your statement.

Than you'll see what the error is.

Regards Mario