SQL & PL/SQL

Hello alls,

well, first of all I'm quite new to Oracle so please be patient if I'm asking something silly.

I'm working on a procedure on a Oracle 9i database. The procedure loops on a cursor and, inside the loop, it updates the same table it's looping on. I have some conditional statements that works on these updates. But there's something wrong because when I query the table inside the cursor I don't find data that must be updated.

I've used commit statements to store data but it seems to not work properly.

I've not posted the code for two reason. First of all, it's about 1300 lines of code and the second problem is that it's use italian names for variables and procedures because of customer needing. Anyway if you think it could be useful I can try to post parts of the code.

Thanks a lot for your help,
Lorenzo.