SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

function or pseudo-column 'DECODE' may be used inside a SQL statement only

999511Mar 27 2013 — edited Mar 27 2013

Hi everyone!

I got the error in the subject concernig the follow piece of sql code

+ v_str_sql_body :=
v_str_sql_body || ' and cod_entita ='
|| decode(cur.cod_entita_a,str_all,cur_ent.cod_entita,cur.cod_entita_a);

execute immediate v_str_sql_body; +

I can't understand what's the problem with it.
Can anyone help me to find the error?

Thank you in advance!

Samuel

Edited by: 996508 on 27-mar-2013 5.29

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2013

Added on Mar 27 2013

3 comments

7,145 views