Home » SQL & PL/SQL » SQL & PL/SQL » Out of present range
Out of present range [message #267392] Thu, 13 September 2007 03:22 Go to next message
skyloon
Messages: 2
Registered: September 2007
Junior Member
I've use VB as my front-end and oracle as my back-end.
I tried to use the program to purge data from 8i to 9i, all the while
there is no problem, but after sometimes, when i purge the data, it
will prompt this error message: "Out of present range".
Sometimes data has successfully moved to archive database, but some of
them still in the original database, when i tried to use query run in
the sql plus, it can successfully purged, don't know why system has
successfully purged, but no data has been moved. No error message
also.
Anyone know what is the problem?
Re: Out of present range [message #267397 is a reply to message #267392] Thu, 13 September 2007 03:28 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is it an Oracle error? Does it have its code (such as ORA-00942)? I've never seen such a message (which doesn't have to mean much, of course), but - are you sure it isn't your VB front-end which caused this error?
Re: Out of present range [message #267399 is a reply to message #267392] Thu, 13 September 2007 03:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I don't think that's an Oracle error message - Does it present with an ORA-xxxxx error code?
Re: Out of present range [message #267401 is a reply to message #267392] Thu, 13 September 2007 03:41 Go to previous messageGo to next message
skyloon
Messages: 2
Registered: September 2007
Junior Member
i've tried to search on internet, no result also, don't know where its come from. I use vb to execute the query and return the error message, no error number in front.
Re: Out of present range [message #267404 is a reply to message #267401] Thu, 13 September 2007 03:47 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I did a search too, and it looks like a VB error, possibly related to the size limit on INT datatypes.
Previous Topic: procedure
Next Topic: struck up with UNION
Goto Forum:
  


Current Time: Tue Dec 06 12:33:56 CST 2016

Total time taken to generate the page: 0.09061 seconds