Forum Moderators: coopster & phranque

Message Too Old, No Replies

Parse Oracle Calendar

         

rus3439

6:00 pm on Apr 10, 2006 (gmt 0)

10+ Year Member



I am trying to learn how to retreive a particular string from oracle calendar. Not sure if thats possible at all.

I want to do the following:

1. Log in to Oracle calendar
2. Select a person whose schedule I want to see.
3. Search through the next week meetings for a particular meeting name and then execute certain code if the meeting is found.

Thanks,
jake

adwatson

3:30 pm on Apr 11, 2006 (gmt 0)

10+ Year Member



Don't know anything about Oracle calendar, but I assume it's database driven. Couldn't you connect to the database and come up with a query that pulls all events for this person in the date range and that match the meeting's name?

rus3439

5:23 pm on Apr 12, 2006 (gmt 0)

10+ Year Member



Do you have any code examples on how to do that? I have never done this, and quite new to perl.

Thanks in advance,
jake

adwatson

5:02 am on Apr 15, 2006 (gmt 0)

10+ Year Member



I can't really give you specific code that would work - but generally you'll want to use the perl DBI module to setup a connection to the Oracle server. You'll most likely need a username and password to use in the script to connect... Then you'll need to figure out the structure of the database and figure out what SQL query you'll need to use to get the records you need... Hope that helps...