Problem solve Get help with specific problems with your technologies, process and projects.

Remotely closing a D2K form

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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.