PLS-00306 with Apache tomcat/Apex Listener - ORDS, SODA & JSON in the Database

Hi together,
I have some Problems with the Apex Listener.
The system consists of:
ORACLE 11.1.0
APEX 4.0
APEX Listener version 0.10.110.10.57
apache-tomcat-6.0.26
jre 1.6
Always I try to save/edit something or choose another tab I get the error:
HTTP Status 500 - System Unavailable. Please try again later.
type Status report
message System Unavailable. Please try again later.
description The server encountered an internal error (System Unavailable. Please try again later.) that prevented it from fulfilling this request.
This is not the case, if I only use the application builder. I think, the error occurs only if I am working in a running application.
here is the stdout_log:
APEX Listener version 0.10.110.10.57
Using Config file:D:\Tomcat 6.0\temp\apex\apex-config.xml
-- listing properties --
PropertyCheckInterval=60
ValidateConnection=true
MinLimit=1
MaxLimit=10
InitialLimit=3
AbandonedConnectionTimeout=900
MaxStatementsLimit=10
InactivityTimeout=1800
init: # headers=47
declare nm owa.vc_arr := ?;
     vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:142
CALL:
begin
wwv_flow.accept(fmap=>?,
p_md5_checksum=>?,
fhdr=>?,
p_flow_id=>?,
p_flow_step_id=>?,
p_request=>?,
fcud=>?,
f04=>?,
fcs=>?,
f03=>?,
f02=>?,
f01=>?,
p_page_submission_id=>?,
p_instance=>?);
commit;
end;
BINDS
fmap:ID
p_md5_checksum:
fhdr:Id
p_flow_id:102
p_flow_step_id:51
p_request:SUBMIT
fcud:U
f04: {NEXTNEXTNEXTNEXTNEXT}
fcs: {00A5E05CA539579980E89DED70BC0C693DC38654F6C9278859509EA539207F23A78008F7DB33ADE672F4330576F4C7F4CE2A2C7C39741E4C22B5598071724449075324B645A65925F6CCE709B0AA8A31}
f03: {CANCELCANCELCANCELCANCELCANCEL}
f02: {Manual_DeactivatedManual_ActivatedManual_ActivatedManual_ActivatedManual_Activated}
f01: {27682769277027712772}
p_page_submission_id:1434186759017069
p_instance:4298631303140632
fmap:ID
p_md5_checksum:
fhdr:Id
p_flow_id:102
p_flow_step_id:51
p_request:SUBMIT
fcud:U
f04: {NEXTNEXTNEXTNEXTNEXT}
fcs: {00A5E05CA539579980E89DED70BC0C693DC38654F6C9278859509EA539207F23A78008F7DB33ADE672F4330576F4C7F4CE2A2C7C39741E4C22B5598071724449075324B645A65925F6CCE709B0AA8A31}
f03: {CANCELCANCELCANCELCANCELCANCEL}
f02: {Manual_DeactivatedManual_ActivatedManual_ActivatedManual_ActivatedManual_Activated}
f01: {27682769277027712772}
p_page_submission_id:1434186759017069
p_instance:4298631303140632
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
Can anybody help me solving this problem?
Or is this the wrong constellation with tomcat?
Thanks in advance!
Anja
Edited by: Anja Zahn on Jul 14, 2010 3:41 AM
Edited by: Anja Zahn on Jul 14, 2010 3:41 AM 

First can you download the latest apex listener and try again?
-kris 

Is the new listener supported on Apache tomcat? According to the installation instructions its not listed as one of the supported Application Servers? 

I think user618859 is right. Its not documented with tomcat! Should I try anyway? 

Hi,
Its not supported is that you cannot raise a e-tar, but it runs on Tomcat . You will find related info here http://www.oracle.com/technology/products/database/application_express/html/apex_listener_install_web.html
Regards, 

so, I installed the new version of Apex Listener with tomcat. It works, but I still get some strange error messages concerning checksums. And I can't explain why.
I also installed the new version of Apex Listener with OC4J. This works fine :) 

Kind of the same way support is for any oracle product on virtualization technology that isn't Oracle's own...if they can't reproduce it in the supported environment, then you are out of luck. I don't blame them for the replacement of Tomcat with Glassfish. Glassfish is a very fine j2ee server and now that it is Oracle's they would love to promote it more.

Related

PLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared.

Attempting a "dryrun" of ORDS. More or less got it now working in 12.1.0.2 but hit a hurdle after attempting http://localhost:8080/ords/marco/dbjson/latest/ (where "marco" is my database schema "MARCO")  Error message posts in JSON format {"type":"http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1","status":500,"title":"ORA-06550: Regel 2, kolom 3:\nPLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared.\nORA-06550: Regel 2, kolom 3:\nPL/SQL: Statement ignored.\n","details":"begin\n DBMS_SODA_ADMIN.LIST_COLLECTIONS(\n P_START_NAME => ?,\n P_RESULTS => ?);\nend;","o:errorCode":"SQL-06550"} Aka INFO: Running JSON/REST request GETdec 15, 2014 1:48:14 PM oracle.soda.rdbms.impl.OracleDatabaseImpl getMaxLengthsSEVERE: java.sql.SQLException: ORA-06550: Regel 2, kolom 3:PLS-00201: identifier 'DBMS_SODA_ADMIN.GET_PARAMETERS' must be declared.ORA-06550: Regel 2, kolom 3:PL/SQL: Statement ignored. dec 15, 2014 1:48:14 PM oracle.soda.rdbms.impl.OracleDatabaseImpl callListCollectionsSEVERE: java.sql.SQLException: ORA-06550: Regel 2, kolom 3:PLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared.ORA-06550: Regel 2, kolom 3:PL/SQL: Statement ignored. dec 15, 2014 1:48:14 PM oracle.json.rest.SodaRestHandler runRequestSEVERE: oracle.soda.rdbms.impl.OracleRDBMSExceptiondec 15, 2014 1:48:14 PM oracle.json.web.RestRequest sendErrorINFO: Sending error code 500  Any idea what not has been installed (guess on my part) yet? Package DBMS_SODA_ADMIN is not installed in the database. Marco
Hi Marco, This error usually means that MLR bundle patch 20080249 is not installed.  If you haven't installed it yet, go to support.oracle.com, search for "20080249" and follow the install instructions.  After the patch is installed, it should start working (you don't need to reinstall ORDS).  Note, the patch was initially released with step 6 missing from the instructions.  This was fixed recently.   Thanks,Josh
I have seen the reference in the manual a few days ago. The problem is that I only can find a bundle for Linux (at least that's what in the readme). I am currently trying ORDS on Windows 7... Please confirm that I could apply it on Windows as well. Thanks Marco
Unfortunately the patch is platform specific and the Windows version is not yet available.  I am sorry that you got this far only to find out you can't continue without switching to Linux.  When the Windows version become available, I will let you know.   Josh
No worries. Also attempting to load the two needed jar's into the XMLDB XDB Repository environment, to see if I get the REST API working via the XDB Listener protocol (aka (incorrectly) known as the PL/SQL Gateway) accessing the servlet as a "standalone" solution directly. Would welcome a hint when the Windows patch will be available. Regards Marco
Any updates regarding OS specific solution/patch? 
{"type":"http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1","status":500,"title":"ORA-06550: line 2, column 3:\nPLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared\n
ORA-06550: line 2, column 3:\nPL/SQL: Statement ignored\n","details":"oracle.soda.rdbms.impl.OracleRDBMSException\r\n\tat oracle.soda.rdbms.impl.OracleDatabaseImpl.callListCollections(OracleDatabaseImpl.java:1125)\r\n\
tat oracle.soda.rdbms.impl.OracleDatabaseImpl.loadCollections(OracleDatabaseImpl.java:165)\r\n\tat oracle.soda.rdbms.impl.OracleDatabaseImpl.getCollectionNames(OracleDatabaseImpl.java:450)\r\n\tat
oracle.soda.rdbms.impl.OracleDatabaseImpl.getCollectionNames(OracleDatabaseImpl.java:443)\r\n\tat oracle.soda.rdbms.impl.OracleDatabaseImpl.getCollectionNames(OracleDatabaseImpl.java:418)\r\n\tat
oracle.soda.rdbms.impl.OracleDatabaseImpl.access$400(OracleDatabaseImpl.java:64)\r\n\tat oracle.soda.rdbms.impl.OracleDatabaseImpl$OracleDatabaseAdministrationImpl.getCollectionNames(OracleDatabaseImpl.java:1279)\r\n\tat
oracle.json.rest.SodaRestHandler.listCollections(SodaRestHandler.java:341)\r\n\tat oracle.json.rest.SodaRestHandler.runRequest(SodaRestHandler.java:1522)\r\n\tat oracle.json.web.RestRequest.runRequest(RestRequest.java:1107)\r\n\tat
oracle.json.web.RestServlet.runRequest(RestServlet.java:228)\r\n\tat oracle.json.web.RestServlet.doGet(RestServlet.java:240)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:740)\r\n\tat
oracle.json.web.RestServlet.service(RestServlet.java:311)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:853)\r\n\tat oracle.xdb.servlet.XDBServletContainer.handleRequest(XDBServletContainer.java:103)\r\n
Caused by: java.sql.SQLException: ORA-06550: line 2, column 3:\nPLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared\nORA-06550: line 2, column 3:\nPL/SQL:
Statement ignored\n\r\n\tat oracle.jdbc.driver.T2SConnection.check_error(T2SConnection.java)\r\n\tat oracle.jdbc.driver.T2SCallableStatement.checkError(T2SCallableStatement.java:123)\r\n\tat
oracle.jdbc.driver.T2SCallableStatement.executeForRows(T2SCallableStatement.java)\r\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)\r\n\tat
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java)\r\n\tat
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java)\r\n\tat oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java)\r\n\tat
oracle.soda.rdbms.impl.OracleDatabaseImpl.callListCollections(OracleDatabaseImpl.java:1073)\r\n\t... 15 more\r\nCaused by: oracle.jdbc.driver.OracleSQLException: O
RA-06550: line 2, column 3:\nPLS-00201: identifier 'DBMS_SODA_ADMIN.LIST_COLLECTIONS' must be declared\nORA-06550: line 2, column 3:\nPL/SQL: Statement ignored\n\r\n","o:errorCode":"SQL-06550"}
As far as I know, only Linux and Solaris so far.  If I hear something about Windows, I will update this thread.  Sorry for the inconvenience.   Thanks,Josh
On my TEST system  !!!   Downloaded the patchUnzipped itCopied needed SQL & packages etc to RDBMS\adminRan the patch main script after altering the define variables 1,2,3,4 (not really needed here afaik/could see) Rerun my test via http://localhost:8080/DBJSON/ Now it seems to work (the basis that is via the XDB Listener servlet environment). 
{"type":"http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1","status":400,"title":"A schema must be specified.","o:errorCode":"REST-02017"}
  
It appears the windows version of the patch is now available. Thanks,Josh

Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0

Hello,
I'm very pleased how well APEX Listener works with our existing applications (100s of pages). So far we've found only one issue we can't work around:
The problem occurs when user is trying to save page customization when using APEX Listener.
Steps to replicate:
1) Create an APEX page with region and set "Customization" to "Customizable and Shown By Default"
2) Run the page & click on "Customize" link
3) The customization pop-up is presented
4) Click on "Apply changes"
5) Error: HTTP Status 500 - System Unavailable. Please try again later.
The Apache Tomcat stdout log is attached bellow.
When we use Oracle HTTP server (running on the same database) no error occurs.
Configurations (3 environments with the same results):
* APEX Listener 0.10.110.10.57
* Apache Tomcat 6.0.26 (Windows)
* APEX 3.0.1 & Database 11g Release 1 (Windows)
* APEX 3.2.1 & Database 11g Release 2 (Linux & Windows)
* APEX 4.0.0 & Database 11g Release 2 (Windows)
Thanks for any ideas,
Jan
-----
init: # headers=47
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:133
CALL:
begin
FLOWS_030000.wwv_flow_customize.accept(p_session=>?,
p_flow=>?,
p_lang=>?,
p_page=>?,
p_request=>?,
p_check=>?);
commit;
end;
BINDS
p_session:8387122011225562
p_flow:116
p_lang:en-us
p_page:301
p_request:DOIT
p_check:227161929735196086
p_session:8387122011225562
p_flow:116
p_lang:en-us
p_page:301
p_request:DOIT
p_check:227161929735196086
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored 
I am having similar error when I just click on a different tab.
My environment is:
Windows 7 64 bit
Oracle 11g 11.0.0.7 64 bit
APEX 4.0
APEX Listener version :0.10.110.10.57
Tomcat 6.0.26 64 bit
init: # headers=48
declare nm owa.vc_arr := ?;
     vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:123
CALL:
begin
wwv_flow.accept(fmap=>?,
p_md5_checksum=>?,
fhdr=>?,
p_flow_id=>?,
p_arg_names=>?,
p_flow_step_id=>?,
p_request=>?,
f07=>?,
f06=>?,
f05=>?,
fcud=>?,
f04=>?,
p_t03=>?,
fcs=>?,
f03=>?,
p_t02=>?,
f02=>?,
p_t01=>?,
f01=>?,
p_page_submission_id=>?,
p_instance=>?);
commit;
end;
BINDS
fmap:ID
p_md5_checksum:
fhdr:Id
p_flow_id:124
p_arg_names: {130192630919901213042194243265201302107392199031}
p_flow_step_id:3
p_request:
f07: {}
f06: {SALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIM}
f05: {23-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-10}
fcud:U
f04: {-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1}
p_t03:0830-1030
fcs: {4913A437A8555DFD6256617C43EC4F6E787AF0EA51C4ACD1DEA325BFFFD9FC42E0EA11A98E84AE7637B3CB68DF111DE6772C6EDFAE59C0E9CED6AB1C4808305554F697DC6FE06BC143696B253357E27E8816DB9D3DF502D70A1679AA76F09D725E47D743C504E0663491006196DB4254A7C5258C760B5DA782B993E1C97F9B2108A232F2F223F63C1BA2790DE802E481A292FF419EB323F1C124B6AC5F838C969C0AC36D8E554135B1910E3D0A128AEEF992C7A26A40FCEF24E770D118C2DA77828BDF680A10BD3B694DEAF259360785795C7DBB031B87E3CC578AC0A1EA5C326ED1A02E90B0CB272483E24E38986155E06ED3E1D3EC26FFA850E5285F7AC706}
f03: {V00011228V00011453V00011570V00011593V00011639V00011694V00011706V00011808V00012024V00012033V00013430V00013507V00013508V00013522V00013826V00014360}
p_t02:V00010026
f02: {V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026}
p_t01:3-FEB-2010
f01: {15157151581515915160151611516215163151641516515166151671516815169151701517115172}
p_page_submission_id:2720755601478681
p_instance:2914143952562994
fmap:ID
p_md5_checksum:
fhdr:Id
p_flow_id:124
p_arg_names: {130192630919901213042194243265201302107392199031}
p_flow_step_id:3
p_request:
f07: {}
f06: {SALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIM}
f05: {23-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-10}
fcud:U
f04: {-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1}
p_t03:0830-1030
fcs: {4913A437A8555DFD6256617C43EC4F6E787AF0EA51C4ACD1DEA325BFFFD9FC42E0EA11A98E84AE7637B3CB68DF111DE6772C6EDFAE59C0E9CED6AB1C4808305554F697DC6FE06BC143696B253357E27E8816DB9D3DF502D70A1679AA76F09D725E47D743C504E0663491006196DB4254A7C5258C760B5DA782B993E1C97F9B2108A232F2F223F63C1BA2790DE802E481A292FF419EB323F1C124B6AC5F838C969C0AC36D8E554135B1910E3D0A128AEEF992C7A26A40FCEF24E770D118C2DA77828BDF680A10BD3B694DEAF259360785795C7DBB031B87E3CC578AC0A1EA5C326ED1A02E90B0CB272483E24E38986155E06ED3E1D3EC26FFA850E5285F7AC706}
f03: {V00011228V00011453V00011570V00011593V00011639V00011694V00011706V00011808V00012024V00012033V00013430V00013507V00013508V00013522V00013826V00014360}
p_t02:V00010026
f02: {V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026}
p_t01:3-FEB-2010
f01: {15157151581515915160151611516215163151641516515166151671516815169151701517115172}
p_page_submission_id:2720755601478681
p_instance:2914143952562994
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored 
This seems to be a bug. Have you contacted Oracle Support?
regards 
Just tested with final release of listener (1.10.179.10.43) and it works fine on APEX 4.0 & 11gR2.
Sorry to see Tomcat is not listed as supported J2EE server anymore :-(
Jan 
How you tested the last APEX listener w/o Tomcat? 
I have the same issue on tomcat : (Apex Listener 1.10.179.10.43)
p_col_nam:RAW_DEM_DDL_DCT
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_SCH_RLS_MOL_DEM'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_SCH_RLS_MOL_DEM'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
I put the old version 0.10.110.10.57 and it works. Do we have any chance to have tomcat support?
Regards,
Eric.

Errors for 'Embedded R' example

I am having hard time making embedded R examples to work:
BEGIN
sys.rqScriptCreate('PETERFUN',
'function() {ID <- 1:10; res <- data.frame(ID = ID, RES = ID / 100); res}');
END;
/
select * from table(rqEval(NULL,NULL,'PETERFUN'));
ORA-29400: data cartridge error
ORA-24323: value not allowed
ORA-06512: at "RQSYS.RQEVALIMPL", line 23
ORA-06512: at line 4
29400. 00000 - "data cartridge error\n%s"
*Cause:    An error has occurred in a data cartridge external procedure.
This message will be followed by a second message giving
more details about the data cartridge error.
*Action:   See the data cartridge documentation
for an explanation of the second error message.
Does not work in SQLDeveloper or from sqlplus prompt. DB version 11.2.0.2 with patch installed.
Did anyone succeed in making similar example to work on their own instance? 
PG,
Please, double check that you indeed have installed the patch for bug 11678127: OCIDESCRIBEANY RETURNS ORA:24323 FOR AN OBJECT TYPE USE CASE. The symptom you are seeing matches perfectly with the bug description. The patch is need to 11.2.0.1 and 11.2.0.2. It is not needed for 11.2.0.3 as it already includes the bug fix. 
Hate to admit this, but it turns out patch was not applied properly. I'm getting new error now, though:
select * from table(rqEval(NULL,NULL,'PETERFUN'));
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-06512: at "RQSYS.RQEVALIMPL", line 7
ORA-06512: at line 4
Something else we did not configure? 
Is this problem resolved?
If not, it's possible that extproc is not setup/working properly here.
Please check the following:
1. Verify $ORACLE_HOME/hs/admin/extproc.ora contains this line: SET EXTPROC_DLLS=ANY
2. If 1 is verified, then check the following suggested actions for ORA:28546:
// *Action:  Check Net8 administration in the following ways:
// -- When using TNSNAMES.ORA or an Oracle Names server, make sure
// that the connection from the ORACLE server uses the correct
// service name or SID.
// -- Check LISTENER.ORA on the connection end point's host machine
// to assure that this service name or SID connects to the
// correct program.
// -- Confirm in TNSNAMES.ORA or the equivalent service definition
// that service 'extproc_connection_data' does NOT contain
// (HS=), or that the service definition used by a
// Heterogeneous Services database link DOES contain (HS=)
Sherry 
Sherry,
Thanks for suggestions - according to our DBA these are all set correctly on our environment.
Peter 
Peter,
Do you need any help with this?
Denis
Edited by: Denis Mukhin on Mar 15, 2012 6:40 PM 
With many thanks to Denis, problem was resolved - I believe in the end it was caused by listener configuration and few misplaced .so files.
Thanks again,
Peter

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? 
anyone?
If you have a better solution let me know. i did this way ... in apex web.xml a servlet filter that use a HttpServletRequestWrapper to rewrite the request if httpRequest.getContentType().indexOf("multipart") the file become a standard String parameter (filename) and the byte[] is inserted in the documents table.

PLS-00221: 'ORDS' is not a procedure or is undefined

Getting the following error message in apex 4 to 5.0 upgraderunning new weblogic 12c install for apex listener java -jar ords.warcommand issues successfullybut when referencing http://<host>:8080/ords/the follow error message is thrown... Jul 13, 2015 9:04:22 AM oracle.dbtools.http.errors.ErrorPageFilter logSEVERE: java.sql.SQLException: ORA-06550: line 2, column 2:PLS-00221: 'ORDS' is not a procedure or is undefinedORA-06550: line 2, column 2:PL/SQL: Statement ignored Install has separate db and weblogic hosts, so I feel this is potentially a permissions issue in our db tier, but have verified all obvious settings to me with no luck. Looking for recommendations on next place to look at install issues. Thx in advance!

Categories

Resources