Re: Collaboration Suite Calendar - where is the data - remote access

nineminus2_at_gmail.com wrote:
> I know SQL pretty well but have never used Oracle. I'm trying to pull
> calendar data from Oracle Collaboration Suite Calendar and have setup
> an ODBC connection to the Oracle Database (I'm developing with
> ColdFusion). I can't seem to find the calendar data however - and have
> no idea what to query to get to it. I've looked at Oracles SOAP
> instructions but I'm not familiar with SOAP at all and my weak attempts
> have proved fruitless. If anyone has any suggestions/thoughts/ideas,
> they would be most appreciated!
>
> I just want to display Oracle calendar info integrated into our
> website.
>
> Dylan
> UCSD School of Medicine

You've a research project on your hands.

SELECT table_name
FROM user_tables;

SELECT table_name
FROM user_tables
WHERE table_name LIKE '%<some_value_in_upper_case>%';

SELECT column_name
FROM user_tab_columns
WHERE table_name LIKE '%<some_value_in_upper_case>%';

Feel free to contact me at the University of Washington if I can help.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org