I tryies using the '-' so I got access to the "default" schema for the
logged-in user.
Maybe it's this the culprit, something in how your server/database/schena/user,
etc. are configured...???
Try with this SQL from any Oracle client:
select sys_context( 'userenv', 'current_schema' ) from dual
It should return the current default schema for the logged-in user.
If it's different from the one you see in the EXTENT_OF() call, then that may
be the problem.
Then you can manually try the EXTENT_OF() using 'SCHEMA.TABLE' with this
schema, if it's different.
I don't know if the EXTENT_OF() needs an entry for the table you want the
extent of inside the
user_sdo_geom_metadata table, but check it's presence.
And also check if it's listed there with just the TABLE_NAME or the SCHEMA_NAME
also.
I'm not the "owner" of the Oracles I connect to, so I'm sure about the version,
but I think it's
the same of yours 10g and it contains a few schemas (one for each user, that's
the way Oracle works, I think)...
Now, and up to Friday, I have no access to the server, so I can't make any
other check.
Bye
Paolo Rizzi
________________________________
Da: Stefan Steiniger [mailto:[EMAIL PROTECTED]
Inviato: mer 03/12/2008 20.22
A: List for discussion of JPP development and use.
Oggetto: [JPP-Devel] R: R: [Fwd: [jump-pilot - Problems with PlugIns] RE:
Problems getting Oracle Connection]
-------- Original Message --------
Subject: [jump-pilot - Problems with PlugIns] RE: Problems getting
Oracle Connection
Date: Wed, 03 Dec 2008 19:02:18 +0000
From: SourceForge.net <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=5753244
By: simonecampora
Oh I'm really sorry!
I was citing the code by heart... actually my synthax is exactly like yours....
the second parameter is the geometry column ( incidently it's the same as the
schema name in my case)
anyway I still don't know why in my case it is not working while I'm specifying
the SCHEMA.TABLE but it works when I use just the TABLE.
are you using the "-" or " " in the schema parameter?
how many shcemas do you have in your database?
are you using which version of Oracle?
mine is Oracle 10g Entreprise Edition
I will try doing that small modification on the code just to see if it's really
the problem raised or if there's something more behind...
thanks you so much for your precisations :) they are really precious!
Simone
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=729480
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
