Re: PL/SQL UNION ERROR : PLEASE HELP

<crognon_at_decan.fr> wrote in message news:838b6j$3d0$1_at_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

The quotation code is syntactic OK, and does not raise this error. It's probable that you typed needless colons. Received on Wed Dec 15 1999 - 22:59:33 CST