how to retrive the value of variables outside dynamic pl-sql?

Question

I perform the following query:

declare 
  i number;
begin
  execute immediate 'select count(1) from someTable' returning into i;
  dbms_output.put_line(i);
end;

and get this Error: returning clause must be used with insert, update and delete!

possible duplicate of [Using bind variables with dynamic SELECT INTO clause in PL/SQL](http://stackoverflow.com/questions/7816402/using-bind-variables-with-dynamic-select-into-clause-in-pl-sql) — OldProgrammer, Jun 02 '14 at 14:04

score 1 · Answer 1 · answered Jun 03 '14 at 05:21

1

Just a small syntax error (no RETURNING):

DECLARE
    i NUMBER;
BEGIN
    EXECUTE IMMEDIATE 'select count(1) from user_tables' INTO i;
    dbms_output.put_line(i);
END;

answered Jun 03 '14 at 05:21

doberkofler

1 Answers1