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
first of all I didn't ask any one to do my work for free ,I ask particular question can I use host command in database or not .
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.