2 PL/SQL blocks with ZEOS

[Hansvb]

In a memo i put 1 pl/sql block and then execute it with tzquery (Zeos). That works fine.
When i put 2 pl/sql block in the memo, ik get a warning than a " begin" is found at line 11. That is the begin of my second pl/sql block.
Is it possible to put a few pl/sql blocks in a memo en execute a zquery? it works fine with the sqlquery in sqldb. But i want to use zeos for all my query's so i tried Zeos.


this is my sql:

Code: Pascal  [Select][+][-]

1. begin
2.    execute immediate 'drop table tijd_oefen';
3. exception
4.    when others then
5.       if sqlcode != -942 then
6.          raise;
7.       end if;
8. end;
9.  
10.  
11. begin
12.    execute immediate 'create table tijd_oefen as select * from gb_hek';
13. exception
14.    when others then
15.       if sqlcode != -942 then
16.          raise;
17.       end if;
18. end;