Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is this possible with "execute immediate"

Re: Is this possible with "execute immediate"

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 24 Apr 2006 18:14:40 +0200
Message-ID: <444cf970$0$27281$626a54ce@news.free.fr>

"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
Received on Mon Apr 24 2006 - 11:14:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US