Skip to content

Instantly share code, notes, and snippets.

@anonymoustafa
Created January 8, 2025 04:40
Show Gist options
  • Save anonymoustafa/bbf8216aa1aca538841922a8d6d31b19 to your computer and use it in GitHub Desktop.
Save anonymoustafa/bbf8216aa1aca538841922a8d6d31b19 to your computer and use it in GitHub Desktop.
Oracle Apex Plugin from scratch boiler plate pl/sql
procedure render
( p_item in apex_plugin.t_item
, p_plugin in apex_plugin.t_plugin
, p_param in apex_plugin.t_item_render_param
, p_result in out nocopy apex_plugin.t_item_render_result
)
as
-- attributes
l_attribute1 p_item.attribute_01%type := p_item.attribute_01;
l_attribute2 p_item.attribute_02%type := p_item.attribute_02;
l_attribute3 p_item.attribute_03%type := p_item.attribute_03;
-- constants
c_escaped_value constant varchar2(32767) := apex_escape.html(p_param.value);
c_escaped_name constant varchar2(32767) := apex_escape.html(p_item.name);
begin
--debug
if apex_application.g_debug
then
apex_plugin_util.debug_item_render
( p_plugin => p_plugin
, p_item => p_item
, p_param => p_param
);
end if;
htp.p('<input
class=""
style="width:100%;"
id="' || c_escaped_name || '"
name="' || c_escaped_name || '"
value="' || c_escaped_value || '"
type="text"
>');
end render;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment