Problem in extract query
Posted: Thu Jun 15, 2006 1:47 pm
hello everyone,
I am facing a problem with an extract query that works well in the sql developer.
the oracle extract query goes like this..
select
a.clm1
null as clm2 (clm2 is decimal)
null as clm3 (clm3 is char)
from a
this query runs well in the sql but when it is run in the oracle enterprise stage it gives error like this -
In field "clm2": Parsing parameters "max=0" for schema type "string": Max length must be positive, got: "0"
I donot get this problem with char field.
is this common??
Thanks
I am facing a problem with an extract query that works well in the sql developer.
the oracle extract query goes like this..
select
a.clm1
null as clm2 (clm2 is decimal)
null as clm3 (clm3 is char)
from a
this query runs well in the sql but when it is run in the oracle enterprise stage it gives error like this -
In field "clm2": Parsing parameters "max=0" for schema type "string": Max length must be positive, got: "0"
I donot get this problem with char field.
is this common??
Thanks