This content has been marked as final. Show 8 replies
Did you verify PL/SQL actually supports DDE? It doesn't!!!
You need to use the UTL_HTTP package for your requirement.
I don't know why you want to open a web browser at 8:00.
It doesn't make much sense as the web browser will open on the database server.
What business need are you trying to resolve?
Senior Oracle DBA
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
PL/SQL is server code. It is executed in a database server process. Why would a server process open DDE communication to a client process?
As Sybrand said - this DDE package you refer to, does not exist in PL/SQL as a DBMS or Utility package supplied by Oracle. PL/SQL support integration with Windows via the ExtProc and COM interfaces.
Forms, based on PL/SQL, is client code. And typically, what you are attempting to do, using PL/SQL look-a-like code, is actually Forms. Not PL/SQL code.
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.
Senior Oracle DBA
Your 'solution' is not going to work.
Sooner or later sessions will hang because there is some problem startint explorer using the host command.
More importantly: you don't NEED explorer!
And YES: you asked for code, so you did ask someone else to do your work for free. P
Senior Oracle DBA
younis yassin wrote:No and yes.
I ask particular question can I use host command in database or not .
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.