Re: ORA-01461 while moving data from sqlserver to oracle
From: Jan van Veldhuizen (jan_at_van-veldhuizen.nl)
Date: 01/30/05
- Next message: Bob Grommes: "Re: Cannot get OUTPUT parameter after running Sql stored procedure"
- Previous message: Dan: "Re: Recursive relationship in ADO .NET dataset"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 22:27:41 +0100
<Eric> wrote in message news:evRWPc9AFHA.2788@TK2MSFTNGP15.phx.gbl...
> Jan van Veldhuizen wrote:
>
> > Now when a column has 2001 characters or more I get this error. I've
> > read a lot of it, but I do not fully understand what is wrong, and
> > more important, how it can be solved.
>
> Which version of Oracle? I think older versions had a limit of 2000
> bytes in a VarChar2 if I'm not mistaken.
>
Version 9
> You can always use a ?LOB field for larger data, but there's limits of
> how you can query the data.
>
> That limit is higher is newer versions.
>
> By the way, the auto-generated SQL isn't very efficient.
No problem. A conversion program is not run daily. Only once or twice per
customer, so inefficiency is not so bad in that case.
>
> Eric
- Next message: Bob Grommes: "Re: Cannot get OUTPUT parameter after running Sql stored procedure"
- Previous message: Dan: "Re: Recursive relationship in ADO .NET dataset"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
