In the FME ,we have included python startup script. When we run it in FME 2014 version, it showing an error like : name 'dbCursor' is not defined.Could you please temme what would be the reason?

@takashi Here is the actual script

import fmeobjects

 

import cx_Oracle

 

import sys

 

#Getting the database paramters

 

service = FME_MacroValues['DBService']

 

userName = FME_MacroValues['DBUserName']

 

password = FME_MacroValues['DBPassword']

 

updateImportIDProc= 'NBN_DATA_OWNER.UPDATE_NBN_DATA_LOG'

 

getImportIDProc = 'NBN_DATA_OWNER.GET_NBN_IMPORT_ID'

 

#Getting the current process Id

 

importID =-1

 

#Creating connecting strings

 

connectionString = userName + '/' + password + '@' + service

 

try:

 

dbConnection = cx_Oracle.connect(connectionString)

 

dbCursor = dbConnection.cursor()

 

dbCursor.callproc(updateImportIDProc,('UPLOADING','NBN_FPRNT'))

 

#checking the run status of 01_CleanUp_Input.fmw workspace

 

id = dbCursor.var(cx_Oracle.NUMBER)

 

dbCursor.callproc(getImportIDProc,('NBN_FPRNT',id))

 

#raise Exception("Translation failed, 01_CleanUp_Input.fmw is not yet finished")

 

importID = id.getvalue()

 

if importID==-1:

 

raise Exception(message)

 

if dbCursor is not None:

 

dbCursor.close()

 

dbCursor=None

 

if dbConnection is not None:

 

dbConnection.commit()

 

dbConnection.close()

 

dbConnection=None

 

except Exception, e:

 

print str(e)

 

importID = -1;

 

if dbCursor is not None:

 

dbCursor.close()

 

dbCursor=None

 

if dbConnection is not None:

 

dbConnection.commit()

 

dbConnection.close()

 

dbConnection=None

 

sys.exit()