tag:blogger.com,1999:blog-5215551487816981140.post4323061833066357772..comments2024-03-28T22:27:48.595-07:00Comments on ORA-00001: Unique constraint violated: Select * from InboxMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5215551487816981140.post-83630546083702660632013-06-28T02:35:09.073-07:002013-06-28T02:35:09.073-07:00@Steve: The find_items function takes a p_username...@Steve: The find_items function takes a p_username parameter to retrieve data from other inboxes. This assumes the user you are authenticating with has been delegated access to the other user.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-5062799359702306452013-06-11T13:37:09.230-07:002013-06-11T13:37:09.230-07:00Morten,
This is fantastic, thanks for sharing it....Morten,<br /><br />This is fantastic, thanks for sharing it.<br /><br />I have it working successfully for reading my own folders in my mailbox.<br /><br />I also have access to shared inbox, is it possible for me to traverse the folders in that inbox?<br /><br />Could you post the code examples please?<br /><br />Many thanks in advance,<br />SteveAnonymoushttps://www.blogger.com/profile/10122895873546662365noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-85594962575602187602012-05-18T08:54:27.050-07:002012-05-18T08:54:27.050-07:00Love the idea and I am very interested in trying i...Love the idea and I am very interested in trying it. We currently work with Perl. I would second the comment on Attachments, and that is one of our goals - to get the attachments to a repository.Tim St. Hilairehttps://www.blogger.com/profile/03750603427744155067noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-34787156832576036492012-05-06T23:25:56.501-07:002012-05-06T23:25:56.501-07:00Looking forward to this in Alexandria :D
We have ...Looking forward to this in Alexandria :D<br /><br />We have at present a dot.njet program using MAPI to read the inbox of a particular Exchange account, extract the email body as plaintext and put it in a clob, and extract attachments and put them in blobs.<br /><br />It works, but the program has to be restarted like a couple of times a week just because something happens to the MAPI connection.<br /><br />So it would be very very nice for us to have Exchange access within the database without being dependent on a program on some server somewhere in the middle ;-)<br /><br />I'll keep an eye on Alexandria and see when you go public.<br /><br />(Oh, and thanks for the other stuff in Alexandria - definitely some nice things in there :D )Kim Berg Hansenhttps://www.blogger.com/profile/06491635470794828550noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-91862862232294416892012-05-04T11:13:39.751-07:002012-05-04T11:13:39.751-07:00Hello Morten,
I just wanted to add that there are...Hello Morten,<br /><br />I just wanted to add that there are some basics that should included in the package. The good (INSERT,UPDATE,DELETE). In the EWS terms:<br />[Calendar]<br />===========<br />- create item (ie. create appopintment "planned database maintenance")<br />- update item (ie update the date and time of appointment "planned database maintenance"<br />- delete item (ie delete the appointment "planned database maintenance")<br /><br />If you package included this like this that would be awesome.<br /><br />Jan S.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-7588027824908444322012-05-04T09:33:44.404-07:002012-05-04T09:33:44.404-07:00Hello Morten,
Wow ! This is just over the top co...Hello Morten,<br /><br />Wow ! This is just over the top cool. <br />I've spend months just going around searching for some sort of EWS integration. Tried the java in database approach ... lets just say I dropped that idea quickly. <br /><br />And I pretty much just gave up on this ever coming to life.<br /><br />Really awesome, can't wait to put it to the test.<br /><br />Jan S.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-8462045364892489802012-05-03T01:25:58.105-07:002012-05-03T01:25:58.105-07:00@Andre: "At least what Carstens package provi...@Andre: "At least what Carstens package provide should be there - and of cource everything that is possible via the API in addition..."<br /><br />Okay, that narrows it down a bit, right? :-) Actually, I had a look at the documentation to that package, and it seems you should be able to do most things using the EWS API. I'm aiming for the most common operations in the first release.<br /><br />@Steve: That is an odd coincidence! Great minds think alike, eh? :-)<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-82084887158469761482012-05-02T22:40:18.116-07:002012-05-02T22:40:18.116-07:00Morten,
Rather odd brother...
I had the itch to ...Morten,<br /><br />Rather odd brother...<br /><br />I had the itch to do this last week...<br /><br />Scoured the web for anything PL/SQL and found VERY few articles of value.<br /><br />After deciding to go about it on my own and post to my blog, YOU miraculously decided to do the same thing! Where were you like 2 weeks ago??<br /><br />Anywho, i've posted my extremely incomplete, but available source code to my blog. I'm sure yours will be much more complete as you're taking longer to complete yours but I just wanted to get mine out there for folks to find NOW. Mostly so they wouldn't have to go through the same thing I did :).<br /><br />Blog is:<br />http://techblog.steveandyvonne.com/2012/05/exchange-web-services-ews-using-plsql.htmlStevehttps://www.blogger.com/profile/17574083777478383075noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-31335869744464607202012-05-02T13:35:10.081-07:002012-05-02T13:35:10.081-07:00Nice post! Will see how I can test this.Nice post! Will see how I can test this.ronr.blogspot.comhttps://www.blogger.com/profile/09497052323010001266noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-13705534188546308542012-05-02T00:11:45.562-07:002012-05-02T00:11:45.562-07:00Very nice,.. I will follow your Blog for more upda...Very nice,.. I will follow your Blog for more updates on this post.<br />I'd really love to give it a try...<br />Looks very promising, so please keep up the good work!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-32285969765168205142012-05-01T06:07:23.084-07:002012-05-01T06:07:23.084-07:00Hi.
Very neat!
Can't say I've got a requ...Hi.<br /><br />Very neat!<br /><br />Can't say I've got a requirement to use it at the moment, but it's nice to know it exists if I get one in the future.<br /><br />Cheers<br /><br />Tim...Tim Hallhttp://www.oracle-base.comnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-47376997180695293422012-05-01T04:48:15.620-07:002012-05-01T04:48:15.620-07:00Hello Martin,
thank you for introducing this good ...Hello Martin,<br />thank you for introducing this good looking and promising idea.<br />Although I'm using Carstens package (with only little adoptions) for an quite long period of time the WS-way (and yes also the possibillity to avoid java) looks also good.<br />Since you asked for the "specific parts" one would like to see implemented:<br />At least what Carstens package provide should be there - and of cource everything that is possible via the API in addition... <br />As you said there are a wide range of use cases ...<br />Thank you and good luck!<br />AndreAndrenoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-39415282036834579212012-05-01T01:45:24.144-07:002012-05-01T01:45:24.144-07:00Very nice - watching with interest.Very nice - watching with interest.Jeff Kemphttp://jeffkemponoracle.comnoreply@blogger.com