tracing of client requests - OO4O and Wizards(Archived)

any sugestions about subj ?
(like as OracleMonitor for DOA does)


CAPI_FetchEventsByRange and Day Events

The method CAPI_FetchEventsByRange is failing when requesting day events and appointments. If we just request appointments it is working. Any ideas on why it is behaving this way.
Which version of the sdk are you using? Server version? Do you have a logs? Error message? Sample program?
The CAPI_* calls are deprecated in 10G and replaced by CSDK_* calls so I strongly recommand using the CSDK_* calls instead.
BTW, I can confirm that functionality you are describing is working fine in 10G with function call CSDK_FetchEventsByRange().

Tracing of client's part request's with OO4O

any sugestions about subj ?
(like as OracleMonitor for DOA does)

Looking for the easiest way to implement a .NET based WebService with XE

Hi Forum,
I need to provide a WebService that allows for asynchronous calls based on a XE database. What I'm doing right now is that I use ODP.NET to connect to the database and have IIS host the .NET classes to make them available to the calling clients.
Works comparatively fine but I'd like to know whether anybody is aware of a more elegant solution, e.g. by running the .NET code inside the database and using the databases WebServer to host the service or something alike.
Does anybody have some experience with setting up such a solution?
Thanks for any comment.
Go through the following pages and articles in this regard:
Also, have you looked through the XE-.Net document at
Hi Priya,
thanks for the comments and the links. I'm aware of these resources, but might be because I'm not skilled enough to fully understand the whole picture, it seems to me that I'm not in first place looking for possibilities to import .NET into the database but to use the XE database as an asynchronous WebService Server, allowing for HTTP.based access to the Services.
I can't find a sample which shows me how I could achieve this.
Do you know about any more specific sample I could explore?
To translate your question:
You are looking for the easiest way to implement a .NET based WebService with Apache.
I don't know is it possible, but try to search on net for such information. 
Hi Faust,
well, actually, the WebServer imbedded into Oracle XE is not Apache (at least not a full-blown one), therefore my question is whether somebody has implemented a WebService based on the embedded WebServer as opposed to an Apache OC4J combination.
All samples simply show how existing WebServices are consumed but it doesn't seem to be possible to host a WebService.
Anyway, thanks for the input, I will continue to look for a solution and post it here once I'm succesful.
Best regards,
Works comparatively fine but I'd like to know whether anybody is aware of a more elegant solution,
e.g. by running the .NET code inside the database and using the databases WebServer to host the
service or something alike.I think you'll find that XE has limited ability to run stored procedures in anything other than PL/SQL. I believe IIS with ODP is the most straightforward way to go about it with XE.
Native database web services were -almost- included in Oracle 10g, but were removed.
Re: plsql web services without appserv
Perhaps they will appear in the next version. 
Hi dccase,
well, in the meantime I was able to find a solution that works nicely even with XE.
At least if you accept to implement REST instead of SOAP, going the DBMS_EPG route seems to be a quite intuitive route to implement a responsive PL/SQL procedure over http without the necessity to install and run a second WebServer.
In XE (rumors say that this will be possible with the next patch of 10gR2 as well) you're able to provide the database with a DAD (a database descriptor) which works with the embedded XE WebServer. Using the DBMS_EPG package, you administer the ini-files responsible for the setup of the WebServer, if I got this correctly.
At the end, I was able to call a PL/SQL procedure over http by simply passing the name of the procedure along with a POST of the XML instance to the port XE is listening to, such as:
In regard to asynchronicity, I decided to implement a little class in .NET that throws the request to the database, passing an XML instance as the parameter and receiving an XML response in a thread of it's own, so this is basically what the SOAP implementation does as well.
My first impression, although not mastering this technology fully yet, is that the database seems to respond a lot quicker than to the SOAP service.
Best regards,
Yes, that would work with 10gR2 too.
Just out of curiosity, why are you doing this instead of just calling the stored procedure directly? Is it to avoid installing the Oracle client?
Here is another way to access your data via HTTP: 
Hi dccase
yes, mainly. I'm using this in an environment where hundreds of users need this connection to write database supported letters in Word or other Office products.
Ease of deployment is key and therefore I decided to go that route to avoid to deploy the access credentials, the client installs etc. on all these machines (> 1000).
Another reason is that due to the fact that each user consumes very little resources per request the time to establish the connection is far bigger than the time requested for the query. I have to explore that in more detail, but using the SOAP approach gave me an easy option to pool connections between all these users as opposite to establishing a connection per user using this scenario.
I must admit that I didn't check the performance impact of using shared server connections but from my understanding I would still expect the cost to be higher than to use a shared pool with predefined connections.
The DBUriServlet approach looks promising also. I recall that I read about it earlier, but I've to admit that once you read enough, much gets lost...
Best regards,
Message was edited by: Jürgen
Hi Jürgen,
If you want to use nothing but the embedded XDB HTTP server to act as a host SOAP server, I will say that this really is not practical today.
Hi Priya,
yes, I agree. Using SOAP doesn't seem to be a good idea with the embedded XDB HTTP server.
Luckily, I was able to go the REST route which avoids all the overhead assigned to the SOAP protocol. Im passing my own XML messages around, so there is no real need to utilize SOAP at all.
Well, let's put it this way: As I'm not trying to instrument a full blown SOA application but simply wanted to avoid having to install Oracle clients on all of the 1000 PCs which utilize my application, this solution is fine with me. It seems to perform even better than a combination of IIS WebServer / SOAP communication with ODP.NET pooled connections but I haven't fully tested this yet.
Best regards,
You might find this article interesting:
Hi Doug,
thanks a lot for this link, it's really helpful.
Yes, and it exactly does what I'm doing in the meantime. One challenge has been though to make access to this service asynchronously. This on the other hand is a .NET issue in my case and I solved this as well by calling the proc within a thread on it's own and linking the thread to the rest of the code using an event.
So what I finally have is a simple, yet efficient, WebService implementation in REST that works asynchronously. What else could I ask for? :)
Thanks again for all the valuable input you guys were giving me on that.

PLSQL -> Oracle 9iAS Wireless Messaging service

Opinions on the best way to access Oracle 9iAS Wireless Messaging server.
I am currently using Soap (inside Oracle RDBMS JVM) to connect to the server, but have concerns about performance.
Obviously I could use RPC, XML-RPC, etc, but I thought there might already be somebody trying to do this, with some experience of the best way.
I would also like some way to register a reply listener, and call into the RDBMS whenever a reply arrives. I imagine I could do this part quite easily with a JDBC connection.
Thanks in advance
If I was not clear in the first post...
I need to be able to access Oracle 9iAS Wireless from within a Oracle 9i database, via PLSQL.
I have NO problem using JVM with PLSQL wrapper however.
Have you got any solution for this. If so can you post it.
Do you have a local 9iAS Wireless instance, or are you just trying to connect directly from a database instance to the hosted messaging web service (
If you are trying the latter, we currently expose only a standard SOAP interface. Perhaps the Web Services forums can better help you with ideas for calling SOAP from the DB.

Notification Oracle 9i -> Java

Hi Community!
I checked the forum already for a matching, but didnt find any answer for my problem.
I want to get a notification in a Java Class if an entry in my db table was changed (trigger).
I read alot about Java Stored Procedures and Packages but i cant find a hint how they (db-java) would communicate and where to begin.
Could anyone help me out?
Thanks alot in advance!
Please, clarify your needs.
Do you mean your class is in separate Java app acting as Oracle client? Or it is running (as Java Stored Procedure) within Oracle JVM? If last, I'm sure Java Stored Procedure is not intended to be notified of something. It is just called on demand (e.g. from trigger). If first, you can call Java stored procedure from trigger, and use RMI or JMS to notify someone. 
The Java App is an Oracle Client which needs the notification.
I will check if JMS will serve the needs and will write down my experiences ;)
Thanx for the tip!