Re: help for execute immediate

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 18 Jan 2006 08:31:07 GMT
Message-ID: <1137573066.198533@proxy.dienste.wien.at>

ajay <ajaym259_at_yahoo.com> wrote:
> hi i am writing a new stored procedure. the error i am gettin g is i
> have a variable whereclause
> in this i have an and clause as
>

[...]
>
> in am using the same in my execute immediate statement
> but not getting the desired result
>

[...]
>
> the problem is whereclause variable is not getting appended to
> statement

What made you think that? Please post some evidence.

If you have an error message, post it.

If the result you get from the query is not what you expect it to be, describe the difference.

Yours,
Laurenz Albe Received on Wed Jan 18 2006 - 02:31:07 CST