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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT INTO and EXECUTE IMMEDIATE question

Re: SELECT INTO and EXECUTE IMMEDIATE question

From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Fri, 6 Dec 2002 17:12:38 +0100
Message-ID: <asqi49$1gie$1@ns.felk.cvut.cz>


> Pavel Vetesnik wrote:
> > Hello,
> >
> > I have probably stupid question, but I really don't know how to fix
this:
> >
> > Using simple SELECT in EXECUTE IMMEDIATE statement works fine, But if I
try
> > code like this, I get an error message:
> > ---------------
> > cSQL_Statement:='SELECT heslo FROM el_cas_psh WHERE id=2 INTO cOblast';
> >
> > EXECUTE IMMEDIATE cSQL_Statement
> > ---------------
> >
> > Problem is the INTO clause. This SQL statement returns only 1 row and
the
> > cOblast is also declared.
> >
> > Please can you help me with it?
> >
> > TIA,
> > Pavel
> >
> >
> try
>
> cSQL_Statement:='SELECT heslo FROM el_cas_psh WHERE id=2';
>
> EXECUTE IMMEDIATE cSQL_Statement INTO cOblast;
>
> this should work at least for trunc(oracleversion) >= 9
>

Hi Mathias,

thanks a lot - it works now (Oracle 8.1),

Pavel Received on Fri Dec 06 2002 - 10:12:38 CST

Original text of this message

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