Code: Select all
Insert into schema.Table_name
(Column1,
Column2)
(Select Clm1,
Case when #Param2#=0 Then 'Clm2'
Else 'Test' end as Colm2
From Table2)
But I am seeing below error
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 911: Msg = [Oracle][ODBC][Ora]ORA-00911: invalid character
Any suggestion how to correct this error?