execute immediate,ora936 error

[mkey]

my execute immediate statement look like this:


execute immediate 'insert into my_table values(||X||chr(44)||Y)';

both X and Y are variables.

What is wrong with this statement?

Thanks!

 

[karluk]

Why do you have || before X? What are you concatenating?

 

[mkey]

I'm concatenating the variable:

If flag = True Then
X:= 3;
Y:= 5;
xecute immediate 'insert into pop_lat_long value(||dcXc||chr(44)||dcYc)';
End If;

 

[rohanem]

Hi mkey,
can u plz post the exact error u are getting?..cause I was having problems with execute immediate yesterday

 

[vgg]

Hi mkey,

try this out..

execute immediate
'insert into my_table values('||X||chr(44)||Y||')';

VGG

 

[mkey]

The exact error message is:
ORA-00936: missing expression

Regards,
mkey

 

[mkey]

THANK YOU VGG. YOU ARE A LIVE SAVER.