Type is invalid error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top