Syntax for selecting from Oracle temporary table..

Hello there,

I am trying to use Oracle temporary table from a stored procedure. I can create and insert data into it without any problem. However, when I try to select from the table as follows:

v_stmt := 'SELECT COUNT(child_id) INTO v_child_count FROM T_TOPIC_RELATIONS ' ||
'WHERE parent_id = ' || v_id;
EXECUTE IMMEDIATE v_stmt;

it compiles fine. However, when I try to run my stored procedure, I get the error: ORA00905: Missing keyword. How can I select from the temp table and store the result in a variable, other than cursor?

I am using Oracle 9.2. Any help will be greatly appreciated!

Thanks a lot in advance.