Hi ,
I have created DynamicSQL service,when service create time I fill up all fields in that.
Ex:- in SQL place written query i.e select * from ${name}
input JDBC Type input field Type input Type
VARCHAR java.long.string name
output JDBC Type output field Type outputType
VARCHAR java.lang.String ename
after this I pass table name[emp_salary] through input field “name”,but it rose exception is
Could not run ‘dynamicservice’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service jdbcservice.dynamicSql:dynamicAdapter.
[ADA.1.316] Cannot execute the SQL statement “select * from emp_salary”. "
(72000/1006) ORA-01006: bind variable does not exist
"
ORA-01006: bind variable does not exist
please say any one,how to execute DynamicSQL.
#webMethods#Adapters-and-E-Standards#Integration-Server-and-ESB