Call Pro*C program from within the Oracle 10g WAS

Posted on 2008-02-06
Medium Priority
Last Modified: 2013-12-18
Anyone who has any idea how to initiate Pro*C program from within Oracle 10g WAS..

Our Oracle10g Application Server is run on the window server 2003 and Pro*C are running on the Solaris Sever..

I have no idea how to do...please advise

Question by:LeanMoreTryMore
  • 2
  • 2
LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 20887322
you can create daemon process on solaris that listens to a port that your application can send info to and that will kick off the pro*c for you.

Instead of a unix port, you could have the process connect to your database and listen on a dbms_pipe.

Your pro*c could be both of those applications,  either a port or pipe listener, but it would be singly threaded then which may or may not be ok depending on your situation.

You could also write your pro*c as a library instead of a stand alone executable and then expose it through pl/sql in your database that your app could call.

I would lean toward the latter

Author Comment

ID: 20888165
I thought I should use JMS. Obviously this is wrong, isn't it?

Using dbms_pipe would be a better idea
LVL 74

Expert Comment

ID: 20888265
I think JMS would be more involved.  dbms_pipe should work quite easily.

Author Comment

ID: 20888992
Thanks for his quick solution

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question