Hi all
Using Delphi and ADO I'm trying to execute this code but I get the error message:
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: <...>
Any ideas how to solve this? I want to make as few roundtrips to the database as possible.
Thanks
Stefan Olofsson
begin
create table tmp131F2BE063034E201DEFA31C
(Id varchar(24) not null,
Object varchar(24) not null,
HighestVersion integer not null);
alter table tmp131F2BE063034E201DEFA31C add constraint x131F2BE063034E201DEFA31C primary key (Id);
insert into tmp131F2BE063034E201DEFA31C
select distinct
V.Id,
V.Object,
case when V.Superseded = 2958465 then 1 else 0 end HighestVersion
from
advSv_131F2BE063013020312BB55B,
advVer V
where
advSv_131F2BE063013020312BB55B.NodeAddress = '131F2BE06302DAE02EBBE870' and
advSv_131F2BE063013020312BB55B.LvShow = 1 and
V.Id = advSv_131F2BE063013020312BB55B.Version;
end;
] 
Blog
Search
Help
Members
Register
Login
Home
