Hey there!
Coming as a mod_plsql user and fan to ORDS, I'm struggeling the last few days to get my “so-far-DAD-driven" web-app working.
I'm on ORDS 24.1.0.r0960841 on Apache Tomcat/9.0.88 with DB 21c XE (Windows). – I don't need APEX now. I just want to use the PL/SQL Gateway feature.
Testwise for this post I've created a database pool with the name: webapp. pool.xml:
<entry key="db.connectionType">basic</entry>
<entry key="db.hostname">localhost</entry>
<entry key="db.port">1521</entry>
<entry key="db.servicename">xepdb1</entry>
<entry key="db.username">webapp</entry>
<entry key="error.responseFormat">html</entry>
<entry key="plsql.gateway.mode">direct</entry>
<entry key="security.requestValidationFunction"></entry>
The username for the pool is webapp. Then I've created a package named webapp
The package has one procedure called whoami which just prints out some values from userenv like session_schema, current_schema and proxy_user just for let me know, if ORDS make things like using proxy users. Please remember, I'm a ORDS-newby …
But, there is no way to get the URL http://server/ords/webapp/webapp.whoami working.
I get: HTTP Status Code: 500 . The end of the Stack Trace shows:
at oracle.dbtools.apex.OWA.execute(OWA.java:142)
... 91 more
Caused by: Error : 6550, Position : 15, Sql = begin
**WEBAPP.WEBAPP."WHOAMI"**;
commit;
end;, OriginalSql = begin
WEBAPP.WEBAPP."WHOAMI";
commit;
end;, Error Msg = ORA-06550: Zeile 2, Spalte 9:
PLS-00302: Komponente 'WEBAPP' muss deklariert werden
ORA-06550: Zeile 2, Spalte 2:
PL/SQL: Statement ignored
Using a different database-pool name does not help. If I create a procedure webapp in then schema webapp and call this, the Stack Trace says:
at oracle.dbtools.apex.OWA.execute(OWA.java:142)
... 91 more
Caused by: Error : 6550, Position : 16, Sql = begin
WEBAPP."WEBAPP";
commit;
end;, OriginalSql = begin
WEBAPP."WEBAPP";
commit;
end;, Error Msg = ORA-06550: Zeile 2, Spalte 10:
PLS-00225: Referenz auf Unterprogramm oder Cursor 'WEBAPP' ist außerhalb des Geltungsbereichs
ORA-06550: Zeile 2, Spalte 2:
PL/SQL: Statement ignored
Is there a known issue when schema-name and a package or a procedure have the same name?
Thanks in advance