Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Former Member


Do not forget to mark this thread as answered

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question