Type is invalid error

[Guest]

Hi,

I have a tableadapter which is used to access Oracle database using OLEDB
for Oracle. I have a query on this adapter which consumes a procedure, this
procedure has output parameter as Char(1) or Int. From my business layer, I
call the adapter query by passing parameter of out string. It works perfect
for Oracle.
Since this app is supposed to support both Oracle and SQL, so I wrote a
similar stored procedure on SQL Server 2005, which has output parameter as
char(1) as well. I changed connection string of the adapter to point to my
sql server. When I run my application, I got error "Type is Invalid". It even
doesn't go to database( I traced database).
Any idea?

Thanks.

 

[Cor Ligthert [MVP]]

An idea, yes a bug in Oracle.

A char is not an int.

Cor

 

[Guest]

Hi Cor,
Thanks for your response. But I think you misunderstood what I mean, or I
didn't say it clearly. Here is the story.
I have two procedures on Oracle database, one has char as output parameter,
another one has int as output parameter. So in my tableadapter, I have one
query for each procedure.

Thanks.

william

 

[Cor Ligthert [MVP]]

William,

No but can you show us how you have created the parameter in VB/C# including
the adding of that to the command. I will not say that I knot the answer
however maybe others do.

Cor