EJB programming & troubleshooting: Use of oracle DBMS_PIPE in EJB
I want to talk to two different session of oracle in same application . Oracle has the package DBMS_PIPE which allows this. How do i incorporate the same in the EJB. Please Help.
- Posted by: Ravinder Chawla
- Posted on: August 18 2001 01:19 EDT
When you say "talk to two ..." do you mean you want to do cross-database joins?
If so, you'll have to set up dblinks and then write your SQLs accordingly (with the dblink in the SQL). Of course, you'll have to use BMP, AFAIK.