Re: Is this possible with "execute immediate"

"Jeremy" <jeremy0505_at_gmail.com> a écrit dans le message de news: MPG.1eb7078838ec738498a192_at_news.individual.net... In article <444cf591$0$27282$626a54ce_at_news.free.fr>, says...
>
> "Jeremy" <jeremy0505_at_gmail.com> a écrit dans le message de news: MPG.1eb7036f3bac3c2e98a191_at_news.individual.net...
> |

> |
> | The pl/sql with the "execute immediate" statement doesn't compile - and
> | I understand why - but the question is can anyone tell me how (if) this
> | can be done? It does need to be dynamic.....
> |
>
> Why not just:
>
> vr.procname(p_id=>1,p_name=>l_name);

Becase we don't know the name of "vr.procname" - as I said, it needs to be a dynamic SQL call (or another method where the actual proc name isn't known until runtime - but that *is* dynamic SQL)

-- 

jeremy


So now we know you really need dynamic SQL, what does mean
"The pl/sql with the "execute immediate" statement doesn't compile"?
I never saw Oracle displaying such an error message.

Regards
Michel Cadot