Hi,

I am new to the WebFOCUS tool and I am using stored procedure in SQL Report to get the data using parameters from the database. I am getting following error.

The Error:

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 22018
: Microsoft OLE DB Provider for SQL Server: [22018] Invalid character valu
: e for cast specification.
L (FOC1405) SQL PREPARE ERROR.

SQL Report code:

ENGINE SQLMSS SET DEFAULT_CONNECTION BMC
SQL SQLMSS
EX usr_collection_efficiency_history
@subscriber_key,@collateral_type_key,@peergroup_portfolio_key,@Peergroup_footprint_key,
@loan_origination_type_key;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END

This message has been edited. Last edited by: Kerry,

That error usually means that you are passing a character value for an integer, or char for date etc. Are you supplying the proper values for your arguments? Also, are the @ symbols suppose to be ampersands (&)?

quote:

dhagen

Thanks a lot for help. Actually I was passing the parameter names instead of values. Now it is working perfectly after passing values. But I need to change the values dynamically where I can assign my filter values to the parameters. Please let me know how do assign values dynamically.

Here's a previous posting of mine...

https://forums.informationbuilders.com/eve/forums/a/...051009331#1051009331