HELP: how to concat/select a LONG type field ?

From: <monsri_at_my-deja.com>
Date: Thu, 13 Apr 2000 15:28:44 GMT
Message-ID: <8d4p2m$jdh$1_at_nnrp1.deja.com>

Hi,
I'm trying to dynamically create a file containing all my constraints, but I've been stalling against the SEARCH_CONDITION LONG field of the DBA_CONSTRAINTS table. I can't concatenate it to the string 'add check ' for example, and when I do the following:

> select 'alter table &&1'||chr(10)||
> 'add check (',
> search_condition,
> ');'
> from DBA_CONSTRAINTS a,
> DBA_CONS_COLUMNS b
> where a.TABLE_NAME = '&&1'
> and b.TABLE_NAME = '&&1'
> and a.constraint_name = b.constraint_name
> and a.constraint_type = 'C';

I get something very funny: Oracle obsviously gets confused and I'm returned a messy SQL statement, looking like:

> alter table MY_TABLE STCAS = 'O' OR STCAS = 'C'
> add check (

(the string "STCAS = 'O' OR STCAS = 'C'" being the contents of my SEARCH_CONDITION field !)
!!! Anybody can explain me this behaviour ? And does someone think I can solve my problem one way or another ????

Thanks a lot !
Seb

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 13 2000 - 17:28:44 CEST