FORMS_DDL

2002-08-15 Thread Moses Ngati Moya
What's the equivalent of FORMS_DDL in PL/SQL? I have tried to use DBMS_SQL.EXECUTE(proc) to execute DDL commands in vain. All I want is to Create USers from an application. In forms I would use DECLARE name varchar2(20) := 'Moses'; pword varchar2(20) := 'nevermind' state varchar2(200

Re: FORMS_DDL

2002-08-15 Thread Connor McDonald
begin execute immediate 'create user ...'; end; (8i+) hth connor --- Moses Ngati Moya [EMAIL PROTECTED] wrote: What's the equivalent of FORMS_DDL in PL/SQL? I have tried to use DBMS_SQL.EXECUTE(proc) to execute DDL commands in vain. All I want is to Create USers from an application