set define off set verify off set serveroutput on size 1000000 set feedback off WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK begin wwv_flow.g_import_in_progress := true; end; / -- AAAA PPPPP EEEEEE XX XX -- AA AA PP PP EE XX XX -- AA AA PP PP EE XX XX -- AAAAAAAAAA PPPPP EEEE XXXX -- AA AA PP EE XX XX -- AA AA PP EE XX XX -- AA AA PP EEEEEE XX XX prompt Set Credentials... begin -- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_040000 or as the owner (parsing schema) of the application. wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_id,2647143312916903283)); end; / begin wwv_flow.g_import_in_progress := true; end; / begin select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS'; end; / begin execute immediate 'alter session set nls_numeric_characters=''.,'''; end; / begin wwv_flow.g_browser_language := 'en'; end; / prompt Check Compatibility... begin -- This date identifies the minimum version required to import this file. wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2010.05.13'); end; / prompt Set Application ID... begin -- SET APPLICATION ID wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id,654321); wwv_flow_api.g_id_offset := nvl(wwv_flow_application_install.get_offset,0); null; end; / prompt ...plugins -- --application/shared_components/plugins/item_type/com_oracle_star_rating begin wwv_flow_api.create_plugin ( p_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_type => 'ITEM TYPE' ,p_name => 'COM.ORACLE.STAR_RATING' ,p_display_name => 'Star Rating' ,p_image_prefix => '#PLUGIN_PREFIX#' ,p_plsql_code => 'c_default_stars constant number := 5;'||chr(10)|| ''||chr(10)|| 'function render_rating ('||chr(10)|| ' p_item in apex_plugin.t_page_item,'||chr(10)|| ' p_plugin in apex_plugin.t_plugin,'||chr(10)|| ' p_value in varchar2,'||chr(10)|| ' p_is_readonly in boolean,'||chr(10)|| ' p_is_printer_friendly in boolean )'||chr(10)|| ' return apex_plugin.t_page_item_render_result'||chr(10)|| 'is'||chr(10)|| ' l_name varchar2(30);'||chr(10)|| ' l_result apex_plugin.t_p'|| 'age_item_render_result;'||chr(10)|| 'begin'||chr(10)|| ' -- During plug-in development it''s very helpful to have some debug information'||chr(10)|| ' if wwv_flow.g_debug then'||chr(10)|| ' apex_plugin_util.debug_page_item ('||chr(10)|| ' p_plugin => p_plugin,'||chr(10)|| ' p_page_item => p_item,'||chr(10)|| ' p_value => p_value,'||chr(10)|| ' p_is_readonly => p_is_readonly,'||chr(10)|| ' p_is_printer_'|| 'friendly => p_is_printer_friendly );'||chr(10)|| ' end if;'||chr(10)|| ''||chr(10)|| ' apex_javascript.add_library ('||chr(10)|| ' p_name => ''jquery.rating.pack'','||chr(10)|| ' p_directory => p_plugin.file_prefix,'||chr(10)|| ' p_version => null );'||chr(10)|| ''||chr(10)|| ' apex_css.add_file ('||chr(10)|| ' p_name => ''jquery.rating'','||chr(10)|| ' p_directory =>p_plugin.file_prefix,'||chr(10)|| ' p_version => null );'||chr(10)|| ''||chr(10)|| ' -- only get the page item name if we really save s'|| 'tate'||chr(10)|| ' if not p_is_readonly'||chr(10)|| ' and not p_is_printer_friendly'||chr(10)|| ' then'||chr(10)|| ' l_name := apex_plugin.get_input_name_for_page_item ('||chr(10)|| ' p_is_multi_value => false );'||chr(10)|| ' end if;'||chr(10)|| ''||chr(10)|| ' for ii in 1 .. to_number(nvl(p_item.attribute_01, c_default_stars))'||chr(10)|| ' loop'||chr(10)|| ' sys.htp.p('||chr(10)|| ' '''');'||chr(10)|| ' end loop;'||chr(10)|| ''||chr(10)|| ' -- Tell APEX that this field is navigable'||chr(10)|| ' l_result.is_navigable := (p_is_readonly = false and p_is_printer_friendly = f'|| 'alse);'||chr(10)|| ''||chr(10)|| ' return l_result;'||chr(10)|| 'end render_rating;'||chr(10)|| ''||chr(10)|| 'function validate_rating ('||chr(10)|| ' p_item in apex_plugin.t_page_item,'||chr(10)|| ' p_plugin in apex_plugin.t_plugin,'||chr(10)|| ' p_value in varchar2 )'||chr(10)|| ' return apex_plugin.t_page_item_validation_result'||chr(10)|| 'is'||chr(10)|| ' l_result apex_plugin.t_page_item_validation_result;'||chr(10)|| 'begin'||chr(10)|| ' if p_value is null then return null; end if;'||chr(10)|| ' '||chr(10)|| ' if wwv_flow_utilities.is_numeric(p_valu'|| 'e)'||chr(10)|| ' and not to_number(p_value) between 1 and to_number(nvl(p_item.attribute_01, c_default_stars))'||chr(10)|| ' then'||chr(10)|| ' l_result.message := sys.htf.escape_sc(p_value)||'' is not in the valid rating range of 1 - ''||nvl(p_item.attribute_01, c_default_stars);'||chr(10)|| ' end if;'||chr(10)|| ' '||chr(10)|| ' return l_result; '||chr(10)|| 'end validate_rating;' ,p_render_function => 'render_rating' ,p_validation_function => 'validate_rating' ,p_standard_attributes => 'VISIBLE:SESSION_STATE:READONLY:SOURCE:ELEMENT:ENCRYPT' ,p_version_identifier => '1.0' ,p_about_url => 'http://www.oracleapex.info' ); wwv_flow_api.create_plugin_attribute ( p_id => 920227370686074548 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_attribute_scope => 'COMPONENT' ,p_attribute_sequence => 1 ,p_display_sequence => 10 ,p_prompt => '# of stars' ,p_attribute_type => 'TEXT' ,p_is_required => true ,p_default_value => '5' ,p_display_length => 1 ,p_max_length => 1 ,p_is_translatable => false ); null; end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '2F2A0D0A20232323206A5175657279205374617220526174696E6720506C7567696E2076332E3132202D20323030392D30342D3136202323230D0A202A20486F6D653A20687474703A2F2F7777772E66796E65776F726B732E636F6D2F6A71756572792F'; wwv_flow_api.g_varchar2_table(2) := '737461722D726174696E672F0D0A202A20436F64653A20687474703A2F2F636F64652E676F6F676C652E636F6D2F702F6A71756572792D737461722D726174696E672D706C7567696E2F0D0A202A0D0A092A204475616C206C6963656E73656420756E64'; wwv_flow_api.g_varchar2_table(3) := '657220746865204D495420616E642047504C206C6963656E7365733A0D0A202A202020687474703A2F2F7777772E6F70656E736F757263652E6F72672F6C6963656E7365732F6D69742D6C6963656E73652E7068700D0A202A202020687474703A2F2F77'; wwv_flow_api.g_varchar2_table(4) := '77772E676E752E6F72672F6C6963656E7365732F67706C2E68746D6C0D0A202323230D0A2A2F0D0A6576616C2866756E6374696F6E28702C612C632C6B2C652C72297B653D66756E6374696F6E2863297B72657475726E28633C613F27273A6528706172'; wwv_flow_api.g_varchar2_table(5) := '7365496E7428632F612929292B2828633D632561293E33353F537472696E672E66726F6D43686172436F646528632B3239293A632E746F537472696E6728333629297D3B6966282127272E7265706C616365282F5E2F2C537472696E6729297B7768696C'; wwv_flow_api.g_varchar2_table(6) := '6528632D2D29725B652863295D3D6B5B635D7C7C652863293B6B3D5B66756E6374696F6E2865297B72657475726E20725B655D7D5D3B653D66756E6374696F6E28297B72657475726E275C5C772B277D3B633D317D3B7768696C6528632D2D296966286B'; wwv_flow_api.g_varchar2_table(7) := '5B635D29703D702E7265706C616365286E65772052656745787028275C5C62272B652863292B275C5C62272C276727292C6B5B635D293B72657475726E20707D28273B3528314F2E31742928372824297B3528242E32392E31782931497B316D2E323328'; wwv_flow_api.g_varchar2_table(8) := '223175222C502C7A297D31462865297B7D242E702E343D37286A297B3528332E4B3D3D30296C20333B352845204A5B305D3D3D5C27316A5C27297B3528332E4B3E31297B38206B3D4A3B6C20332E57283728297B242E702E342E4828242833292C6B297D'; wwv_flow_api.g_varchar2_table(9) := '297D3B242E702E345B4A5B305D5D2E4828332C242E3154284A292E32312831297C7C5B5D293B6C20337D3B38206A3D242E3130287B7D2C242E702E342E31382C6A7C7C7B7D293B332E3176285C272E392D342D316C5C27292E6E285C27392D342D316C5C'; wwv_flow_api.g_varchar2_table(10) := '27292E57283728297B3820613D28332E314A7C7C5C27314B2D345C27292E314C282F5C5C5B7C5C5C5D2B2F672C22315322293B3820623D2428332E31557C7C316D2E3158293B3820633D242833293B3820643D622E36285C27345C27297C7C7B793A307D'; wwv_flow_api.g_varchar2_table(11) := '3B3820653D645B615D3B3820663B35286529663D652E36285C27345C27293B352865262666297B662E792B2B7D427B663D242E3130287B7D2C6A7C7C7B7D2C28242E316B3F632E316B28293A28242E31483F632E3628293A7329297C7C7B7D2C7B793A30'; wwv_flow_api.g_varchar2_table(12) := '2C433A5B5D2C753A5B5D7D293B662E743D642E792B2B3B653D24285C273C314D2031323D22392D342D3151222F3E5C27293B632E31522865293B652E6E285C27342D542D31332D535C27293B3528632E52285C27515C272929662E6D3D7A3B652E316128'; wwv_flow_api.g_varchar2_table(13) := '662E413D24285C273C4F2031323D22342D41223E3C612031343D225C272B662E412B5C27223E5C272B662E31352B5C273C2F613E3C2F4F3E5C27292E3164283728297B242833292E34285C274E5C27293B242833292E6E285C27392D342D4D5C27297D29'; wwv_flow_api.g_varchar2_table(14) := '2E3162283728297B242833292E34285C27765C27293B242833292E44285C27392D342D4D5C27297D292E3168283728297B242833292E34285C27775C27297D292E36285C27345C272C6629297D3B3820673D24285C273C4F2031323D22392D3420712D5C'; wwv_flow_api.g_varchar2_table(15) := '272B662E742B5C27223E3C612031343D225C272B28332E31347C7C332E3170292B5C27223E5C272B332E31702B5C273C2F613E3C2F4F3E5C27293B652E31612867293B3528332E5529672E52285C27555C272C332E55293B3528332E313729672E6E2833'; wwv_flow_api.g_varchar2_table(16) := '2E3137293B3528662E315629662E783D323B35284520662E783D3D5C2731395C272626662E783E30297B3820683D28242E702E31313F672E313128293A30297C7C662E31633B3820693D28662E7925662E78292C563D31792E317A28682F662E78293B67'; wwv_flow_api.g_varchar2_table(17) := '2E31312856292E3141285C27615C27292E3142287B5C2731432D31445C273A5C272D5C272B28692A56292B5C2731455C277D297D3B3528662E6D29672E6E285C27392D342D31655C27293B4220672E6E285C27392D342D31475C27292E3164283728297B'; wwv_flow_api.g_varchar2_table(18) := '242833292E34285C2731665C27293B242833292E34285C27475C27297D292E3162283728297B242833292E34285C27765C27293B242833292E34285C27465C27297D292E3168283728297B242833292E34285C27775C27297D293B3528332E4C29662E6F'; wwv_flow_api.g_varchar2_table(19) := '3D673B632E316928293B632E314E283728297B242833292E34285C27775C27297D293B672E36285C27342E725C272C632E36285C27342E395C272C6729293B662E435B662E432E4B5D3D675B305D3B662E755B662E752E4B5D3D635B305D3B662E713D64'; wwv_flow_api.g_varchar2_table(20) := '5B615D3D653B662E31503D623B632E36285C27345C272C66293B652E36285C27345C272C66293B672E36285C27345C272C66293B622E36285C27345C272C64297D293B24285C272E342D542D31332D535C27292E34285C27765C27292E44285C27342D54'; wwv_flow_api.g_varchar2_table(21) := '2D31332D535C27293B6C20337D3B242E313028242E702E342C7B473A3728297B3820613D332E36285C27345C27293B35282161296C20333B352821612E47296C20333B3820623D242833292E36285C27342E725C27297C7C2428332E5A3D3D5C27585C27'; wwv_flow_api.g_varchar2_table(22) := '3F333A73293B3528612E4729612E472E4828625B305D2C5B622E4928292C24285C27615C272C622E36285C27342E395C2729295B305D5D297D2C463A3728297B3820613D332E36285C27345C27293B35282161296C20333B352821612E46296C20333B38'; wwv_flow_api.g_varchar2_table(23) := '20623D242833292E36285C27342E725C27297C7C2428332E5A3D3D5C27585C273F333A73293B3528612E4629612E462E4828625B305D2C5B622E4928292C24285C27615C272C622E36285C27342E395C2729295B305D5D297D2C31663A3728297B382061'; wwv_flow_api.g_varchar2_table(24) := '3D332E36285C27345C27293B35282161296C20333B3528612E6D296C3B332E34285C274E5C27293B332E316E28292E316F28292E59285C272E712D5C272B612E74292E6E285C27392D342D4D5C27297D2C4E3A3728297B3820613D332E36285C27345C27'; wwv_flow_api.g_varchar2_table(25) := '293B35282161296C20333B3528612E6D296C3B612E712E315728292E59285C272E712D5C272B612E74292E44285C27392D342D31715C27292E44285C27392D342D4D5C27297D2C763A3728297B3820613D332E36285C27345C27293B35282161296C2033'; wwv_flow_api.g_varchar2_table(26) := '3B332E34285C274E5C27293B3528612E6F297B612E6F2E36285C27342E725C27292E52285C274C5C272C5C274C5C27293B612E6F2E316E28292E316F28292E59285C272E712D5C272B612E74292E6E285C27392D342D31715C27297D42202428612E7529'; wwv_flow_api.g_varchar2_table(27) := '2E3172285C274C5C27293B612E415B612E6D7C7C612E31593F5C2731695C273A5C27315A5C275D28293B332E323028295B612E6D3F5C276E5C273A5C27445C275D285C27392D342D31655C27297D2C773A372861297B3820623D332E36285C27345C2729'; wwv_flow_api.g_varchar2_table(28) := '3B35282162296C20333B3528622E6D296C3B622E6F3D733B3528452061213D5C2731735C27297B35284520613D3D5C2731395C27296C202428622E435B615D292E34285C27775C27293B35284520613D3D5C27316A5C2729242E5728622E432C3728297B'; wwv_flow_api.g_varchar2_table(29) := '3528242833292E36285C27342E725C27292E4928293D3D6129242833292E34285C27775C27297D297D4220622E6F3D335B305D2E5A3D3D5C27585C273F332E36285C27342E395C27293A28332E3232285C272E712D5C272B622E74293F333A73293B332E'; wwv_flow_api.g_varchar2_table(30) := '36285C27345C272C62293B332E34285C27765C27293B3820633D2428622E6F3F622E6F2E36285C27342E725C27293A73293B3528622E316729622E31672E4828635B305D2C5B632E4928292C24285C27615C272C622E6F295B305D5D297D2C6D3A372861'; wwv_flow_api.g_varchar2_table(31) := '2C62297B3820633D332E36285C27345C27293B35282163296C20333B632E6D3D617C7C613D3D31733F7A3A503B352862292428632E75292E52282251222C225122293B42202428632E75292E317228225122293B332E36285C27345C272C63293B332E34'; wwv_flow_api.g_varchar2_table(32) := '285C27765C27297D2C32343A3728297B332E34285C276D5C272C7A2C7A297D2C32353A3728297B332E34285C276D5C272C502C50297D7D293B242E702E342E31383D7B413A5C2732362032375C272C31353A5C275C272C783A302C31633A31367D3B2428'; wwv_flow_api.g_varchar2_table(33) := '3728297B24285C27725B32383D31775D2E395C27292E3428297D297D29283174293B272C36322C3133342C277C7C7C746869737C726174696E677C69667C646174617C66756E6374696F6E7C7661727C737461727C7C7C7C7C7C7C7C7C7C7C7C72657475'; wwv_flow_api.g_varchar2_table(34) := '726E7C726561644F6E6C797C616464436C6173737C63757272656E747C666E7C72617465727C696E7075747C6E756C6C7C73657269616C7C696E707574737C647261777C73656C6563747C73706C69747C636F756E747C747275657C63616E63656C7C65'; wwv_flow_api.g_varchar2_table(35) := '6C73657C73746172737C72656D6F7665436C6173737C747970656F667C626C75727C666F6375737C6170706C797C76616C7C617267756D656E74737C6C656E6774687C636865636B65647C686F7665727C647261696E7C6469767C66616C73657C646973'; wwv_flow_api.g_varchar2_table(36) := '61626C65647C617474727C647261776E7C746F7C69647C7370777C656163687C494E5055547C66696C7465727C7461674E616D657C657874656E647C77696474687C636C6173737C62657C7469746C657C63616E63656C56616C75657C7C636C6173734E'; wwv_flow_api.g_varchar2_table(37) := '616D657C6F7074696F6E737C6E756D6265727C617070656E647C6D6F7573656F75747C7374617257696474687C6D6F7573656F7665727C726561646F6E6C797C66696C6C7C63616C6C6261636B7C636C69636B7C686964657C737472696E677C6D657461'; wwv_flow_api.g_varchar2_table(38) := '646174617C6170706C6965647C646F63756D656E747C70726576416C6C7C616E6453656C667C76616C75657C6F6E7C72656D6F7665417474727C756E646566696E65647C6A51756572797C4261636B67726F756E64496D61676543616368657C6E6F747C'; wwv_flow_api.g_varchar2_table(39) := '726164696F7C6D7369657C4D6174687C666C6F6F727C66696E647C6373737C6D617267696E7C6C6566747C70787C63617463687C6C6976657C6D6574617C7472797C6E616D657C756E6E616D65647C7265706C6163657C7370616E7C6368616E67657C77'; wwv_flow_api.g_varchar2_table(40) := '696E646F777C636F6E746578747C636F6E74726F6C7C6265666F72657C5F7C6D616B6541727261797C666F726D7C68616C667C6368696C6472656E7C626F64797C72657175697265647C73686F777C7369626C696E67737C736C6963657C69737C657865'; wwv_flow_api.g_varchar2_table(41) := '63436F6D6D616E647C64697361626C657C656E61626C657C43616E63656C7C526174696E677C747970657C62726F77736572272E73706C697428277C27292C302C7B7D2929'; null; end; / begin wwv_flow_api.create_plugin_file ( p_id => 928376473510546780 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_file_name => 'jquery.rating.pack.js' ,p_mime_type => 'text/x-c' ,p_file_charset => 'utf-8' ,p_file_content => wwv_flow_api.g_varchar2_table ); null; end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '47494638396110002000E60000B95133BDBDBD999999DFDFDF949494DBA595F27662D6D6D6E6554BDD7772F5F5F5CE6153E7C4B9B5B5B5F3A6A2EE837CD47064EFEFEFC5C5C5ADADADF6CFCFFA9986E9625AD66D63BD5B3FF08B76EE8B80F49F9DCCCCCC'; wwv_flow_api.g_varchar2_table(2) := 'F5E6E1C3644BEAB0ACEEC8C3E6554FD75C50F0846FA5A5A5C34F33E27E7CF19C95F0907EFFFFFFE7E7E7F8C2BDE36D62FBEBEBFDDCD8DB554AF9B8AEFAAA9CEC5E53E47770C66A53EE6551ED928DEBB2AEEA827CBE5339FAA290DE6A69EFCAC6E0645BE0'; wwv_flow_api.g_varchar2_table(3) := 'AA9FF8B5A7D04E3DF3725CF9D3CCE37778FBA89BBD634AE65951E97A6FCD6757EE695DF7E7E5C04C32FCC7B9F37862E6574BF6836BF7927DF5AEA4F18D79F5A29EF88B75DE7873E87974E75C58FA9C8ADB6864F0B4B5F48D80F2ACA9D65F53F9CBC3CC51'; wwv_flow_api.g_varchar2_table(4) := '3BFCD4CDE37E7CFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021F904'; wwv_flow_api.g_varchar2_table(5) := '01070062002C00000000100020000007FF806282838485850A03010D0D01070A86622A011C032A2A070D1303852A0D0711031C1C0789249B820A8D111C12ADAD98248F6207122AAC01B8B907021C828DB48BC18C120124820DA10129CBCC130D1C02C7B4'; wwv_flow_api.g_varchar2_table(6) := 'CACCCBCE1C04BEAD9913DDDEC4D1B32498DCDE13070412A8CE98E6E7130211830324E7128B120724040785F4029338042020A09FA15524041094200F92C387100BB5D06262C78E2A375A40A230C4C60A215E7EB0B8C0A310851D5C5CC0D081850893230B'; wwv_flow_api.g_varchar2_table(7) := '400C6A31C4818B0A28A44081424524122582B4E00083054A8627489F348902C487A0305162649041B5AA812D566808DA0103CA886ACB9C2439914350961848C1A6706281ACA0041A4DA0047142B7AE9307553C08FAF0C2418D1A769D189952A280A01610'; wwv_flow_api.g_varchar2_table(8) := '5844A16A774A170C1D06F158D0C3C1030B571E6C10018041211048BE58B16163C6120C9E0D29F14103430E0F052247741808003B'; null; end; / begin wwv_flow_api.create_plugin_file ( p_id => 928377885143556532 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_file_name => 'delete.gif' ,p_mime_type => 'image/gif' ,p_file_charset => 'utf-8' ,p_file_content => wwv_flow_api.g_varchar2_table ); null; end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '47494638396110003000E60000A13737C5C5C5E9B31BCC800DE7C25AD48484D07373DEDEDEE4AFAFC06060E3B843F7ECBCC55252D6D6D6E2B634E4BD66F6F6F6EACB46DAA9A9EEEEEEDDA829F1DC9ADEBABAECCF79AD4646F7E9E9ECBC22EDC230E9C641'; wwv_flow_api.g_varchar2_table(2) := 'EBCD99CD6C6CF6E162F4DFDFF4D95AF1CE53E7E7E7C75A5AD99D25CF7B7BD79292F7EBB5BF4242C24A4ADFAF31E7C472ECC7C7E9C74CEFC529EFD54CFCF8EFE6BD42F2D558CC6666CCCCCCFBF5D8FBF5E6E6BF39E8B025F1DBA2DDAA45F1DC7FBD4A4AD3'; wwv_flow_api.g_varchar2_table(3) := '8F22AA3F3FE4BB4AEEC34BE5AD38EDD2ABFFFFFFD88C8CD37C7CF4D640EAC981F1CD2FF2D045F5DE5DE9B320F9EEEEF2D655EDD05AEEC341D18B19E9C76EEDCBCBEFC84FE5B638EDCE49EFBD29EFCE29EAB52BDEB531C96060EBBD44EFB542F2DC57F0CB'; wwv_flow_api.g_varchar2_table(4) := '39F7DE9CE8BABAEBCE87DB9494ECBF48B44C4CD6992BF2DFB0B84444F7D64AFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021F904'; wwv_flow_api.g_varchar2_table(5) := '0107006A002C00000000100030000007FF806A82836A10138488880D0D898D138B238D8A8B8C9282230D07079989139A8B9B94A023109B9A9FA2A96AA0A235AE358B354482ACB1AEB11084ADAF0D35B98498BDBC9C88A1AD8B89C6A9358994359AAFCC88'; wwv_flow_api.g_varchar2_table(6) := 'AE91832335019D928796205396880634E0832D343408E46A34060624E4083446465B45892D63065B34261E5BEE0C68144090A19F8179463C306040C2833F120C54A87158800609881155A8A011B189A07346306A4CC15185C741FF4AAA48413245064412'; wwv_flow_api.g_varchar2_table(7) := 'FE695C79D144A222E718EC8B48224122031EDA5D3C47A24CA2860C52143881060D831F89348E212401038044612459006763813A414F227C5D60C54A0575119C38C1410E8C9510218C385C488482C7130E6F957C1181C30110293A6E3C81E1658961252F'; wwv_flow_api.g_varchar2_table(8) := '5E6CA012844B95152BD48880F1E148922489356860C245C88A18825C585972F9856601648450003D48C60CC4A60508E042E106A20A1C6698D620A04A9507892E4488B0010A942C39AAEC4844808A082A32AA70716C2691022A5528B04052A28490288920'; wwv_flow_api.g_varchar2_table(9) := '8B21D4C1C7804467240D191408003B'; null; end; / begin wwv_flow_api.create_plugin_file ( p_id => 928378682555557766 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_file_name => 'star.gif' ,p_mime_type => 'image/gif' ,p_file_charset => 'utf-8' ,p_file_content => wwv_flow_api.g_varchar2_table ); null; end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '2F2A206A51756572792E526174696E6720506C7567696E20435353202D20687474703A2F2F7777772E66796E65776F726B732E636F6D2F6A71756572792F737461722D726174696E672F202A2F0D0A6469762E726174696E672D63616E63656C2C646976'; wwv_flow_api.g_varchar2_table(2) := '2E737461722D726174696E677B666C6F61743A6C6566743B77696474683A313770783B6865696768743A313570783B746578742D696E64656E743A2D393939656D3B637572736F723A706F696E7465723B646973706C61793A626C6F636B3B6261636B67'; wwv_flow_api.g_varchar2_table(3) := '726F756E643A7472616E73706172656E743B6F766572666C6F773A68696464656E7D0D0A6469762E726174696E672D63616E63656C2C6469762E726174696E672D63616E63656C20617B6261636B67726F756E643A75726C2823504C5547494E5F505245'; wwv_flow_api.g_varchar2_table(4) := '4649582364656C6574652E67696629206E6F2D7265706561742030202D313670787D0D0A6469762E737461722D726174696E672C6469762E737461722D726174696E6720617B6261636B67726F756E643A75726C2823504C5547494E5F50524546495823'; wwv_flow_api.g_varchar2_table(5) := '737461722E67696629206E6F2D7265706561742030203070787D0D0A6469762E726174696E672D63616E63656C20612C6469762E737461722D726174696E6720617B646973706C61793A626C6F636B3B77696474683A313670783B6865696768743A3130'; wwv_flow_api.g_varchar2_table(6) := '30253B6261636B67726F756E642D706F736974696F6E3A30203070783B626F726465723A307D0D0A6469762E737461722D726174696E672D6F6E20617B6261636B67726F756E642D706F736974696F6E3A30202D3136707821696D706F7274616E747D0D'; wwv_flow_api.g_varchar2_table(7) := '0A6469762E737461722D726174696E672D686F76657220617B6261636B67726F756E642D706F736974696F6E3A30202D333270787D0D0A2F2A2052656164204F6E6C7920435353202A2F0D0A6469762E737461722D726174696E672D726561646F6E6C79'; wwv_flow_api.g_varchar2_table(8) := '20617B637572736F723A64656661756C742021696D706F7274616E747D0D0A2F2A205061727469616C205374617220435353202A2F0D0A6469762E737461722D726174696E677B6261636B67726F756E643A7472616E73706172656E7421696D706F7274'; wwv_flow_api.g_varchar2_table(9) := '616E743B6F766572666C6F773A68696464656E21696D706F7274616E747D0D0A2F2A20454E44206A51756572792E526174696E6720506C7567696E20435353202A2F'; null; end; / begin wwv_flow_api.create_plugin_file ( p_id => 928382475198591570 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_plugin_id => 920227080251067760 + wwv_flow_api.g_id_offset ,p_file_name => 'jquery.rating.css' ,p_mime_type => 'text/css' ,p_file_charset => 'utf-8' ,p_file_content => wwv_flow_api.g_varchar2_table ); null; end; / commit; begin execute immediate 'begin dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;'; end; / set verify on set feedback on prompt ...done