BUENOS DIAS AMIGOS TENGO EL SIGUIENTE SCRIPT
Código PHP:
create or replace
FUNCTION "EX" ( cod NUMERIC)
RETURN VARCHAR
IS
BEGIN
DECLARE
resulta VARCHAR(1);
cod INTEGER;
BEGIN resulta:= 'N';
SELECT cod_det_car INTO cod FROM fac.det_car fac
WHERE (cod_det_car=cod AND dc.cubiert = 'S' AND dc.requier_autor = 'S' AND dc.nro_autorizacion);
IS NOT NULL dc.nro_autorizacion = ''
BEGIN
DECLARE
OR sal.getReqAutoNoCoberContradc.contrato = 'S' AND dc.cubierto = 'N'
AND dc.nro_autorizacion
IS NOT NULL dc.nroautor = ''
IF cod>0
THEN result := S;
RETURN result;
END;
END;
ME SACA LOS SIGUIENTES ERRORES
Error(10,5): PL/SQL: SQL Statement ignored
Error(11,32): PL/SQL: ORA-00920: invalid relational operator
Error(12,5): PLS-00103: Encountered the symbol "IS" when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge
DE ANTEMANO MIL GRACIS A TODOS LO QUE ME ÚEDAN COLABORAR