|
-
1) You don't need a cursor on the table.
2) You need to open the file, read the first line and declare a while loop that exits when you get no data found.
3) Inside the above loop do an update that updates the table if the records are newer.
4) close the file
5) include an exception section that closes the file and reraises any error.
If you really want to learn PL/SQL get a good PL/SQL book and write the procedure. Doing is the best form of learning.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|