Toad World® Forums

Re: Oracle Typen MDSYS.ST_ANNOT_TEXTELEMENT_ARRAY

Re: Oracle Typen MDSYS.ST_ANNOT_TEXTELEMENT_ARRAY

habe mit beiden Versionen 32/64 bit

This appears to be a conflict with regards the “Oracle Spatial”
datatype. Is anyone familiar with that particular datatype in relation to Toad
that might be able to offer some insight? Does Toad 11 support that datatype?

Earlier in the thread it was already suggested to move away from the 64 bit
client and on to the 32 bit client. Whether that has occurred is anyone’s
guess.

Roger S.

There is no question of whether or not he is using a 64 bit client with Toad,
because it is not possible. J He’s got to be using 32 bits with Toad, or
his is not connecting to the database.

Those spatial datatypes are pretty complicated, and some of these complicated
data types just don’t work well with the Unicode-enabled
procedures/functions in the OCI. I don’t have a hard and fast list of what
works and what doesn’t, but your best bet is to always have the most
recent 32 bit Oracle client for Toad.

Afternoon all,

Those spatial data types are pretty complicated,
What John really means is “a monumental PITA”! :wink:

these complicated data types just don’t work well with the
Unicode-enabled procedures/functions in the OCI. I don’t
have a hard and fast list of what works and what doesn’t,
but your best bet is to always have the most recent 32 bit
Oracle client for Toad.
And even then, it may not work.

I created a table this morning with one of these data types, single column. I didn’t add any data to the table, just created it. This was in 10.2.0.4 with a corresponding client.

Toad 10.6 GA handled the creation perfectly.

Toad also handled an F4 on the table name.

Toad went limp when I clicked on the data tab of the F4 window. The “throbber” throbbed for a while, then my desktop’s fan kicked in and sounded like a Airbus 380 taking off. When I managed to get Task Manager to work, CPU was at 100%.

I left it 10 mins while I had a coffee and when it showed no signs of abating, I had to kill Toad. :frowning:

I haven’t tried with Toad 11 as I can’t run it on Windows 2000. I also don’t have an 11g “play” database that I can use.

Cheers,
Norm. [TeamT]

Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Build Team
Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk