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:
http://docs.oracle.com/cd/B14099_19/web.1012/b14010/concept.htm#i1005866
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?