Provider cannot derive parameter information and SetParameterInfo has not been called. (Microsoft OLE DB Provider for Oracle)
I am getting the above error while opening the parameter box at OLEDB source for Oracle using SQL command option at Data Access Mode? Can you any one please help me in this regard and trouble shoot this problem..
You could try using an expression instead of parameters: http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx
-Jamie
|||
Jamie,
I followed your suggestion , but still i am not able to set the parameters at parameter window, becoz its does't prompt after click on parameter button. Right now i am working on 9i version..can i update with 10g to work on this ?
|||
If you followed my suggestion then you wouldn't have to set parameters using the parameter window. They can be built into the expression.
-Jamie
|||Yup..its working now..Thank you Jamie.
No comments:
Post a Comment