When I am invoking database adapter select operation, I don't see any fields inside Invoke1_SelectSelect_InputVariable ( which i am supposed to see for mapping). Can somebody let me know what is problem. Currently I am reading a value and if the input value is equal to the field value in view it has to retrieve all the values related to that field.
In the define selection criteria screen you have to add parameters and then use the parameters prefixed with # in the SQL expression... Once you've done that then the wizard should generate the fields into the input variable xsd...
Hope this helps...
When you use select operation, you can see the fields values/definition in the output variables and not in the input.
As Vlad mentioned, in the input parameter you will see only parameters you've defined (if at all) in your wizard.
I hoped that answer your question.
Thanks for your response, now i am getting a new problem. Actually the input parameter that i am getting from other database adapter is of type timestamp and I have to match this value with other field which is also a type of timestamp, if this two values are equal then i have to retrieve all the value related to timestamp. I used assign activity for mapping purpose, but bpel by default converting this timestamp value into 2013-01-20T00:00:00.000-05:00 this format, hence the other field which is of type timestamp is not understanding and is throwing error.