stored procedures

[ronaldrahme]

oops its not workin, just another kst> how to use execute immediate? its not working for the above statements

[krishnaindia2007]

Here is the example

 
create or replace procedure test_proc as 
string varchar2(100); 

begin 
string := ' alter table test_data add constraint test_data_pk primary key (x)'; 
execute immediate string; 
end; 
/