Recent

Author Topic: 2 PL/SQL blocks with ZEOS  (Read 1346 times)

Hansvb

  • Sr. Member
  • ****
  • Posts: 351
2 PL/SQL blocks with ZEOS
« on: December 19, 2015, 05:04:51 pm »
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;


 

TinyPortal © 2005-2018