 | |
problem with longvarchar... reads as long
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
problem with longvarchar... reads as long -
10-09-2007
, 08:46 AM
#2
| |||
| |||
|
|
Hi I have a problem when reading a longvarchar, displays as memo in DB Explorer. It reads, but when reading in excel it gives an error (just that). When playing around in DB explorer, I cannot use casting as char, the error: expected char, got long. In the SQL I cannot use || and add something to it. NVL fails too. What should I do? |
David Fitzjarrell
#3
| |||
| |||
|
|
On Oct 9, 8:46 am, Sonnich Jensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: Hi I have a problem when reading a longvarchar, displays as memo in DB Explorer. It reads, but when reading in excel it gives an error (just that). When playing around in DB explorer, I cannot use casting as char, the error: expected char, got long. In the SQL I cannot use || and add something to it. NVL fails too. What should I do? http://asktom.oracle.com/pls/asktom/..._QUESTION_ID:8... |
to find a solution on SQL only.
Or, it is not possible to do.
WBR
Sonnich
#4
| |||
| |||
|
|
On Oct 9, 5:22 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net> wrote: On Oct 9, 8:46 am, Sonnich Jensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: Hi I have a problem when reading a longvarchar, displays as memo in DB Explorer. It reads, but when reading in excel it gives an error (just that). When playing around in DB explorer, I cannot use casting as char, the error: expected char, got long. In the SQL I cannot use || and add something to it. NVL fails too. What should I do? http://asktom.oracle.com/pls/asktom/..._QUESTION_ID:8... Well, unfortunately I cannot create anything on the DB. That leaves me to find a solution on SQL only. Or, it is not possible to do. WBR Sonnich- Hide quoted text - - Show quoted text - |
suspect you'll need to forget this if you can't process the data using
PL/SQL. Simply because someone writes a function doesn't mean you
can't apply something similar with an anonymous PL/SQL block. And it
also depends upon what you intend to do with this data once you get it
'extracted'.
It may well be that you can't do what you want given that you're using
a LONG column.
David Fitzjarrell
#5
| |||
| |||
|
|
On Oct 9, 10:03 am, Sonnich Jensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: On Oct 9, 5:22 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net> wrote: On Oct 9, 8:46 am, Sonnich Jensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: Hi I have a problem when reading a longvarchar, displays as memo in DB Explorer. It reads, but when reading in excel it gives an error (just that). When playing around in DB explorer, I cannot use casting as char, the error: expected char, got long. In the SQL I cannot use || and add something to it. NVL fails too. What should I do? http://asktom.oracle.com/pls/asktom/..._QUESTION_ID:8... Well, unfortunately I cannot create anything on the DB. That leaves me to find a solution on SQL only. Or, it is not possible to do. WBR Sonnich- Hide quoted text - - Show quoted text - LONG columns don't play nicely with SQL*Plus or many other tools. I suspect you'll need to forget this if you can't process the data using PL/SQL. Simply because someone writes a function doesn't mean you can't apply something similar with an anonymous PL/SQL block. And it also depends upon what you intend to do with this data once you get it 'extracted'. It may well be that you can't do what you want given that you're using a LONG column. David Fitzjarrell- Hide quoted text - - Show quoted text - |
2 - What is the length of the actual data? Just as Excel has a limit
to the number of rows of data that it can handle (64k) I would think
that there is also a limit to the length of any cell's data.
3 - The long data type is officially obsolete and where possible
tables with long columns should be converted to using LOB columns.
Just tagging along for info.
-- Mark D Powell --
The Long data type is obsolete and only exists for backward
compatiability.
#6
| |||
| |||
|
|
On Oct 9, 12:15 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net> wrote: On Oct 9, 10:03 am,SonnichJensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: On Oct 9, 5:22 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net> wrote: On Oct 9, 8:46 am,SonnichJensen <sonnich.jen... (AT) jotautomation (DOT) com wrote: Hi I have a problem when reading a longvarchar, displays as memo in DB Explorer. It reads, but when reading in excel it gives an error (just that). When playing around in DB explorer, I cannot use casting as char, the error: expected char, got long. In the SQL I cannot use || and add something to it. NVL fails too. What should I do? http://asktom.oracle.com/pls/asktom/..._QUESTION_ID:8... Well, unfortunately I cannot create anything on the DB. That leaves me to find a solution on SQL only. Or, it is not possible to do. WBR Sonnich- Hide quoted text - - Show quoted text - LONG columns don't play nicely with SQL*Plus or many other tools. I suspect you'll need to forget this if you can't process the data using PL/SQL. Simply because someone writes a function doesn't mean you can't apply something similar with an anonymous PL/SQL block. And it also depends upon what you intend to do with this data once you get it 'extracted'. It may well be that you can't do what you want given that you're using a LONG column. David Fitzjarrell- Hide quoted text - - Show quoted text - 1 - What is DB Explorer? |
is easy to use for testing.
Quote:
|
2 - What is the length of the actual data? Just as Excel has a limit to the number of rows of data that it can handle (64k) I would think that there is also a limit to the length of any cell's data. |
Quote:
|
3 - The long data type is officially obsolete and where possible tables with long columns should be converted to using LOB columns. Just tagging along for info. -- Mark D Powell -- The Long data type is obsolete and only exists for backward compatiability |
reach.
WBR
Sonnich
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.