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 -> SELECT INTO and EXECUTE IMMEDIATE question

SELECT INTO and EXECUTE IMMEDIATE question

From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Fri, 6 Dec 2002 15:24:04 +0100
Message-ID: <asqbon$1e8u$1@ns.felk.cvut.cz>


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 Received on Fri Dec 06 2002 - 08:24:04 CST

Original text of this message

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