| Error -933: ORA-00933: SQL command not properly ended ORA-02063: preceding line from abc [message #47351] |
Wed, 11 August 2004 07:41  |
Hari
Messages: 59
Registered: August 2000
|
Member |
|
|
Hi,
Upon quering the view xxx_vw as given below
SELECT COUNT(1)
FROM xxx_vw
WHERE a = 'aaa'
AND NOT EXISTS (SELECT 1
FROM xxx_vw
WHERE b = 'bbb'
AND a = 'aaa');
I'm getting the following error.
Error -933: ORA-00933: SQL command not properly ended ORA-02063: preceding line from abc
The above error is coming upon using a correlated subquery.
A normal subquery on the same view doesn't throw any error.
The view xxx_vw is using database links which are pointing to Oracle 8i.
The view xxx_vw is on Oracle 9i.
Please let me know, how to solve the problem.
Is there is any compatability with 9i & 8i on using a correlated subquery on a view which using database links.
Thanks in advance.
-hari.
|
|
|
|
|
|
| Re: Error -933: ORA-00933: SQL command not properly ended ORA-02063: preceding l [message #48614 is a reply to message #47351] |
Fri, 03 December 2004 07:41  |
Danielle
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
CREATE OR REPLACE TYPE BODY Jogador_objtyp AS
MEMBER FUNCTION numero_de_gols RETURN INTEGER is
numeroGols INTEGER;
BEGIN
select (jogador.fez_ntab).count into numeroGols
from Jogador_objtab jogador;
RETURN numeroGols;
END;
MEMBER FUNCTION numero_de_gols(ano INTEGER) RETURN INTEGER is
numeroGols2 INTEGER;
BEGIN
select (jogador.fez_ntab).count into numeroGols2
from Jogador_objtab jogador, table(cast(jogador.escalado_para_ntab as Escalacao_ntabtyp)) escalacao,deref(escalacao.escalada_para_ref) jogo
where deref(jogo.pertence_a_ref).ano = ano;
RETURN numeroGols2;
END;
MEMBER FUNCTION numero_de_jogos(ano INTEGER) RETURN INTEGER is
numeroJogos INTEGER;
BEGIN
select (c.possui_ntab).count into numeroJogos
from Campeonato_objtab c
where c.ano = ano;
RETURN numeroJogos;
END;
END;
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
