PL/SQL (MOSC)

MOSC Banner

Find string in all packages

edited Feb 22, 2013 5:13AM in PL/SQL (MOSC) 7 commentsAnswered ✓
Dear community:

I hope you can help me out with this task I have to do. I need to find all packages that have a url or uri reference like the example show next:

begin

       --PRODUCCION

SELECTIVIDAD.marcaje_operacion(p_numidentif,1,'http://comext.aduana.cl:7001/SelectividadWeb/TestMarcaje.do',v_codErrorMarcaje,v_glosaErrorMarcaje) ;

        --DESARROLLO

       selectividad.marcaje_operacion(p_numidentif,1,'http://geminis.aduana.cl:7001/SelectividadWeb/TestMarcaje.do',v_codErrorMarcaje,v_glosaErrorMarcaje) ;

            insert into patty (dice) values ('Selectividad -'||p_numidentif||'-'||v_codErrorMarcaje||'-'||v_glosaErrorMarcaje);

           commit;      

         ---TEST

SELECTIVIDAD.marcaje_operacion(p_numidentif,1,'http://wldesarrollo.aduana.cl:7001/SelectividadWeb/TestMarcaje.do',v_codErrorMarcaje,v_glosaErrorMarcaje)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center