Use of SDO_TUNE.EXTENT_OF - doesn't include schema

Description

Per this thread: http://sourceforge.net/mailarchive/forum.php?thread_name=CA%2BnxMTtNTk50RGzwz4AbS5ZYfn32_SfYPmhoVNxn_AgsTcGQLA%40mail.gmail.com&forum_name=geoserver-users - http://sourceforge.net/mailarchive/forum.php?thread_name=CA%2BnxMTtNTk50RGzwz4AbS5ZYfn32_SfYPmhoVNxn_AgsTcGQLA%40mail.gmail.com&forum_name=geoserver-users

SDO_TUNE.EXTENT_OF is installed but not functioning. I've investigated, there are two issues.

1) The SDO_TUNE.EXTENT_OF query doesn't prefix the table name with the schema name. I'm connecting with a user that doesn't own the data, so the schema name is required. That's why the error is a "table not found" error.
SDO_AGGR_MBR <b>does</b> use the schema name, hence why it works. I believe most queries use the schema name.

2) Not strictly a bug, but what hid this issue for so long - the code catches it and falls back to SDO_AGGR_MBR, which is fine. But are you catching it because you're not sure SDO_TUNE.EXTENT_OF doesn't exist? That's what the error implies to me.
My suggestion would be to explicitly test for SDO_TUNE.EXTENT of - it's some simple SQL:
select * from ALL_procedures where procedure_name = 'EXTENT_OF' and OBJECT_NAME = 'SDO_TUNE'
Returns two rows for me. If it doesn't exist, fall back with debug to SDO_AGGR_MBR. If it does exist but still fails, fallback but include an ERROR level event in the logs.
Just a thought. <img class="emoticon" src="https://jira.codehaus.org/images/icons/emoticons/smile.gif" height="16" width="16" align="absmiddle" alt="" border="0"/>

Environment

None

Status

Assignee

Unassigned

Reporter

codehaus

Triage

None

Fix versions

Affects versions

2.2.3

Components

Priority

Medium
Configure