Can any one solve this ????

DukeNukem · 12-06-2007, 11:37 AM

Hi there Angels

can somebody, anybody tell me whats wrong with this thing and how to correct it ????
-- Oracle 9i rel2
create or replace procedure p_parent (v_parent varchar2, v_contract varchar2)
is
pragma autonomous_transaction;
begin
dbms_output.put_line ('CREATE TABLE TEMP_PS');
execute immediate 'create table temp_ps as
select level lev, component_part, bom_type
from product_structure connect by prior component_part = parent_part
and contract = ' ||v_contract||
' and (eff_phase_out_date is null or eff_phase_out_date >=sysdate)
start with parent_part = ' ||v_parent|| ' and contract = '||v_contract||
' and (eff_phase_out_date is null or eff_phase_out_date >=sysdate)';
end;