Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » how to show procedure on browser.? (oracle xe)
how to show procedure on browser.? [message #346997] Wed, 10 September 2008 06:46 Go to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

hi,
i have one procedure. script is

PROCEDURE create_user_list
IS
BEGIN
   HTP.p('<SELECT NAME="T_USRS" disabled>');
   HTP.p('<OPTION value="'||user||'">'||user||'</OPTION>');
   HTP.p('</SELECT>');
   HTP.br;
   HTP.br;
END create_user_list;


when i an trying to extract procedure definition, browser is
interprating htmp tags. code extraction logic is

PROCEDURE get_def (obj_type IN VARCHAR2,
                   obj_name IN VARCHAR2)
IS
   v_script VARCHAR2(32000);
BEGIN
   IF ((obj_type IS NULL) OR (obj_name IS NULL)) THEN
       HTP.p('please fill desired parameters..!');
   ELSE
       v_script:= DBMS_METADATA.GET_DDL(obj_type,obj_name,user);
       HTP.p('<pre>'||v_script||'</pre>');
   END IF;
   HTP.anchor('javascript:history.go(-1)','Back');
END get_def;


Current output is attached as image.
Please suggest how can we display object source code on browser.
Re: how to show procedure on browser.? [message #347007 is a reply to message #346997] Wed, 10 September 2008 07:23 Go to previous message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

hi administrator,
Can you please move this topic to 'Application Express &
MOD_PLSQL'. i posted on wrong place.

sorry.
Previous Topic: i am getitng error system01.dbf need more recovery
Next Topic: Internal server error
Goto Forum:
  


Current Time: Thu Mar 28 10:57:18 CDT 2024