مساعدة في EXECUTE IMMEDIATE

[nesmaaa]

السلام عليكم
ممكن مساعة فى استخدام
EXECUTE IMMEDIATE لانشاء مستخدم جديد على الdata base
انا عملت كود بس بيظهر عندى مشكلة

DECLARE

BEGIN

EXECUTE IMMEDIATE 'CREATE USER :EMP_TB.EMP_APP_USERNAME

IDENTIFIED BY :EMP_TB.EMP_APP_PASSWORD';

end ;

ششو بيكون الخطأ ؟

[egyhamada]

اعتقد ده ممكن يحل المشكلة

declare
cursor_name   	INTEGER;
ret           	INTEGER;
STR           	VARCHAR2(4000);
begin

cursor_name:=dbms_sql.open_cursor;
STR:='CREATE USER '||:EMP_TB.EMP_APP_USERNAME ||' IDENTIFIED BY '|| :EMP_TB.EMP_APP_PASSWORD  ;
 dbms_sql.parse(cursor_name,STR,DBMS_SQL.NATIVE);
 ret:=dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);

end;

[mozak]

you can use forms_ddl
i think it can help

just search about it

[HELL-BOY]

DECLARE
BEGIN

EXECUTE IMMEDIATE 'CREATE USER :EMP_TB.EMP_APP_USERNAME

IDENTIFIED BY :EMP_TB.EMP_APP_PASSWORD';

end

جرب الكود دا وقولي

declare 
user varchar2(50);
password varchar2(50);
sql_s varchar2(500);
begin
user:=&user;
password :=&pas;
sql_s:='create user :user identified by :password'
execute immediate sql_s using user,password
end;