Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> execute immediate
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0425D.C2CB4BFE
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
Which privilege do I need to do 'execute immediate' in stored proc ? It works in sqlplus, but when I call the stored proc, I need more privileges ?
TIA
Luc Demanche
CETELEM
01-46-39-14-49
------_=_NextPart_001_01C0425D.C2CB4BFE
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>execute immediate</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Which privilege do I need to do 'execute immediate' in stored proc ?</FONT>
<BR><FONT SIZE=2 FACE="Arial">It works in sqlplus, but when I call the stored proc, I need more privileges ?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">TIA</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Luc Demanche</FONT>
<BR><FONT SIZE=2 FACE="Arial">CETELEM</FONT>
<BR><FONT SIZE=2 FACE="Arial">01-46-39-14-49</FONT>
</P>
</BODY>
</HTML>
Received on Mon Oct 30 2000 - 04:39:58 CST
![]() |
![]() |