db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: XSCH4, Conglomerate could not be created?
Date Tue, 07 Dec 2010 22:52:43 GMT
John English <je@brighton.ac.uk> writes:

> Can anyone explain what this means? It occurs when I issue what should
> be a straightforward insert:
>
>   INSERT INTO resource_usage (resid,xmlid,xmltable)
>      (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?)

I think we had a similar question not long ago, but I can't find it
right now. Does it help to add a CAST around the "?"s in the SELECT
list? e.g. SELECT resid, CAST(? as <type>), ...

Dag

Mime
View raw message