Skip to Content
avatar image
Former Member

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.


KB

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 23, 2015 at 01:24 PM

    Hello Kwadwo,

    Which PB version?

    Are you connecting through ODBC?

    If yes, please take a look at the PBNewsSPInvocation DBParm to see if it improves the situation (value should be set to 'Yes'):

    SyBooks Online

    I think it must be correlated with other DBParm StripParmNames (value should also be set to 'Yes'):

    SyBooks Online

    HTH,

    Jacob

    Add comment
    10|10000 characters needed characters exceeded