DECLARE
   sql_stmt VARCHAR2(200);
   v_table_name VARCHAR2(20) := '&sv_table_name';
   v_id NUMBER := &sv_id;
   v_first_name VARCHAR2(25);
   v_job VARCHAR2(25);
   v_sal VARCHAR2(50);
   v_deptno VARCHAR2(25);
   v_dname VARCHAR2(2);
   v_lco VARCHAR2(5);
BEGIN
   sql_stmt := 'SELECT a.ename, a.job, a.sal'||
               '      ,b.deptno, b.dname, b.loc'                     
||
               '  FROM '||v_table_name||' a, dname b'            ||
               ' WHERE a.deptno = b.deptno'                              ||
               '   AND '||v_table_name||'_id = :1';
   EXECUTE    IMMEDIATE             sql_stmt
   INTO v_ename, v_job,v_sal , v_deptno, v_dname, v_loc
   USING v_id;

   DBMS_OUTPUT.PUT_LINE ('eName: '||v_ename);
   DBMS_OUTPUT.PUT_LINE ('job:  '||v_job);
   DBMS_OUTPUT.PUT_LINE ('Sal:     '||v_sal);
   DBMS_OUTPUT.PUT_LINE ('deptno:       '||v_deptno);
   DBMS_OUTPUT.PUT_LINE ('dname:      '|| v_dname);
   DBMS_OUTPUT.PUT_LINE ('loc:   '||v_loc);

END;
يعطى رسالة الخطأ 
Encountered the symbol "IMMEDIATE" when expecting one of the following:

   := . ( @ % ;
ORA-06550: line 20, column 4:
PLS-00103: Encountered the symbol "USING" when expecting one of the following:

   . ( , % ;
ومفيش حاجة نسيتها يعنى ; او غيرها

تفضل اخوي

اي خدمة

DECLARE
 sql_stmt	VARCHAR2(200);
 emp_id	  NUMBER(4) := &sv_id;
 v_table_name VARCHAR2(20) := '&sv_table_name';
 v_first_name VARCHAR2(25);
 v_job VARCHAR2(25);
 v_sal number;
 v_deptno number;
 v_dname VARCHAR2(20);
 v_loc varchar2(13);
BEGIN
sql_stmt := 'SELECT a.ename,a.job,a.sal,b.deptno,b.dname,b.loc'
||' FROM '||v_table_name||
' a,dept b WHERE empno = :1 ' ||
' and a.deptno = b.deptno ';
EXECUTE IMMEDIATE sql_stmt INTO 
v_first_name,v_job,v_sal,v_deptno,v_dname,v_loc
USING emp_id;
DBMS_OUTPUT.PUT_LINE ('eName: '||v_first_name);
DBMS_OUTPUT.PUT_LINE ('job: '||v_job);
DBMS_OUTPUT.PUT_LINE ('Sal: '||v_sal);
DBMS_OUTPUT.PUT_LINE ('deptno: '||v_deptno);
DBMS_OUTPUT.PUT_LINE ('dname: '|| v_dname);
DBMS_OUTPUT.PUT_LINE ('loc: '||v_loc);
END;

جزاك الله خير
جارى التجريب

ان شاء الله شغالة 100 بال 100