I want to close a D2K (Oracle back end) form running on another terminal from my terminal. Can you provide me the sufficient code for this purpose?
I can't provide you with exact code, but I can provide you with information on the mechanism you'd need to code in order to do what you desire.
The first thing to know is that in order to be able to have one session communicate with another session, you must create some mechanism by which the sessions can know about the other and can pass messages back and forth. This can be done in several different ways, but using Advanced Queuing or Alerts/Pipes are two options that come first to my mind. Using either method (Advanced Queuing is implemented through the DBMS_AQ package and Alerts/Pipes are implemented through the DBMS_ALERT and DBMS_PIPE packages) you can have one session send a message that another session can receive and then can act accordingly based on the received message. This requires that your application be designed with this functionality in mind and it'll take some research to determine how to best implement it in your application environment.
I suggest that you read the Oracle9i Supplied PL/SQL Packages and Types Reference (http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96612/toc.htm) under DBMS_AQ, DBMS_ALERT and DBMS_PIPE for more info. Another reference on Advanced Queuing is the Oracle9i Application Developer's Guide - Advanced Queuing (http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96587/toc.htm). Tom Kyte's book "Expert One-on-One Oracle" also has some brief but informative information on these packages as well.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle hosting, outsourcing and remote DBAs
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.