Home » SQL & PL/SQL » SQL & PL/SQL » ORA-1300
ORA-1300 [message #196389] Thu, 05 October 2006 03:40 Go to next message
Messages: 3
Registered: September 2006
Junior Member
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
Messages: 52
Registered: September 2005
Location: India
It looks like the problem is with the size of the columns used and the values that is passed to them.

Re: ORA-1300 [message #206389 is a reply to message #196389] Wed, 29 November 2006 19:12 Go to previous messageGo to next message
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
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: Fri Oct 21 15:52:03 CDT 2016

Total time taken to generate the page: 0.42964 seconds