Orale Types MDSYS.ST_ANNOT_TEXTELEMENT_ARRAY

Toad for Oracle
1

Hi,

this data type (Oracle Spatial data type) in any query causes a TOAD crash !

Does anyone have a workaround for this problem or is a BUG ?

Please help me

Thanks

SP

2

Morning,

This is the wrong group for this problem. You need Toad@yahoogroups - this group is for Toad SQL questions. However ....

Hi, this data type (Oracle Spatial data type) in any
query causes a TOAD crash ! Does anyone have a workaround
for this problem or is a BUG ? Please help me Thanks SP

You need to supply a lot more information I'm afraid:

  • Version of Oracle database
  • Version of Oracle client in use by Toad
  • Version of Toad

Some versions of Toad are older, ditto clients etc and may not "know" about this data type. I know I have problems with Oracle 9i client on 10g databases when selecting from TIMESTAMP WITH TIMEZONE data types.

Cheers,
Norm. [TeamT]

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

3

Message from: oracle_828

HI thanks for the quick response : * Version of Oracle database - Oracle
Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production * Version
of Oracle client in use by Toad - Oracle Client 11.2.0.1.0 * Version of Toad -
Toad for Oracle Professional 11.0.0.116 I hope that’s enough information …
Thanks in advance SP P.S.: I apologize for having missed the group I did not
notice … :slight_smile:

Historical Messages

Author: oracle_828
Date: Wed Oct 12 05:23:36 PDT 2011
HI thanks for the quick response : * Version of Oracle database - Oracle
Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production * Version
of Oracle client in use by Toad - Oracle Client 11.2.0.1.0 * Version of Toad -
Toad for Oracle Professional 11.0.0.116 I hope that’s enough information …
Thanks in advance SP P.S.: I apologize for having missed the group I did not
notice … :slight_smile:
__

Author: Norman Dunbar
Date: Wed Oct 12 03:07:23 PDT 2011
Morning, This is the wrong group for this problem. You need Toad@yahoogroups -
this group is for Toad SQL questions. However … >> Hi, this data type
(Oracle Spatial data type) in any >> query causes a TOAD crash ! Does
anyone have a workaround >> for this problem or is a BUG ? Please help me Thanks
SP You need to supply a lot more information I’m afraid: * Version of Oracle
database * Version of Oracle client in use by Toad * Version of Toad Some
versions of Toad are older, ditto clients etc and may not “know” about this data
type. I know I have problems with Oracle 9i client on 10g databases when
selecting from TIMESTAMP WITH TIMEZONE data types. Cheers, Norm. [TeamT]
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
__

Author: oracle_828
Date: Wed Oct 12 01:03:46 PDT 2011
Hi, this data type (Oracle Spatial data type) in any query causes a TOAD
crash ! Does anyone have a workaround for this problem or is a BUG ? Please help
me Thanks SP
__

4

HI

thanks for the quick response :

  • Version of Oracle database
    • Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  • Version of Oracle client in use by Toad
    • Oracle Client 11.2.0.1.0
  • Version of Toad
    • Toad for Oracle Professional 11.0.0.116

I hope that’s enough information …

Thanks in advance

SP

P.S.: I apologize for having missed the group I did not notice … :slight_smile:

6

Apparently Norm forgot to ask his question… :slight_smile:

Question for confirmation, you’re using the 32 bit Oracle 11g client,
correct?

Roger S.

7

Evening Roger,

Apparently Norm forgot to ask his question… :slight_smile:
Nope, just making sure it hit the correct group - toad as opposed to
toadsql. :wink:

--
Cheers,
Norm. [TeamT]