Re: Execute immediate ???

Ok ,
I don't see what actually what are you trying to do !,

because if ColumnName and MouseId are both variables , then why are you using SQL ,
in the SQl query ColumnName should be a Database ColumnName(fieldName)

What I can understand is that you want to assign the value of CoumnName into MouseID use assignment operator ":=" instead,

Please explain in more detail to have an apropriate answer

Faheem Rao

lyng98_at_yahoo.com (Lu) wrote in message news:<b30359f8.0109281226.452d9889_at_posting.google.com>...
> I need help from any one who can diagnose the problems I have when I
> tried to execute the following code in Oracle8i (8.1.7) in PL/SQL.
>
> The code is listed below:
>
> execute immediate
> 'select '||columnName||' into mouseID from TMP_TAILBLOCK_WELLS'||
> ' where id=1200';
>
> Note: both columnName and mouseID are variables.
>
> This is the error message:
>
> Main section error at row :AAAPiFAADAAACjTAAA
> ORA-00905: missing keyword
Received on Sun Sep 30 2001 - 02:05:13 CEST