exec immediate 2006-01-24 - By David Sharples
the semi colon goes after the final ' in the statement.
Plus that query is a little silly anyway
On 1/24/06, raja rao <raja4list@(protected)> wrote:
>
>
> when the below is run i am getting the error. can someone help me :
>
> begin
> execute immediate ' select sysdate from dual ;'
> end ;
>
>
<div>the semi colon goes after the final ' in the statement.</div>
<div> </div>
<div>Plus that query is a little silly anyway<br><br> </div>
<div><span class="gmail_quote">On 1/24/06, <b class="gmail_sendername">raja rao
</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto
:raja4list@(protected)" target="_blank">raja4list@(protected)</a>> wrote:
</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div> </div>
<div>when the below is run i am getting the error. can someone help me :</div>
<div> </div>
<div>begin<br>execute immediate ' select sysdate from dual ;'<br>end ;<
/div>
<div> </div></blockquote></div>
|
|
