Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Invalid Column Name
Hi Anup,
I guess that you are trying to issue dynamic SQL statement in PowerScript. A point you should pay more attention on joining string. If your string need special character, such as ", please add ~ before the one. For example,
ls_sql = "SELECT ~"ACMAST~".~"ACNAME~""
EXECUTE IMMEDIATE :ls_sql ;
-- Best Regards, Reid Lai mailto://reidlai@hk.super.net http://www.hk.super.net/~reidlaiReceived on Wed Feb 26 1997 - 00:00:00 CST