mo_sa_tanany بتاريخ: 22 مايو 2005 تقديم بلاغ مشاركة بتاريخ: 22 مايو 2005 hiii all can any one help me i want to call exe from the database trigger or a procedurethanks اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
the_oracle_dev بتاريخ: 22 مايو 2005 تقديم بلاغ مشاركة بتاريخ: 22 مايو 2005 HOST built-in DescriptionExecutes an indicated operating system command. Syntax PROCEDURE HOST (system_command_string VARCHAR2); PROCEDURE HOST (system_command_string VARCHAR2, screen_action NUMBER); Built-in Type unrestricted procedure Enter Query Mode yes Parameterssystem_command_ stringSpecifies the system command you want to pass to your particular operating system. screen_actionSpecifies one of the following constants: No parameter: Specifies that Form Builder will: *- clear the screen *- prompt the operator to return from the command NO_PROMPT: Specifies that Form Builder will: *- clear the screen (does not prompt the operator to return from the command) NO_SCREEN Specifies that Form Builder will: *- not clear the screen *- not prompt the operator to return from the system command The HOST command should not send output to the screen when using the NO_SCREEN parameter.Usage notes Thescreen_action parameter is only relevant to applications running in character mode, where the output of the Host command is displayed in the same window as the form. In GUI applications, the output of the Host command is displayed in a separate window. On Microsoft Windows NT, when using HOST to execute a 16-bit application, the FORM_SUCCESS built-in will return TRUE whether the application succeeds or fails. This is a Microsoft a Win32 issue. 32-bit applications and OS commands will correctly return TRUE if executed sucessfully and FALSE if failed. Invalid commands will return FALSE.On Windows 95 platforms the FORM_SUCCESS built-in will always return TRUE for HOST commands which fail. This includes calls to command.com or OS functions, any 16-bit DOS or GUI application, or an invalid command. 32-bit applications will correctly return TRUE if executed sucessfully and FALSE if failed.Examples /* ** built-in: HOST ** Example: Execute an operating system command in a ** subprocess or subshell. Uses the ** 'Get_Connect_Info' procedure from the ** GET_APPLICATION_PROPERTY example. */ PROCEDURE Mail_Warning( send_to VARCHAR2) IS the_username VARCHAR2(40); the_password VARCHAR2(40); the_connect VARCHAR2(40); the_command VARCHAR2(2000); BEGIN /* ** Get Username, Password, Connect information */ Get_Connect_Info(the_username,the_password,the_connect); /* ** Concatenate together the static text and values of ** local variables to prepare the operating system command ** string. */ the_command := 'orasend '|| ' to='||send_to|| ' std_warn.txt '|| ' subject="## LATE PAYMENT ##"'|| ' user='||the_username|| ' password='||the_password|| ' connect='||the_connect; Message('Sending Message...', NO_ACKNOWLEDGE); Synchronize; /* ** Execute the command string as an O/S command The ** NO_SCREEN option tells forms not to clear the screen ** while we do our work at the O/S level "silently". */ Host( the_command, NO_SCREEN ); /* ** Check whether the command succeeded or not */ IF NOT Form_Success THEN Message('Error -- Message not sent.'); ELSE Message('Message Sent.'); END IF; END; -*-*-*-*-*-*-*إني احبكم في الله اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
mo_sa_tanany بتاريخ: 23 أبريل 2007 كاتب الموضوع تقديم بلاغ مشاركة بتاريخ: 23 أبريل 2007 many thanks 4 your answer but my question was how can i call exe fromDATABASE triggerorDatabase procnot from the forms thanks اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
Recommended Posts
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.