OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » how to view procedure in browser written in mod

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how to view procedure in browser written in mod_plsql. (orace XE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to view procedure in browser written in mod_plsql. [message #348208]

Tue, 16 September 2008 00:46

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.

Attachment: browser_view.jpg
(Size: 6.46KB, Downloaded 1467 times)

Report message to a moderator

Re: how to view procedure in browser written in mod_plsql. [message #352383 is a reply to message #348208]

Tue, 07 October 2008 07:24

misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india

Senior Member

Here I would like to share what i did. I simply replace '<' with '<' and '>' with '>'.
It is giving desire result.

 v_script:= dbms_metadata.get_ddl(
                                  obj_type,
                                  obj_name,user
                                 );
 v_script:= replace(v_script,
                         '<',
                      '&lt;'
                    );
 v_script:= replace(v_script,
                          '>',
                       '&gt;'
                    );
 htp.p('<pre>'||v_script||'</pre>');

result is :

Quote:

procedure create_user_list is
begin
htp.p('<SELECT NAME="T_USRS" disabled>');
-- we will drive this space with cursor.
htp.p('<OPTION value="'||user||'">'||user||'</OPTION>');
htp.p('</SELECT>');
HTP.BR;
HTP.BR;
end create_user_list;

Report message to a moderator

Previous Topic:	APEX,object browser
Next Topic:	Select multiple value in LOV

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 22 23:01:15 CDT 2025