This discussion is archived
1 Reply Latest reply: Oct 18, 2013 4:26 PM by Hussein Sawwan-Oracle RSS

Web Enabled Plsql on r12

User529649-OC Explorer
Currently Being Moderated

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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points