Hi friends
I am resolving some troubles in application. This SQL Statemet works fine in Oracle9i but Now it does not work in Oracle8i. Up to 2 days ago this was function well.
insert into parecidos (par_score, par_cli_id, par_cli_fve_id, par_cli_cep_id, par_id, par_cli_razon_social, par_cli_nombre, par_cli_rif, par_cli_ci, par_cli_geoname, par_campo ) select * from ( select score(1) SCORE, cli_id, cli_fve_mantenimiento, cli_cep_id, 9921 par_id, cli_razon_social, cli_nombre, cli_rif, cli_ci, cli_geoname, 1 from clientes where (contains ( cli_nombre, 'ABASTOS%' ,1) > 0 ) and cli_geoname in ( select geoname from lista_geonames ) order by score desc )
ERROR at line 1:
ORA-29909: label for the ancillary operator is not a literal number
PROD>
I checked the tables involved in the sentences and they have the same structure. Somebody here know how can I resolve this ?
The problem is caused by this (
score(1) SCORE )
Joel Pérez