select cpw.id_rede_pais, cpw.cd_pais
into vid_rede_pais , vcd_pais
from ods_bipub.trr_certifica_pais_webservice cpw
where cpw.id_rede_pais not in (Select cees.id_rede_mae
from ods_bipub.trr_certifica_estrutura cees)
and rownum =1;
O erro é o seguinte :
ERROR at line 2:
ORA-00905: missing keyword
select cpw.id_rede_pais, cpw.cd_pais
into id_rede, cd_pais
from ods_bipub.trr_certifica_pais_webservice cpw
where cpw.id_rede_pais not in (Select cees.id_rede_mae
from ods_bipub.trr_certifica_estrutura cees)
and rownum =1;
select cpw.id_rede_pais, cpw.cd_pais
from ods_bipub.trr_certifica_pais_webservice cpw
where cpw.id_rede_pais not in (Select cees.id_rede_mae
from ods_bipub.trr_certifica_estrutura cees)
and rownum =1;
declare
vid_rede_pais ods_bipub.trr_certifica_pais_webservice%type;
vcd_pais ods_bipub.trr_certifica_pais_webservice%type;
begin
select cpw.id_rede_pais, cpw.cd_pais
into vid_rede_pais , vcd_pais
from ods_bipub.trr_certifica_pais_webservice cpw
where cpw.id_rede_pais not in (Select cees.id_rede_mae
from ods_bipub.trr_certifica_estrutura cees)
and rownum =1;
end;