MS SQL vs. Oracle script

@YearR

Hello everyone,

I got a bit of a problem and hope that maybe some of you might shed some light on it and how it should be done

I got the following in my import script. And it works for MS SQL Databases

Period=fdmcontext["PERIODNAME"]

YearR=Period[:4]

params=[YearR]

query = """declare @YearR varchar(4)

SET @YearR= ?

insert into AIF_OPEN_INTERFACE

SELECT * FROM  TABLE1

WHERE jahr=@YearR AND konto <> 'xxxxxxxxxxxx'

"""

print fdmAPI.executeDML(query, params, False)

fdmAPI.commitTransaction()

But for Oracle DB it does not work. The problems are variables, but I dont know how to fix this

That is the first part of the problem.