hi
I need to create stored proc in oracle sql developer , where I have multiple cte which inserts data into tables.
create or replace procedure p_new
as
begin
insert into table1
(with cte
(
select * from tableb
)
select a.name from tableb a)
end;
/
this gives me error :table or view does not exist and sql stm ignored.
any help