Error message
sirisha, November 17, 2016 - 7:02 pm UTC
HI, I tried this today with little modifications, but I am getting the following error messages.
sql> set serverout on
sql> declare
2 c int;
3 begin
4 for i in (select * from table) loop
5 execute immediate
6 'select count(*) from'||i.owner||'.'||i.table_name||'where code not in (''xyz'')'
7 into c;
8 dbms_output.put_line('found'||c||'occurrences in'||i.owner||'.'||i.table_name);
9 end loop;
10 end;
11 /
declare
*
error at line 1:
ora 00933:sql command not properly ended
ora 06512:at line 5
SQL>
next time when i ran the same code the following error
ora 00923: from keyword not found where expected
ora 06512: at line5
November 18, 2016 - 4:16 am UTC
show us your *whole* script from top to bottom