Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to use sql variables in jdbc send adapter??

Hi,

i wanna use a variable in the sql statement in the jdbc send adapter.

i know i can key sql statement in the "Query SQL Statement" in the jdbc send adapter.but i dont know how to use variables in the sql statement.

i mean, for example, the sql statement is "SELECT * FROM t_student WHERE READFLAG = 0", but now i wanna instead of "0"(the value of the READFLAG) using a variable.

and if i can use a variable to replace the "0"(the value of the READFLAG above sql statement), then how can i send a value to the variable??

request help in the regard.

thx in advance.

Brian

Former Member
Former Member replied

Hi

Try to use Stored procedure to achieve this

for SQL DB Sender Stored procedure with XI Sender Adapter supported

but with oracle it has some restrictions ,

Am not sure but with service pack SP15 and with oracle 10.2 series Sender JDBC supports Stored procedure or else u cannot go with Stored procedure with Oracle

refer sapnote : 941317

thanks

Srini

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question