Thanks Peter ..your hint and some additional stuff has helped me to work it out..

yes,

 this is how i do it

vstrSQL = "PS_SEARCH_MASTER_PRODUCT_TEST " & vstrDPCI     

robjRS.CursorLocation = adUseClient

robjRS.Open vstrSQL, cnRun.ConnectionString, adOpenStatic, adLockReadOnly

vstrDPCI is the input parameter & PS_SEARCH_MASTER_PRODUCT_TEST is the stored procedure name and...