Re: Dynamic Queries statement

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Mon, 3 Jun 2013 22:44:38 -0700 (PDT)
Message-ID: <b4b19bfb-d524-4ba6-b940-3af51805e24f_at_googlegroups.com>

Hi Javier,
i expect your quotes are not right. Try this:

        IF pp IS NOT NULL THEN
            v_query := v_query || ' AND DESCRIPCION LIKE ''%' || pp || '%''';
        END IF;
        IF status IS NOT NULL THEN
            v_query := v_query || ' AND ESTATUS LIKE ''%' || status || '%''' ;
        END IF;
       v_query := v_query || ' ORDER BY ID_TYP_ACTOR';

regards
Kay Received on Tue Jun 04 2013 - 07:44:38 CEST