PL/SQL cursor : add constraint

hi,

i would like to add constraint like Primary key in q create query for the moment i can create my table like this

Myquery :='create table MyTable (F1 varchar2(50), F2 number)

cursor_create := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_create,Myquery,dbms_sql.native);
row_processed := DBMS_SQL.EXECUTE (cursor_create);

it works but when my query is
Myquery :='create table MyTable (F1 varchar2(50) primary key, F2 number) or
Myquery :='create table MyTable (F1 varchar2(50) constraint u_id primary key, F2 number)
it doesn't work
thank you for your help
regards

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 06:21:31 CST