Need help fixing this error please:NameError: global name is not defined

[shaun]

Hi all,

 I have a class which I create an object from in a different script but when its run I get an error at the last part of this method:

////CODE///////////////////////////////

def databasebatchcall(self,tid, bid):
        con=cx_Oracle.connect('user/user123 at odb4.dcc.company/ODB4TEST.COMPANY.COM')
	cur = con.cursor()
	cur.execute("SELECT * FROM name)
	results = cur.fetchall()
//////////////////////////////////////////

>From this last line I get the following error which I don't understand I'm very new to python and have no idea about this any help would be appreciated


//////////////////////////////////////////////

File "/home/dcroke/mdcFDACStringCall.py", line 21, in fetchbatchdata
    results = cur.fetchall()
NameError: global name 'cur' is not defined

//////////////////////////////////////////////


Thanks all, 
Shaun