I am making a project in vb 6.0 and oracle 9i.In that i have created a sequence in oracle 9i for auto generation of nos.Now i want when i click the add button in vb 6.0 form the cityid for which i created the sequence should show the next value in the textbox.i have also created the procedure .but i don't know how to call that procedure in the vb 6.0.