Re: HELP: Creating constraints in code
From: Blv n Drms <blvndrms_at_aol.com>
Date: 1995/05/03
Message-ID: <3o97tj$sau_at_newsbf02.news.aol.com>#1/1
/
Jack Richter Received on Wed May 03 1995 - 00:00:00 CEST
Date: 1995/05/03
Message-ID: <3o97tj$sau_at_newsbf02.news.aol.com>#1/1
Create or replace procedure testing (tablenm varchar2) as cursor_id number;
begin
cursor_id=dbms_sql.open_cursor;
dbms_sql.parse(cursor_id, 'ALTER TABLE '||table_nm||'ADD
CONSTRAINT .........',dbms_sql.v7);
dbms_sql.close_cursor(cursor_id);
exception
when OTHERS then
dbms_sql.close_cursor(cursor_id);
end;
/
Jack Richter Received on Wed May 03 1995 - 00:00:00 CEST