Mark,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original Message-
Se
Stephane,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original Message
Hi,
In SQL*Plus "set long 250"
Jack
"Mark Liggayu"
Mark Liggayu wrote:
>
> HI GURUS,
>
> If I have a table that has a field with long data type and I want to get the
> first 250 characters out of it how can I do it. I tried using SUBSTR(long
> data type field, 1, 250) but it complained about "ORA-00932: inconsistent
> datatypes". I then tried