V_msg :='hi you receive this message from eta company';
1 - I have to use web browser because this code already I receive it from mobile company it has apackage to support oracle form 10g
to send sms through 10g form but i need to execute this scrip through database autimatic
2 - u mean I have to execute http package script first and then i can use
ap := DDE.App_Begin('C:\Program Files\Internet Explorer\iexplore.exe '||V_link,DDE.APP_MODE_NORMAL);
note : if you have any solution to send sms through oracle database 10g please help me
so if i want to execute this line in database ,sybrand u said i should use utl_http
please i need to explain which statement i should use to execute this line ,
and i have question for host command host(('C:\Program Files\Internet Explorer\iexplore.exe '||V_link,DDE.APP_MODE_NORMAL);
i can use it or not
So this means that you can not be bothered to refrain from IM-speak and treat two seniors as a couple of 4-years old, and you are asking us to do your work for free?
I'm not a free Googling service, I willl not Google for you for 'utl_http' or 'send sms pl/sql', which is a much better solution than this appalling inefficient approach.
This is a discussion forum of volunteers. You can not expect anyone to do your work for free.
younis yassin wrote:
I ask particular question can I use host command in database or not .
No and yes.
No. The host command is a client (sqlplus) command. It is not part of the server-side PL/SQL language.
Yes, PL/SQL provides interfaces to the server for executing server executables:
- external jobs via DBMS_SCHEDULER
- Java stored procedures allowing access to external commands via the Runtime class
- EXTPROC interface for external procedures (typically access to DLLs)
Keep in mind that launching IE from a Windows service, is HIGHLY questionable. Oracle run as a Windows service. A service does NOT have native and direct desktop (GDI) access. See GDI+. Microsoft states in this article:
GDI+ functions and classes are not supported for use within a Windows service. Attempting to use these functions and classes from a Windows service may produce unexpected problems, such as diminished service performance and run-time exceptions or errors.
So perhaps you need to explain WHAT the actual problem is, instead of how to make the hack you have in mind, work.