[Pascal Error] YourUnit.pas(224): E2015 Operator not applicable to this operand type

I’ve got this error when was concatinating stings to build pl/sql call. Here’s an example code: sql := ‘begin ‘ + packageName + ‘.calc_report(‘ + ‘ in_dateend=>to_date(”’+ LMRFrm.a_Date2_i + ”’,”dd/mm/yyyy”),’ + ‘ in_code_list=>”’ + LMRFrm.a_ListCat_i + ”’,’ + ‘ in_currency=>”’ + LMRFrm.a_currency + ”’,’ + ‘ in_kr=>”’ + LMRFrm.a_kr + ”’,’ + ‘ in_vseason=>”’ + […]

VBA: Run-time error 3001 Arguments Are Of The Wrong Type… when setting ADODB.Command object members

This forum post saved my day.I was trying to run Oracle stored procedure with output parameters from Excel VBA with the following piece of code: Dim cmd As ObjectDim resultSet As ObjectSet cmd = CreateObject(“ADODB.Command”)With cmd .CommandText = “PK_AUTH.LOGON” .NamedParameters = True .Parameters.Append .CreateParameter(“login”, adVarChar, adParamInput, 50, login_) .Parameters.Append .CreateParameter(“pass”, adVarChar, adParamInput, 50, pass_) .Parameters.Append […]