converting oracle data types

Hope its not to cheeky to post an pl/sql message here?
I suppose its ok as i'm trying to extract data from an
oracle server to SQL server...
There is an oracle datatype of Long and i'm trying to
convert it to a text field, i have tried cast(x as varchar2
(50)) but it doesn't work..any ideas??
Cheers
It's been a while Mat,
I think on the Oracle side, you need to convert the LONG or the CLOB value
you are working with into a text stream. There are multiple Oracle sprocs
to do this.
Soo.. Your best bet is to create a VIEW in Oracle which returns the result
set in a different format.
HTH
Rick
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:08dc01c47ae1$764aa450$a401280a@.phx.gbl...
> Hope its not to cheeky to post an pl/sql message here?
> I suppose its ok as i'm trying to extract data from an
> oracle server to SQL server...
> There is an oracle datatype of Long and i'm trying to
> convert it to a text field, i have tried cast(x as varchar2
> (50)) but it doesn't work..any ideas??
> Cheers

converting oracle data types

Hope its not to cheeky to post an pl/sql message here?
I suppose its ok as i'm trying to extract data from an
oracle server to SQL server...
There is an oracle datatype of Long and i'm trying to
convert it to a text field, i have tried cast(x as varchar2
(50)) but it doesn't work..any ideas'?
CheersIt's been a while Mat,
I think on the Oracle side, you need to convert the LONG or the CLOB value
you are working with into a text stream. There are multiple Oracle sprocs
to do this.
Soo.. Your best bet is to create a VIEW in Oracle which returns the result
set in a different format.
HTH
Rick
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:08dc01c47ae1$764aa450$a401280a@.phx.gbl...
> Hope its not to cheeky to post an pl/sql message here?
> I suppose its ok as i'm trying to extract data from an
> oracle server to SQL server...
> There is an oracle datatype of Long and i'm trying to
> convert it to a text field, i have tried cast(x as varchar2
> (50)) but it doesn't work..any ideas'?
> Cheers

converting oracle data types

Hope its not to cheeky to post an pl/sql message here?
I suppose its ok as i'm trying to extract data from an
oracle server to SQL server...
There is an oracle datatype of Long and i'm trying to
convert it to a text field, i have tried cast(x as varchar2
(50)) but it doesn't work..any ideas'?
CheersIt's been a while Mat,
I think on the Oracle side, you need to convert the LONG or the CLOB value
you are working with into a text stream. There are multiple Oracle sprocs
to do this.
Soo.. Your best bet is to create a VIEW in Oracle which returns the result
set in a different format.
HTH
Rick
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:08dc01c47ae1$764aa450$a401280a@.phx.gbl...
> Hope its not to cheeky to post an pl/sql message here?
> I suppose its ok as i'm trying to extract data from an
> oracle server to SQL server...
> There is an oracle datatype of Long and i'm trying to
> convert it to a text field, i have tried cast(x as varchar2
> (50)) but it doesn't work..any ideas'?
> Cheers