Have not used Continue, but the following works
[code=oracle]
DECLARE
..
i NUMBER;
BEGIN
FOR i <10
LOOP
IF i = 5
UPDATE ABC ....;
END IF
END LOOP;
[/code]...
skkydiver
Last Activity: Feb 14 '08, 11:41 PM
Joined: Jan 11 '08
Location:
-
Hi, not sure if you solved this problem but in case you have not I might suggest the following as possible reasons for Oracles error as the syntax looks good to me:
- Lack of Delete privs on the tables
As an aside to your specific question, if the tables that you are deleting are large tables - you should consider executing COMMIT inside your loop every 1000 of records to avoid "blowing" your rollback seg...Leave a comment:
-
Thank you for the reply, I tried your suggestion and I have not been able to get it to do what I want. Specifically (failed to mention this earlier) that I would like this to be dynamic in nature, that is, I would like to be able to specify the following at the time of the execution of the Macro:
1. name of the source database
2. format of the output ( comma or tab delimited)
3. name of the output file
...Leave a comment:
-
Command Line - Export
Hello,
Is there a way to use the command line (Access 2003) to export Access tables to text files?
Thanks
skkydiver
No activity results to display
Leave a comment: