2 Replies Latest reply: Jul 27, 2013 12:52 PM by user628135 RSS

    Fileupload with with ApexListener

      We want to migrate from OHS to Apex_Listener.
      As far we got the HTP content in the PLSQL Procedures which is stored in the datebase will be executed and as HTML/JavaScript deliverd.
      We don’t want to use APEX, only the Apex Listener. We are deploying ApexListener 2.0.1.

      Our Solution with OHS looks like the examples in the Documentation:

      The Problem is, when we want to upload a file in the database. The error

      java.sql.SQLException: ORA-06550: line 2, column 2:
      PLS-00306: wrong number or types of arguments in call to 'WRITEINFO'
      ORA-06550: line 2, column 2:
      PL/SQL: Statement ignored

      This can we solve with a workaround and set some default parameters/arguments but then we got:

      May 29, 2013 11:49:32 AM oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader checkDocMethod
      SEVERE: ORA-00942: table or view does not exist

      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

      For our Problem we can’t find any Solution in the ApexListener Documentation.
      We know with OHS this works because of the DAD with the parameter : PlsqlDocumentProcedure and PlsqlDocumentTablename .
      How can we implement this function in APEX_LISTENER? How is it possible to HTTP POST a Document to a procedure?