2 PL/SQL blocks with ZEOS
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2015-12-19 16:04

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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i begin 
 execute immediate 'drop table tijd_oefen';exception   when others
then      if sqlcode != -942 then         raise;      end if;end;
  begin   execute immediate 'create table tijd_oefen as select * from
gb_hek';exception   when others then      if sqlcode != -942 then    
   raise;      end if;end;