• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details
Status
Not open for further replies.

DukeNukem

Come get Some
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;
 
Last edited:
Status
Not open for further replies.
Top Bottom