OraFAQ Forum: SQL & PL/SQL » execute immediate issue

Home » SQL & PL/SQL » SQL & PL/SQL » execute immediate issue - updated

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

execute immediate issue - updated [message #36026]

Tue, 30 October 2001 12:33

kshathrya
Messages: 29
Registered: October 2001

Junior Member

can u tell me whats the issue here, please. The table name is not being picked by the execyte immediate

DECLARE
v NUMBER;
v_obj_name VARCHAR2 (40);
qry VARCHAR2 (100);
BEGIN
v_obj_name := 'MAN';
qry := 'SELECT COUNT(*) INTO '
|| v
|| ' FROM '
|| v_obj_name ;
EXECUTE IMMEDIATE qry;
DBMS_OUTPUT.put_line (v);
END;

----------------------------------------------------------------------

Report message to a moderator

Re: execute immediate issue - updated [message #36027 is a reply to message #36026]

Tue, 30 October 2001 13:34

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

DECLARE
v NUMBER;
v_obj_name VARCHAR2 (40);
qry VARCHAR2 (100);
BEGIN
v_obj_name := 'MAN';
qry := 'SELECT COUNT(*) FROM ' || v_obj_name;
EXECUTE IMMEDIATE qry into v;
DBMS_OUTPUT.put_line (v);
END;

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	SELECT with variables
Next Topic:	SQL Query - return values from 2 rows as 1 row??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:05:22 CST 2024