Home » SQL & PL/SQL » SQL & PL/SQL » ORA-1300
ORA-1300 [message #196389] Thu, 05 October 2006 03:40 Go to next message
ennio
Messages: 3
Registered: September 2006
Junior Member
Hi.....
I occourred in this Error:
SELECT SDO_GEOM.SDO_Distance(A.geom,B.geom,0.00005)
FROM montane A,montane B
ORA-1300: dimension number out of range
The number of dimension are two and the table also are at two dimension,,,,
Also it work when i restricted the distance to 0,,,,,
What the problem?
Re: ORA-1300 [message #196399 is a reply to message #196389] Thu, 05 October 2006 03:53 Go to previous messageGo to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
It looks like the problem is with the size of the columns used and the values that is passed to them.

Thanks
Re: ORA-1300 [message #206389 is a reply to message #196389] Wed, 29 November 2006 19:12 Go to previous messageGo to next message
artmast
Messages: 11
Registered: October 2006
Junior Member
According to Oratip http://oratip.com/ORA-01300.html the error message code ORA-01300 is completely different to the one you say. Is that the right error code? The error Oratip says is "enabled thread bit vector mismatch between dictionary string and the earliest logfile".
Re: ORA-1300 [message #206448 is a reply to message #206389] Thu, 30 November 2006 01:52 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ahhh, the joys of using the proper documentation, rather than 3rd party sites.

If you look here you can see that while ORA-1300 doesn't match the message provided, ORA-13000 is spot on.
Previous Topic: Column as rows in PL/SQL Select Statement
Next Topic: create foreign key trigger
Goto Forum:
  


Current Time: Thu Dec 08 10:43:19 CST 2016

Total time taken to generate the page: 0.12050 seconds