1 2 Previous Next 20 Replies Latest reply on Feb 10, 2014 9:37 PM by user12923153 Go to original post
      • 15. Re: UTL_HTTP use?

        I don't know if the packages UTL_HTTP is well installed especially the BODY UTL_HTTP !! how do I know if it is well installed??

        this is what I have made:


        1)  I run SQL  plus and

        connect as system user  and:

        SQL> grant execute on UTL_HTTP to meteo;

        Grant succeeded.

        2) connect my username/password and

        select utl_http.request('http://aviationweather.gov/adds/metars/') from dual;



        <meta name="DC.date.created" content="2003-07-21" scheme="ISO8601" >
        <meta name="DC.date.reviewed" content="2007-10-09" scheme="ISO8601" ><script typ

        e="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jque

        <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery

        <script type="text/javascript" src="/static/adds/javascript/tafs/getMetarsTafs.j

        <script type="text/javascript" src="/static/javascript/navigation.js"></script>
        <script type="text/javascript" src="/static/javascript/library.js"></script><lin

        k href="/layout/awc/favicon.ico" rel="shortcut icon" >


        <link href="/layout/awc/mystyle.css" media="" rel="stylesheet" type="text/css" >

        <link href="/layout/awc/cwi/main.css" media="" rel="stylesheet" type="text/css"
        <link href="/layout/css/form.css" media="" rel="stylesheet" type="text/css" >
        <link href="/layout/css/layout.css" media="" rel="stylesheet" type="text/css" >
        <link href="/layout/awc/cwi/menu.css" media="" rel="stylesheet" type="text/css"
        <link href="/static/css/user.css" media="" rel="stylesheet" type="text/css" >
        <body onload="init()" onunload="unload(map)">


        <div style="width:600px">
        <div id="user_form"><a href="/qicp/login" >QICP Login</a>    <a h

        ref="/qicp/index/description">Registration info</a></div><!-- end #user_form


        still the same problem ORA-06508 PL/SQL: could not find program unit being called???  what else can be done??


        I think I have a problem with the BODY UTL_HTTP!!! really I need your help Mr Thank you .

        • 16. Re: UTL_HTTP use?

          Are you directly use this utl_http through forms?

          • 17. Re: UTL_HTTP use?

            in fact form Enterprise Manager Console I connect as system user, under the package node I edit UTL_HTTP(Specification) and copied its contents, now  form my form l create a package I named it UTL_HTTP and past the content here compile the package in my form and well compiled ; when I try to make he same steps to UTL_HTTP body under the package node for the system user in Enterprise Manager Consoler, I have got an error source could not be displays because it is wrapped.


            now from my form and under Program Unit node I have just UTL_HTTP(Specification) I think if i have UTL_HTTP(Body) under my Program Unit node my problem may be solved??

            • 18. Re: UTL_HTTP use?

              Why you are copy utl_http full code to form. Just give the execute priviliage to your user on utl_http. Then, in database create one procedure and you can call that procedure to passing xml as a parameter like below


              From form

              Framing the xml and call the below procedure which is present in database like



              CREATE OR REPLACE PROCEDURE test_proc(p_xml CLOB)



              -- process yourr code here

              --- UTL_HTTP code




              The sameway we are accessing webservice from our end.

              • 19. Re: UTL_HTTP use?
                Christian Erlinger

                in fact form Enterprise Manager Console I connect as system user, under the package node I edit UTL_HTTP(Specification) and copied its contents, now  form my form l create a package I named it UTL_HTTP


                o_O And why did you do that? Leaving aside even if it would work (The body most certainly is wrapped, plus utl_http is based on a C-dll) you would duplicate the code, which is not a good idea at all.


                Why not just

                - grant execute on utl_http to your user

                - create a stored procedure in your schema doing all the utl_http related stuff

                - use that stored procedure from within forms



                • 20. Re: UTL_HTTP use?

                  thank you a lot Mr my probleme is solved.  your suggestions were  verry helpfull.

                  1 2 Previous Next