Forum Stats

  • 3,752,058 Users
  • 2,250,452 Discussions
  • 7,867,705 Comments

Discussions

Problem importing the plugin app

Tobias Arnhold
Tobias Arnhold Member Posts: 634 Silver Badge
edited Nov 16, 2011 10:58AM in APEX Discussions
I always getting the same error during the installation of my application: Keine weiteren Daten aus Socket zu lesen / no more data to read from socket

It looks like it has to do with the PDF plug-in from Anton Sheffler because it always appears at the same position.

It also doesn't matter if I try to install it via Webbrowser or SQL Developer.

But when I try to install it on another Workspace on apex.oracle.com it works.

But on my local instance it fails. It is the same APEX version installed: Application Express 4.1.0.00.32

My local instance is only a XE database: 11.2.0.2.0
APPLICATION 400 - Logbuch
Set Credentials...
Check Compatibility...
Set Application ID...
...authorization schemes
...navigation bar entries
...application processes
...application items
...application level computations
...Application Tabs
...Application Parent Tabs
...Shared Lists of values
...Application Trees
...page groups
...comments: requires application express 2.2 or higher
...PAGE 0: 0
...PAGE 1: LOG - OVERVIEW
...PAGE 2: LOG - CHARTS
...PAGE 3: LOG - ENTRY EDIT
...PAGE 4: LOG - CONTACT PERSONS
...PAGE 5: LOG - FILE OVERVIEW
...PAGE 6: LOG - FILE EDIT
...PAGE 7: LOG - GOOGLE CHART
...PAGE 8: LOG - CATEGORIES
...PAGE 9: LOG - FUNNEL CHART
...PAGE 10: LOG - ENTRY CHART
...PAGE 11: LOG - PDF Export
...PAGE 20: LOG - CATEGORIES SD
...PAGE 21: LOG - GOOGLE ORG CHART
...PAGE 22: LOG - CONTACT_PERSONS
...PAGE 30: LOG - ABOUT
...PAGE 50: MobileReport
...PAGE 101: LOG - LOGIN PAGE
...lists
...breadcrumbs
...page templates for application: 65600
......Page template 32083097154288305019
......Page template 32083098261282305021
......Page template 32083098555117305022
......Page template 32083098838398305022
......Page template 32083099435185305023
......Page template 32083100449910305024
......Page template 32083101849964305026
......Page template 32083103637474305028
......Page template 32083103950923305029
......Page template 32083104252133305032
......Page template 32083104562677305032
......Page template 32083104847161305033
......Page template 32083105162238305034
......Page template 32083105444763305036
......Page template 32083105759111305036
......Page template 33837641362132922718
......Page template 37308597950957478679
...button templates
......Button Template 32083106047815305036
......Button Template 32083106232810305039
......Button Template 32083106445518305040
......Button Template 32083106653096305043
...region templates
......region template 32083106856673305044
......region template 32083107144561305045
......region template 32083107457828305045
......region template 32083107733492305046
......region template 32083108040175305046
......region template 32083108359753305046
......region template 32083108638471305046
......region template 32083108953606305046
......region template 32083109243176305046
......region template 32083109537446305047
......region template 32083109834502305047
......region template 32083110151878305047
......region template 32083110434314305049
......region template 32083110746950305049
......region template 32083111062447305049
......region template 32083111337684305052
......region template 32083111631768305052
......region template 32083111937278305052
......region template 32083112240043305052
......region template 32083112547315305052
......region template 32083112841432305052
......region template 32083113152102305053
......region template 32083113464410305053
......region template 33848184561983111964
......region template 37060830663698409636
......region template 37307024442861466908
...List Templates
......list template 32083113745241305053
......list template 32083114044044305055
......list template 32083114257697305055
......list template 32083114536207305055
......list template 32083114860437305055
......list template 32083115154832305055
......list template 32083115442319305056
......list template 32083115737773305057
......list template 32083116044770305057
......list template 32083116333460305063
......list template 32083116646006305064
......list template 32083116938819305064
......list template 32083117238123305064
......list template 32083117561050305064
......list template 32083117858349305064
...report templates
......report template 32083118142757305064
......report template 32083118661727305069
......report template 32083119137779305071
......report template 32083119633067305072
......report template 32083120133675305072
......report template 32083120662231305073
......report template 32083121138710305073
......report template 32083121455216305073
...label templates
......label template 32083121750607305074
......label template 32083121848870305077
......label template 32083121957090305077
......label template 32083122057906305077
......label template 32083122144002305077
...breadcrumb templates
......template 32083122258144305077
......template 32083122343381305079
...popup list of values templates
......template 32083123064463305082
...calendar templates
......template 32083122441866305079
......template 32083122655597305080
......template 32083122863647305081
...application themes
......theme 32083123250781305084
...build options used by application 65600
...Language Maps for Application 65600
... translations used by application: 65600
...messages used by application: 65600
...dynamic translations used by application: 65600
...Shortcuts
...web services (9iR2 or better)
...shared queries
...report layouts
...authentication schemes
......authentication 31813313140617421226
......authentication 31845554673807759745
......authentication 31845554764970759745
...plugins
Fehler bei Rollback

Fehler beim Start in Zeile 23.745 in Befehl:
begin
 
wwv_flow_api.create_plugin (
  p_id => 41073893256060555494 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_type => 'REGION TYPE'
 ,p_name => 'NL.AMIS.SCHEFFER.REGION.PDF'
 ,p_display_name => 'Embedded PDF'
 ,p_image_prefix => '#PLUGIN_PREFIX#'
 ,p_plsql_code => 
'function render_pdf'||unistr('\000a')||
'( p_region              in apex_plugin.t_region'||unistr('\000a')||
', p_plugin              in apex_plugin.t_plugin'||unistr('\000a')||
', p_is_printer_friendly in boolean'||unistr('\000a')||
')'||unistr('\000a')||
'return apex_plugin.t_region_render_result'||unistr('\000a')||
'is'||unistr('\000a')||
'c_my_name varchar2(1000) := ''NL.AMIS.SCHEFFER.REGION.PDF'';'||unistr('\000a')||
'l_width number;'||unistr('\000a')||
'l_height number;'||unistr('\000a')||
'l_landscape varchar2(1);'||unistr('\000a')||
'l_format varchar2(10);'||unistr('\000a')||
'l_font varchar2(30);'||unistr('\000a')||
'l_fontsize number;'||unistr('\000a')||
'l_header varchar2(3276'||
'7);'||unistr('\000a')||
't_rc sys_refcursor;'||unistr('\000a')||
't_file_id number;'||unistr('\000a')||
'type tp_settings is record'||unistr('\000a')||
'( page_width number'||unistr('\000a')||
', page_height number'||unistr('\000a')||
', margin_left number'||unistr('\000a')||
', margin_right number'||unistr('\000a')||
', margin_top number'||unistr('\000a')||
', margin_bottom number'||unistr('\000a')||
', encoding varchar2(100)'||unistr('\000a')||
', current_font pls_integer'||unistr('\000a')||
', current_fontsizePt pls_integer'||unistr('\000a')||
', x   number'||unistr('\000a')||
', y   number'||unistr('\000a')||
', page_nr pls_integer'||unistr('\000a')||
');'||unistr('\000a')||
'type tp_objects_tab is table of number(10) index by pls_integer;'||unistr('\000a')||
'typ'||
'e tp_pages_tab is table of blob index by pls_integer;'||unistr('\000a')||
'type tp_char_width_tab is table of pls_integer index by pls_integer;'||unistr('\000a')||
'type tp_font is record'||unistr('\000a')||
'( char_width_tab tp_char_width_tab'||unistr('\000a')||
', standard boolean'||unistr('\000a')||
', family varchar2(100)'||unistr('\000a')||
', style varchar2(2) -- N Normal'||unistr('\000a')||
'-- I Italic'||unistr('\000a')||
'-- B Bold'||unistr('\000a')||
'-- BI Bold Italic'||unistr('\000a')||
', subtype varchar2(15) := ''Type1'''||unistr('\000a')||
', name varchar2(100)'||unistr('\000a')||
', encoding varchar2(100) := ''WINDOWS-1252'''||unistr('\000a')||
');'||unistr('\000a')||
'type'||
... --- ...
wwv_flow_api.create_plugin_attr_value (
  p_id => 41072593744003455937 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_attribute_id => 41072593138116454266 + wwv_flow_api.g_id_offset
 ,p_display_sequence => 10
 ,p_display_value => 'Helvetica'
 ,p_return_value => 'HELVETICA'
  );
wwv_flow_api.create_plugin_attr_value (
  p_id => 41072594147812457118 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_attribute_id => 41072593138116454266 + wwv_flow_api.g_id_offset
 ,p_display_sequence => 20
 ,p_display_value => 'Times-Roman'
 ,p_return_value => 'TIMES'
  );
wwv_flow_api.create_plugin_attr_value (
  p_id => 41072594553007458523 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_attribute_id => 41072593138116454266 + wwv_flow_api.g_id_offset
 ,p_display_sequence => 30
 ,p_display_value => 'Courier'
 ,p_return_value => 'COURIER'
  );
wwv_flow_api.create_plugin_attribute (
  p_id => 41072595143095465121 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_id => 41073893256060555494 + wwv_flow_api.g_id_offset
 ,p_attribute_scope => 'COMPONENT'
 ,p_attribute_sequence => 6
 ,p_display_sequence => 60
 ,p_prompt => 'Fontsize'
 ,p_attribute_type => 'NUMBER'
 ,p_is_required => false
 ,p_default_value => '12'
 ,p_is_translatable => true
  );
wwv_flow_api.create_plugin_attribute (
  p_id => 41071266040010638110 + wwv_flow_api.g_id_offset
 ,p_flow_id => wwv_flow.g_flow_id
 ,p_plugin_id => 41073893256060555494 + wwv_flow_api.g_id_offset
 ,p_attribute_scope => 'COMPONENT'
 ,p_attribute_sequence => 7
 ,p_display_sequence => 70
 ,p_prompt => 'Header'
 ,p_attribute_type => 'TEXT'
 ,p_is_required => false
 ,p_is_translatable => true
 ,p_help_text => 'An optional header text. You can precede this text with an alignment hint'||unistr('\000a')||
'C: centered'||unistr('\000a')||
'L: left aligned'||unistr('\000a')||
'R: right aligned'||unistr('\000a')||
''||unistr('\000a')||
'C:This is an example of a Centered Header Text'
  );
null;
 
end;
Fehlerbericht:
Keine weiteren Daten aus Socket zu lesen
Hope for help. I do not want to drop the plug-in!

Tobias

Edited by: Tobias Arnhold on Nov 15, 2011 10:57 PM
I just dropped the PDF Plugin and it worked well! Strange I don't understand... Maybe it could have to do with some session time out problems?

Answers

  • ascheffer
    ascheffer Member Posts: 1,906 Gold Trophy
    When I try to import that plugin in Application Express 4.0.2.00.08 running on Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta the script fails with ORA-03113: end-of-file on communication channel.
    It looks that the plugin can't be used on 11g XE database.

    Anton
    ascheffer
  • Tobias Arnhold
    Tobias Arnhold Member Posts: 634 Silver Badge
    Hi Anton,

    thanks for the info. I'm still wondering how this could happened? Must be some limitation inside the XE database.

    Tobias
  • ascheffer
    ascheffer Member Posts: 1,906 Gold Trophy
    After a little experimenting: the 11G XE database doesn't like the many concationations operators in the script.

    This works:
    declare
      p_plsql_code varchar2(32767);
    begin 
      p_plsql_code := ''
      || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || ''
      || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || '' || ''
    ;
    end;
    But if you have more than 1773 || in one statement it fails with ORA-03113: end-of-file on communication channel
    ascheffer
  • Tobias Arnhold
    Tobias Arnhold Member Posts: 634 Silver Badge
    Strange very strange. Guess it will not be fixed because it is only XE. :( Maybe you could extend your plug-in somewhere in the future? If it only appears in one statement then you could use several statements instead. Or am I wrong?
  • ascheffer
    ascheffer Member Posts: 1,906 Gold Trophy
    I can't write a plugin in one statement :). It's the export script from Apex. Something like
    wwv_flow_api.create_plugin (
      p_id => 5238337935213717 + wwv_flow_api.g_id_offset
     ,p_flow_id => wwv_flow.g_flow_id
     ,p_plugin_type => 'REGION TYPE'
     ,p_name => 'NL.AMIS.SCHEFFER.REGION.PDF'
     ,p_display_name => 'Embedded PDF'
     ,p_image_prefix => '#PLUGIN_PREFIX#'
     ,p_plsql_code => 
    'function render_pdf'||chr(10)||
    '( p_region              in apex_plugin.t_region'||chr(10)||
    ', p_plugin              in apex_plugin.t_plugin'||chr(10)||
    ', p_is_printer_friendly in boolean'||chr(10)||
    ')'||chr(10)||
    'return apex_plugin.t_region_render_result'||chr(10)||
    'is'||chr(10)||
    'c_my_name varchar2(1000) := ''NL.AMIS.SCHEFFER.REGION.PDF'';'||chr(10)||
    'l_width number;'||chr(10)||
    'l_height number;'||chr(10)||
    'l_landscape varchar2(1);'||chr(10)||
    'l_format varchar2(10);'||chr(10)||
    'l_font varchar2(30);'||chr(10)||
    'l_fontsize number;'||chr(10)||
    'l_header varchar2(3276'||
    '7);'||chr(10)||
    't_rc sys_refcursor;'||chr(10)||
    't_file_id number;'||chr(10)||
    'type tp_settings is record'||chr(10)||
    '( page_width number'||chr(10)||
    ', page_height number'||chr(10)||
    ', margin_left number'||chr(10)||
    ', margin_right number'||chr(10)||
    ', margin_top number'||chr(10)||
    ', margin_bottom number'||chr(10)||
    ', encoding varchar2(100)'||chr(10)||
    ', current_font pls_integer'||chr(10)||
    ', current_fontsizePt pls_integer'||chr(10)||
    ', x   number'||chr(10)||
    ', y   number'||chr(10)||
    ', page_nr pls_integer'||chr(10)||
    ');'||chr(10)||
    'type tp_objects_tab is table of number(10) index by pls_integer;'||chr(10)||
    'typ'||
    'e tp_pages_tab is table of blob index by pls_integer;'||chr(10)||
    'type tp_char_width_tab is table of pls_integer index by pls_integer;'||chr(10)||
    'type tp_font is record'||chr(10)||
    '( char_width_tab tp_char_width_tab'||chr(10)||
    ', standard boolean'||chr(10)||
    ', family varchar2(100)'||chr(10)||
    ', style varchar2(2) -- N Normal'||chr(10)||
    '-- I Italic'||chr(10)||
    '-- B Bold'||chr(10)||
    '-- BI Bold Italic'||chr(10)||
    ', subtype varchar2(15) := ''Type1'''||chr(10)||
    ', name varchar2(100)'||chr(10)||
    ', encoding varchar2(100) := ''WINDOWS-1252'''||chr(10)||
    ');'||chr(10)||
    'type'||
    ' tp_font_tab is table of tp_font index by pls_integer;'||chr(10)||
    'type tp_pls_tab is table of pls_integer index by pls_integer;'||chr(10)||
    '-- pacakges globals'||chr(10)||
    'pdf_doc blob; -- the blob containing the build PDF document'||chr(10)||
    'objects_tab tp_objects_tab;'||chr(10)||
    'pages_tab tp_pages_tab;'||chr(10)||
    'settings tp_settings;'||chr(10)||
    'fonts tp_font_tab;'||chr(10)||
    'used_fonts tp_pls_tab;'||chr(10)||
    't_ncharset varchar2(1000);'||chr(10)||
    't_lan_ter  varchar2(1000);'||chr(10)||
    'procedure init_core_fonts'||chr(10)||
    'is'||chr(10)||
    'func'||
    'tion init_standard_withs( p_compressed_tab in varchar2 )'||chr(10)||
    'return tp_char_width_tab'||chr(10)||
    'is'||chr(10)||
    't_rv tp_char_width_tab;'||chr(10)||
    't_tmp raw(32767);'||chr(10)||
    'begin'||chr(10)||
    't_tmp := utl_compress.lz_uncompress( utl_encode.base64_decode( utl_raw.cast_to_raw( p_compressed_tab ) ) );'||chr(10)||
    'for i in 0 .. 255'||chr(10)||
    'loop'||chr(10)||
    't_rv( i ) := utl_raw.cast_to_binary_integer( utl_raw.substr( t_tmp, i * 4 + 1, 4 ) );'||chr(10)||
    'end loop;'||chr(10)||
    'return t_rv;'||chr(10)||
    'end;'||chr(10)||
    'begin'||chr(10)||
    'fonts( 1 ).famil'||
    'y := ''helvetica'';'||chr(10)||
    'fonts( 1 ).style := ''N''; -- Normal'||chr(10)||
    'fonts( 1 ).name := ''Helvetica'';'||chr(10)||
    'fonts( 1 ).standard := true;'||chr(10)||
    'fonts( 1 ).char_width_tab := init_standard_withs'||chr(10)||
  • Tobias Arnhold
    Tobias Arnhold Member Posts: 634 Silver Badge
    edited Nov 16, 2011 10:58AM
    Damn my head must have been a black out! :)

    That means: It could happen to any plug-in with a bit more code inside?
This discussion has been closed.