Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

2989507Jul 13 2015 — edited Jul 13 2015

Getting the following error message in apex 4 to 5.0 upgrade

running new weblogic 12c install for apex listener

java -jar ords.war

command issues successfully

but when referencing http://<host>:8080/ords/

the follow error message is thrown...

Jul 13, 2015 9:04:22 AM oracle.dbtools.http.errors.ErrorPageFilter log

SEVERE: java.sql.SQLException: ORA-06550: line 2, column 2:

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

ORA-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!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 10 2015
Added on Jul 13 2015
0 comments
715 views