how to call procedure with dynamicSQL adapter?

, ,
1

I need to call pl\sql procedure with dynamicSQL jdbc adapter. Any help? DB procedure below:

create or replace
PROCEDURE TESTPROCEDURE1(var1 in VARCHAR2, var2 out VARCHAR2) AS
BEGIN
var2:=‘aaa’;
END TESTPROCEDURE1;

2

Please use the search functionality on this section with the keyword dynamicSQL and you see various results and take the syntax from there:

HTH,
RMG

3

i haven’t found an answer…

4

Why do you want to use DynamicSQL instead of StoredProcedure?
From what you are showing, it’s perfect to call it using StoredProcedure type.

5

OK…Are you not able to use with stored procedure with signature template?

HTH,
RMG

6

This case is related to my another problem generic JdbcAdapter for stored procedures - webMethods - Software AG Tech Community & Forums

No one try to call procedure from dynamicSql or customSql?