Using Stored Procedure via datawindow
I am trying to retrieve data (through a parameter) from sql server based Stored Procedure via a datawindow but running into an error. The error is "invalid character value for cast specification". Below is part of the edit source of the datawindow
procedure="1 execute dbo.usp_select_auditexport;1 @export = :export" arguments=(("export", string)) )
When I try to retrieve data in test by running the datawindow in PB and get the pop up of export and whether I put in a string value with or without quotes I get the error.
During runtime too I get a similar error of "invalid argument value". example dw_auditexport.retrieve(ls_export) . The ls_export is set 'M'. Please help.