I'm trying to execute a simple sql statement to insert some rows of data. The following works fine if I execute it through Aqua Data Studio, but when I try to use Oracle Enterprise Manager I end up getting the infamous pls-00103 error. This statement is not run inside a procedure, package, or function. The sole purpose of this is to initialize a table with data. The statement preceding this would be the table create statement.
I've tried putting in a slash on the end, removing the semi-colons, taking out the begin..end. Nothing is working. This shouldn't be that difficult. if anyone can point me in the right direction I'd much appreciate it.
for i in 1..32000 Loop
insert into caldates(caldate)