1 Reply Latest reply: Oct 18, 2013 6:26 PM by Hussein Sawwan-Oracle RSS

    Web Enabled Plsql on r12

    User529649-OC

      Hello,

       

      This is on Oracle EBS r12.1.3 on 11g r2 database enterprise edition.

       

      I need to develop  a web based plsql  user interface and this is the first time this is being done on our system.  Below is the code I have written. Then, I registered the package and procedure as web plsql under AOL and also registered it as a function.

       

      Now, this is where I am stuck, how do I launch the procedure as a URL from browser window?  When I tried to enter with Oracle EBS URL/procedure name, it says "Page not found" or "Page can't be displayed".

       

      Please advice

       

      Code below

       

      /* Formatted on 10/17/2013 3:43:27 PM (QP5 v5.252.13127.32867) */

      create or replace package body xxch_traveler

      as

         procedure submit_data

         is

            p_wo_name   varchar2 (40);

         begin

            htp.htmlopen;

            htp.headopen;

            htp.title ('Travelers Work Order Entry');

            htp.headclose;

       

       

            htp.bodyopen;

       

       

            htp.tableopen (cborder       => 1,

                           calign        => 'Left',

                           cnowrap       => null,

                           cclear        => null,

                           cattributes   => null);

       

       

            htp.tablerowopen;

       

       

            htp.img (curl          => 'http://orauser.channell.local:8001/logo.jpg',

                     calign        => 'Left',

                     calt          => null,

                     cismap        => null,

                     cattributes   => null);

            htp.tablerowclose;

       

       

            htp.tablerowopen;

            htp.tabledata (cvalue        => 'WO#',

                           calign        => 'Left',

                           cdp           => null,

                           cnowrap       => null,

                           crowspan      => null,

                           ccolspan      => null,

                           cattributes   => null);

       

       

            htp.tabledata;

            htp.formtext (cname         => p_wo_name,

                          csize         => '30',

                          cmaxlength    => null,

                          cvalue        => null,

                          cattributes   => null);

            htp.tablerowclose;

            htp.tableclose;

            htp.bodyclose;

            htp.htmlclose;

         end;

      end;