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

Home -> Community -> Mailing Lists -> Oracle-L -> execute immediate

execute immediate

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Mon, 30 Oct 2000 11:39:58 +0100
Message-Id: <10665.120553@fatcity.com>


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&nbsp; '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

Original text of this message

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