Re: Execute Immediate in PL/SQL (Oracle 8i)

IIRC *INTO* doesn't work well with native dynamic sql, which is what I think you are trying to do. Generally speaking you would return into a user defined record or some sort of thing instead. The INTO would then be outside the sql statement, with the user defined record (usually based upon your query return set) as the target.

execute immediate v_sql into user_record

where user_record might have x number of component columns

good luck Received on Thu Jan 09 2003 - 07:38:10 CST