Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0 - ORDS, SODA & JSON in the Database

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.

Related

PLS-00306 with Apache tomcat/Apex Listener

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.

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.

APEX - Error installing and running a sample application

Hi,I'm new to Oracle Application Express and was told to play with some of the sample application that some with the installation. After installing apex 4.2 and creating workspaces, users etc, i installed the Sample Application Database package but when it came to running the application i get the below error messageThe following error has occurred while executing the error handling callback: ORA-06550: line 5, column 38: PLS-00201: identifier 'SAMPLE_PKG.DEMO_ERROR_HANDLING' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-00942: table or view does not existAlso when it came to installing another package, Sample Websheet - AnyCo IT Department, it get the following error message;Invalid Websheet ObjectsThe database objects required to create Websheet applications are either invalid or do not exist. Please contact your Workspace Administrator. Any help pls?

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

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