Database Problem: "Error-Invalid variant operation"

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

tenix
Posts: 4
Joined: Wed Oct 25, 2006 4:15 pm

Database Problem: "Error-Invalid variant operation"

Postby tenix » Wed Oct 25, 2006 4:20 pm

Hi there,

I'm having some problems getting data out of an Oracle DB. Whenever I try include a field which is defined as a NUMBER field it returns the error:

"Error-Invalid variant operation"

All other field types seem to work fine, it's just the NUMBER.
I've tried many different connect strings including going through the ODBC source with multiple different drivers. I've also tried using a DRIVEr={...} type connect as wel.

If I query the database using sql-plus it works fine and it's using the same driver.

Any ideas it's making the problem rather useless while it's doing this?

Thanks!

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Oct 25, 2006 10:16 pm

I think we've answered this via email, but what you need to try is each field in turn to see where the probem is e.g.

select fielda from tablename
then
select fieldb from tablename
etc until you find the errant field. Once you have it, you can exclude it from the query.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

tenix
Posts: 4
Joined: Wed Oct 25, 2006 4:15 pm

Postby tenix » Thu Oct 26, 2006 8:58 am

I have pegged it down to all fields which are either NUMBER type or DECIMAL.

Unfortunately, the data contained in these fields is important for what I'm working on and I can't afford to exclude that field.

Is there any way to resolve this issue as I'm having serius issues getting things done at the moment?

Cheers.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Oct 26, 2006 10:58 am

Please send an email to support2 @ ... and we'll send you a test version of DataPipe to try and address the problem.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

tenix
Posts: 4
Joined: Wed Oct 25, 2006 4:15 pm

Postby tenix » Thu Oct 26, 2006 11:11 am

I presume the test version you meant is equivalent to the evaluation version online?? I downloaded the DataPipe Evaluation 3.7 and ran the same query and it gave me the following error.

Unknown Type - 131

Does this help?

Cheers.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Oct 26, 2006 11:25 am

Sorry - I meant TextPipe. We'll look into the error and get back to you via email.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

tenix
Posts: 4
Joined: Wed Oct 25, 2006 4:15 pm

Postby tenix » Thu Oct 26, 2006 11:33 am

Thankyou, that would be much appreciated.

Thanks for your continuing assistance.

Cheers.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Tue Oct 31, 2006 2:25 pm

Hi Glen,

We can reproduce the problem easily enough here now, but the news is not good. The error occurs when the record set is opened - this is even before the columns are traversed to extract the data, so it is buried deep in the internal libraries of our development tool. I don't believe we can work around this error until we move to a newer version.

Even with an ODBC connection (with the setting to always provide a precision) the error still occurs.

Unfortunately you'll have to limit TextPipe to non-Oracle work.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests