السلام عليكم ورحمة الله وبركاته

 

مرفق ملفات توضح تنصيب أوراكل  12c_12.2.0.1.0  و  10g_10.2.0.3.0

 

على  Windows 10

 

الرابط

https://drive.google.com/file/d/1Nbw3u_o2XajsQnI7wj9ZfjjybxWZLK_S/view?usp=sharing

 

جزاكم الله خيرا كثيرا

 

جزاك الله خير 

السلام عليكم ورحمة الله وبركاته

 

لقد تم تعديل الكود الموجود في شاشة سحب الدتا من ملف الإكسل

والموجود في صفحة ملاحظات_تشغيل برنامج تدقيق الحسابات

كما يلي

DECLARE
CONVID    PLS_INTEGER;
APPID     PLS_INTEGER;
i         integer;
x         integer;
seq       integer;
t_year    varchar2(8);
t_num     varchar2(25);
ac_nam    varchar2(100);
t_op_vd   varchar2(25);
t_op_vc   varchar2(25);
t_t_vd    varchar2(25);
t_t_vc    varchar2(25);
BEGIN
Appid := dde.app_begin('C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE'||' '||getpath||'TR_BAL_FILES'||'\'||:TITLE.NUMC||'.xlsx',dde.app_mode_minimized);
dde.app_focus(appid);
convid := dde.initiate('EXCEL.EXE',getpath||'TR_BAL_FILES'||'\'||:TITLE.NUMC||'.xlsx');
x := 0;
FOR I IN 2..100000 loop
dde.request(convid,'R' || to_char(i) ||'C1',t_year,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C2',t_num,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C3',ac_nam,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C4',t_op_vd,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C5',t_op_vc,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C6',t_t_vd,dde.cf_text,100000);
dde.request(convid,'R' || to_char(i) ||'C7',t_t_vc,dde.cf_text,100000);
if to_number(substr(t_year,1,length(t_year)-2)) is null then exit;
end if;
:dat := sysdate ;
:t_year := to_number(substr(t_year,1,length(t_year)-2));
:ac_num := to_number(substr(t_num,1,length(t_num)-2));
:ac_nam := substr(ac_nam,1,length(ac_nam)-2);
:t_op_vd := to_number(substr(t_op_vd,1,length(t_op_vd)-2));
:t_op_vc := to_number(substr(t_op_vc,1,length(t_op_vc)-2));
:t_t_vd := to_number(substr(t_t_vd,1,length(t_t_vd)-2));
:t_t_vc := to_number(substr(t_t_vc,1,length(t_t_vc)-2));
x:= x + 1;
NEXT_RECORD;    
end loop;
dde.terminate(convid);
dde.app_end(appid);
EXCEPTION 
WHEN DDE.DDE_APP_FAILURE THEN
MESSAGE('An application program specified in a DDE.APP_BEGIN call could not be started'); 
WHEN DDE.DDE_APP_NOT_FOUND THEN
MESSAGE('An application ID specified in a DDE.APP_END or DDE.APP_FOCUS call does not correspond to an application that is currently running'); 
WHEN DDE.DDE_FMT_NOT_REG THEN
MESSAGE('A format string specified in a DDE.GETFORMATNUM call does not correspond to a predefined format and could not be registered as a user-defined format'); 
WHEN DDE.DDE_INIT_FAILED THEN
MESSAGE('The application was unable to initialize DDE communications, which caused a call to the DDE layer to fail'); 
WHEN DDE.DDE_PARAM_ERR THEN
MESSAGE('An invalid parameter, such as a NULL value, is passed to a DDE package routine'); 
WHEN DDE.DMLERR_BUSY THEN
MESSAGE('A transaction failed because the server application is busy'); 
WHEN DDE.DMLERR_DATAACKTIMEOUT THEN
MESSAGE('A request for a synchronous data transaction has timed out'); 
WHEN DDE.DMLERR_EXECACKTIMEOUT THEN
MESSAGE('A request for a synchronous execute transaction has timed out'); 
WHEN DDE.DMLERR_INVALIDPARAMETER THEN
MESSAGE('The application used an invalid conversation identifier.More than one instance of the application used the same object'); 
WHEN DDE.DMLERR_MEMORY_ERROR THEN
MESSAGE('A memory allocation failed'); 
WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
MESSAGE('A clients attempt to establish a conversation has failed. The service or topic name in a DDE.INITIATE call may be in error'); 
WHEN DDE.DMLERR_NOTPROCESSED THEN
MESSAGE('A transaction failed. The item name in a Poke or Request transaction may be in error'); 
WHEN DDE.DMLERR_POKEACKTIMEOUT THEN
MESSAGE('A request for a synchronous poke transaction has timed out'); 
WHEN DDE.DMLERR_POSTMSG_FAILED THEN
MESSAGE('An internal call to the Post Message function has failed'); 
WHEN DDE.DMLERR_SERVER_DIED THEN
MESSAGE('The server terminated before completing a transaction'); 
WHEN DDE.DMLERR_SYS_ERROR THEN
MESSAGE('An internal error has occurred in the DDE layer'); 
END;

حيث أصبح يظهر الخطأ التالي

WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
MESSAGE('A clients attempt to establish a conversation has failed. The service or topic name in a DDE.INITIATE call may be in error'); 

ما هو حل هذا الخطاء ؟؟؟

 

جزاكم الله خيرا كثيرا

 

مساء الخير 

انا فاتحت hr لكي للتدريب ولكن كل ما اغلق الجهاز وافتح تاني الباسورد لا يدخل بتاع hr  العمل ايه بعد ذنك

السلام عليكم ورحمة الله وبركاته

أخي الكريم

قم بإلغاء الصح الموجود على  Password Expired

كما في الملف المرفق

أو

من خلال شاشة الـ  SQL  باليوزر  SYS or system

ALTER USER olduser PASSWORD EXPIRE;

 

ALTER USER olduser ACCOUNT UNLOCK;

 

بالتوفيق إن شاء الله

3_Database_12.docx