Cor Ligthert [MVP]
6/22/2007 6:52:00 PM
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
"william" <william@discussions.microsoft.com> schreef in bericht
news:BD582FC0-0FD6-42CF-BE07-AD0F11588D40@microsoft.com...
> 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]" wrote:
>
>> An idea, yes a bug in Oracle.
>>
>> A char is not an int.
>>
>> Cor
>>
>> "william" <william@discussions.microsoft.com> schreef in bericht
>> news:A95263F9-9DA3-4471-8217-7BD57FD20209@microsoft.com...
>> > 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.
>> >
>>
>>
>>