PL/SQL UNION ERROR : PLEASE HELP

From: <crognon_at_decan.fr>
Date: Wed, 15 Dec 1999 15:13:26 GMT
Message-ID: <838b6j$3d0$1@nnrp1.deja.com>

Hello everybody,

I hope someone will help me on this one :

I have a PL/SQL stored procedure that tries to do something like that :

BEGIN
...

	INSERT into table1(a, b)
	select T.x , T.y from
	((SELECT m1 as x , m2 as y from M)
	UNION
	(SELECT n1 as x , n2 as y from N)) T;

...

END; When I test the SQL code through sqlplus, it works fine (the select part)
When I try to run it, it sends me an exception ORA-01745: invalid host/bind variable name

The only time it worked was when I did some testing using only varchar2 type fields

I don't find any documentation on this behaviour.

If you have any clue, I would heavily apreciate.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 09:13:26 CST