Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Mike

Pages: 1 ... 119 120 [121] 122 123 124
PSOUG / Re: Web Service Application
« on: May 13, 2009, 08:17:34 AM »
So you wouldn't do it from inside Oracle within a PL/SQL-Package working as a daemon (would run once a day for two hours - I hope)?.
I personally wouldn't do it that way, but you could do it that way if you really wanted to. It's not the ideal way to do this kind of thing, however.

I suppose because of missing Oracle functions handling internet content?
But it would work with HTP, URI...packages?
The reason I wouldn't do it that way is because it's inefficient and it's the wrong tool for the job, in my opinion. Oracle is a database; let the database do what it's good at and use other tools or languages to do all the other stuff. Let the database do the heavy lifting where it excels, and don't waste its time or resources doing stuff it's not suited for. Oracle is a great database, but it's not the best tool to do text processing, remote content retrieval, or inline data reformatting. That's where I'd use something like PHP.

On the other side, with PHP + AppServer I would have another two instances to be maintained. And a problem, I don't speak PHP yet.
In general, PHP doesn't require any ongoing maintenance once it''s installed. It just runs.

A number of people here are fairly proficient in PHP, so feel free to ask for help if you need it. We may also be able to come up with some sample code for you if you can give us an idea of what you want to do.

PSOUG / Re: Web Service Application
« on: May 13, 2009, 05:51:43 AM »
It depends on several factors, such as how often you want to check the site contents for changes. You could easily use PHP and a cron job to retrieve and check the contents every 5 minutes (for example), and then process the retrieved data into the format you need.

PHP has plenty of functions that allow it to talk to an Oracle database directly.

Also, mySQL is typically the database that's used for web services, but if your ISP will install Oracle then you could certainly use it.


I have problem getting the missing information.

Intention: I want to set up a small web service/website using an Oracle database for storing the input information collected by checking other web sites HTML code and using this stored information newly structured as a kind of output information.

What I don't know: can I use PL/SQL programm daemon to check the websites? Is it useful to use PL/SQL or should use another language i. e. java-script, PHP...? Is there any code sample which I could use as basis?


BI Consulting Group Announces Support for Oracle Business Intelligence Applications Release 7.9.6

With the new release of Oracle BI Applications, BI Consulting Group extends its BI solution offering to include Project Analytics and Loyalty Analytics

Minneapolis, MN, May 07, 2009 -- BI Consulting Group today announced that it will be offering expanded professional services expertise based on the newly introduced Oracle Business Intelligence (BI) Applications Release 7.9.6. The new capabilities in Oracle BI Applications Release 7.9.6 surrounding Project Analytics and Loyalty Analytics will provide BI Consulting Group an opportunity to help organizations to manage and execute with greater business insights and agility.

In addition, BI Consulting Group continues to provide services around the enhanced Oracle Human Resource Analytics and Oracle Procurement and Spend Analytics in this latest release of Oracle BI Applications. Oracle Human Resources Analytics introduces new monitoring and reporting capabilities for Recruitment Learning Management and Leave and Absence Analytics to help organizations further improve overall workforce performance and managerial effectiveness. Oracle Procurement and Spend Analytics features enhancements to help purchasing and procurement organizations glean greater insight into spend, supplier performance, and expenses.

"BICG has developed tried and true best practices for implementing all of Oracle BI Applications. These best practices are part of our standard project protocol and have also been incorporated into our BICG University training courses. Our customers are leveraging this knowledge of the Oracle BI Applications to extend intelligence quickly and efficiently throughout their enterprise," said Mike Jelen, Vice President of BICG University, the education arm of BI Consulting Group.

"Oracle Project Analytics is certainly drawing the most excitement of the new and enhanced applications as most organizations in some way shape or form manage projects," said Amy Mayer, President of BI Consulting Group. "The content available in the new Project Analytics is extremely comprehensive allowing you to analyze project costs compared to budgets, project revenues, billings and collections allowing you to drastically reduce the risk and manage projects much more effectively. I see strong interest for this application amongst both Oracle and non-Oracle customers as the content, data models and ETLs can be leveraged no matter the back-end system," continued Mayer.

Oracle BI Applications are complete, pre-built BI solutions that deliver intuitive, role-based intelligence for everyone in an organization – from front-line employees to senior management – that enable better decisions, actions, and business processes. Based on best practices, these solutions enable organizations to gain greater insight and value from a range of data sources and applications including the Oracle E-Business Suite, Oracle’s PeopleSoft Enterprise, Oracle’s Siebel CRM, Oracle’s JD Edwards EnterpriseOne, and third party systems such as SAP.

About Oracle PartnerNetwork
Oracle PartnerNetwork is a global business network of more than 20,000 companies who deliver innovative software solutions based on Oracle software. Through access to Oracle’s premier products, education, technical services, marketing and sales support, the Oracle PartnerNetwork program provides partners with the resources they need to be successful in today’s global economy. Oracle partners are able to offer their customers leading-edge solutions backed by Oracle’s position as the world’s largest enterprise software company. Partners who are able to demonstrate superior product knowledge, technical expertise, and a commitment to doing business with Oracle qualify for the Certified Partner levels.

About BI Consulting Group
BI Consulting Group is a Oracle consulting partner focused exclusively on Oracle Business Intelligence. Service offerings include consulting services, education services, support services as well as product services. BICG's sole focus is Oracle Business Intelligence. BICG’s experience with Oracle Business Intelligence is rooted in the origins of the software suite. Their consultants began using the business intelligence suite of products offered by Minnesota-based nQuire Software in late 1999. Siebel acquired nQuire in 2001, and Oracle acquired Siebel in 2006. The experts at BI Consulting Group have collectively completed over 280 successful implementations of Oracle BI. Along the way, BICG has been honored with Oracle's Most Valuable Partner Award for Business Intelligence and the Oracle Excellence Award for creatively using Oracle Fusion Middleware with Oracle Applications (E-Business Suite, PeopleSoft, Siebel, JD Edwards etc) to create innovative and standards-based technology solutions.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

Jeremiah Johnson
BI Consulting Group
Minneapolis, MN

PSOUG / Welcome to the NWOUG Fall Conference!
« on: May 07, 2009, 06:11:52 AM »
Welcome to the NWOUG Fall Conference!

September 15th, 2009

Doubletree Hotel & Executive Meeting Center Portland - Lloyd Center

Lloyd Center Double Tree Hotel

1000 NE Multnomah Street, Portland, Oregon 97232

Mark Sunday, Oracle CIO, will be the Keynote Speaker

This exciting conference will bring the best of Oracle innovation and leadership to the Pacific Northwest!

Do you want to be at the forefront and be recognized as a leader in your field of expertise?

You can become a leader by being a supporter of the event through your presentation or participation in the vendor fair. Consider sponsoring lunch, breakfast or one of the breaks; this is a great way to raise your corporate visibility. Would you like a private “breakout room” to meet with your clients and prospects during the day without having to leave the premises? Let us know what you need so we can make necessary arrangements.

Members want to know what you have to say, and are eager to learn! Be a presenter in one of our Technical, Applications or Vendor tracks.

Presenters who wish to be considered for the Fall Conference must submit a 50 - 75 word abstract of their presentation to The time line and steps for presentation submittal, selection and preparation is as follows:

    *  presentation abstract submission opens NOW!
    *  presentation abstract submission closes: June 15, 2009
    *  presentation abstract selection results communicated: June 26, 2009
    *  full presentation due for conference package preparation: August 31, 2009
    *  presentation at the conference: September 15, 2009

This year, Vendor displays will be at the heart of the event, centrally located in the conference area; in the middle of traffic and the primary focal point of activities. You will have an excellent opportunity to interface with all the attendees. Visit the Vendor’s Corner of our website ( to download exhibit applications and regulations.

Additional information regarding the Fall Conference will soon become available on the NWOUG web site (

Do you want more information or have questions? Contact us at

PSOUG / Sample Classes Now Available In the Online Learning Center
« on: April 23, 2009, 10:14:59 AM »
The full version of the Online Learning Center (OLC)will be available shortly. In the meantime, please feel free to watch these excerpts of classes from Dan Morgan, Dr Steven Lewis, and Joe Celko.

FlashBack Database (Dan Morgan
Instructional video on using FlashBack to return the database to a point in the past using either the SCN (system change number) or a specified time.

FlashBack Drop (Dan Morgan
Instructional video on using FlashBack to recover a dropped table.

FlashBack Query (Dan Morgan)
Instructional video on using FlashBack to run queries against the database at any specific time in the past.

Date Functions Demystified (Dan Morgan)
Instructional video on working with some of the various date functions in Oracle 10g and 11g.

Thinking In Sets (Joe Celko)
The fantastic "Thinking In Sets" lecture by Joe Celko.

Three Programming Tricks (Joe Celko)
Joe Celko's "Three Programming Tricks" lecture.

Intro to Java I (Dr. Steven Lewis)
Instructional video by Dr. Steven Lewis, Java Basics, Part 1.

Intro to Java II (Dr. Steven Lewis)
Instructional video by Dr. Steven Lewis, Java Basics, Part 2.

PSOUG / Re: adding .dbf files to the existing database?
« on: April 20, 2009, 07:31:48 AM »
A couple of suggestions:

Try DBF-to-Oracle, a program to migrate DBase/FoxPro/Clipper (*.dbf) databases to Oracle server.
Available at:

Try using the Oracle Migration Workbench:

"Ask Tom" also has some tips on how to do this:

PSOUG / Re: Need a query
« on: April 20, 2009, 07:22:29 AM »
This is an example of syntax for the GROUP BY clause:

    SELECT column1, column2, ... column_n, aggregate_function (expression)
    FROM tables
    WHERE predicates
    GROUP BY column1, column2, ... column_n;

aggregate_function can be a function such as SUM, COUNT, MIN, or MAX.

Here's an example that uses the COUNT function:

SELECT department, COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 25000
GROUP BY department;

Here's an example that uses the MIN function:

SELECT department, MIN(salary) as "Lowest salary"
FROM employees
GROUP BY department;

PSOUG / Oracle Buys Sun
« on: April 20, 2009, 06:59:00 AM »
Oracle Buys Sun

Oracle Corporation (NASDAQ: ORCL) and Sun Microsystems (NASDAQ: JAVA) announced today they have entered into a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.

'We expect this acquisition to be accretive to Oracle's earnings by at least 15 cents on a non-GAAP basis in the first full year after closing. We estimate that the acquired business will contribute over $1.5 billion to Oracle's non-GAAP operating profit in the first year, increasing to over $2 billion in the second year. This would make the Sun acquisition more profitable in per share contribution in the first year than we had planned for the acquisitions of BEA, PeopleSoft and Siebel combined,' said Oracle President Safra Catz.

Register online now for this complimentary event featuring successful grid techniques for the next-generation data center. Or call 1.800.820.5592 ext. 6257.

Master Change: Consolidate, Virtualize, and Standardize Your Data Center

Learn proven grid computing best practices for reaching new levels of efficiency and agility

Join us for a free half-day seminar, Grid Computing: The Next-Generation Data Center. You'll learn best practices for transforming your central IT operations into a high-performance next-generation data center.

Today's data centers must be ready for rapid and unpredictable changes driven by dynamic business demands, market and regulatory pressures, and operational imperatives for green computing and lower costs. At this Grid Computing seminar, we will show you how grid computing pools and provisions groups of networked computers on demand to meet the changing needs of your business. And you will see how multiple applications can share the same computing infrastructure for greater efficiency, agility, availability, and scalability than dedicated servers and storage can provide.

Wednesday, April 29, 2009
8:30 a.m. – 1:15 p.m.

Governor Hotel - Jakes Catering
614 SW 11th Ave
Portland, OR 97205
Map & Directions

Oracle experts and customer success stories will illustrate how you can:

    * Improve efficiency with server clustering, load balancing, and application grid technologies
    * Drive IT agility with on-demand provisioning, automation, and real-time predictive monitoring
    * Boost availability with disaster protection, failover strategies, and quality-of-service management
    * Green your operations with server consolidation, virtualization, and energy-saving best practices

Come meet with your peers and Oracle technology professionals to discuss how grid techniques can transform your business, budget, and timetable. See how grid best practices are helping thousands of customers modernize their operations to create the next-generation data center.

Register online now for this complimentary event. Or call 1.800.820.5592 ext. 6257.


8:30 a.m.    Breakfast and Registration
9:00 a.m.    Oracle Keynote: Grid Techniques for the Next-Generation Data Center
10:00 a.m.    Break
10:15 a.m.    Breakout Session 1: Achieving Agile IT Operations
11:15 a.m.    Breakout Session 2: Ensuring Continuous Availability
12:15 p.m.    Lunch and Demo
1:15 p.m.    Wrap Up and Raffle

Thank you very much. I finally got the procedure to be executed without errors.  However I have a different problem which I will describe after I explain what I am trying to do.
Maybe someone else can chime in on this and give you some ideas; I'm not sure exactly how this might be done.

Code: [Select]
CREATE or REPLACE procedure INPUT_RECORDS(p_ename in varchar2,
p_deptID in number, p_dname in varchar) as
INSERT into emp(ename, deptID)
dept where dname = p_dname);

SQL statement ignored after line 4
ORA 00947 : not enough values

Hmmm, my guess is that although you're telling it to insert both the ename and deptID, you're only supplying the deptID as a value.

PSOUG / Conficker Update: Creating Spam-Spewing Drones?
« on: April 10, 2009, 10:15:45 AM »
By Stefanie Hoffman, ChannelWeb
8:16 PM EDT Thu. Apr. 09, 2009

More than a week after its April 1 deadline, the Conficker C worm released an update that could activate the botnet to deliver spam and turn infected PCs into zombies.

Researchers say that the latest update could include a connection between the Conficker worm to the active spam bot W32.Waledac. Specifically, researchers said they have seen circumstantial evidence that the latest strain of Conficker, known as Downadup E, might drop a Waledac binary on machines infected with Conficker C. That binary is designed to steal information and turn infected PCs into spam-spewing drones under the control of the malware authors, experts say.

Full Article:

Conficker Eye Chart:

PSOUG / RSA Conference: April 20-24, Moscone Center, San Francisco
« on: April 09, 2009, 07:38:52 PM »

RSA Conference 2009

Then RSA® Conference 2009 is your information security event! As the information security field continues to grow in importance and influence, RSA® Conference plays an integral role in educating and connecting security professionals across the globe.

RSA® Conference 2009 offers enterprise and technical professionals one-stop learning. With targeted classroom sessions, innovative and interactive programs, provocative keynotes and a solutions-filled expo hall, RSA® Conference 2009 is the unbiased third party resource information security professionals rely upon.

Don’t miss events include the First-Time Attendee Orientation, Welcome Reception, "Table for 6" Dinners and topic-driven Peer2Peer Sessions to the renowned RSA® Conference Codebreakers Bash - among many others.

PSOUG / Enterprise Manager 10gR5 Released
« on: April 09, 2009, 05:00:30 PM »
Enterprise Manager 10g Release 5 Now Available

Lower cost with faster performance diagnostics and tighter integration with Oracle Applications and Oracle Fusion Middleware

Oracle Enterprise Manager's unique top-down approach to application management enables customers to reduce complexity and increase efficiencies in their IT environments and optimally run their enterprise applications. Oracle Enterprise Manager achieves this through an unrivaled blend of broad application management and quality assurance solutions with deep management solutions for Oracle technologies including Oracle packaged applications, Oracle Fusion Middleware, Oracle Database and Oracle VM.

"Customers are battling economic conditions that require a rigorous focus on delivering business operations and IT efficiencies at a lower cost," said Richard Sarwal, Oracle senior vice president Product Development. "Oracle Enterprise Manager supports both endeavors through automated management of business workflows, processes and services, as well as supporting the full Oracle software stack through its unique top-down application management approach."

    * Watch the first video OTN TechCast with Justin Kestelyn, Richard Sarwal, and Leng Tan
    * Watch the announcement Webcast on demand
    * Learn more about Oracle Enterprise Manager 10g Release 5

COLLABORATE 09 to Feature Educational Sessions from BI Consulting Group
Collaborate is the Technology and Applications Forum for the Oracle Community in Orlando

Added: 04/06/2009 - Jeremiah Johnson

Orlando, FL, USA, April 06, 2009 -- For the fourth consecutive year, the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest) join forces to host the leading technology and applications forum for the Oracle community.

BI Consulting Group, Oracle’s premier partner for Oracle Business Intelligence.

BI Consulting Group is a 2009 conference exhibitor and is presenting during two educational sessions during the conference.

At BI Consulting Group’s booth, attendees can:

  • See demonstrations of BICG IMPACT, the data-lineage and impact analysis tool for OBIEE.
  • See demonstrations of IDENTITY, BICG’s comprehensive branding & customization service for OBIEE interfaces.
  • Speak with members of BICG leadership who can provide insight into all BICG’s service offerings and share their thoughts on all things related to Oracle Business Intelligence.
  • Learn more about UGOBI. BICG is a proud sponsor of the User Group for Oracle Business Intelligence (UGOBI).

BI Consulting Group is conducting the following educational sessions:

Bulletproof Single Sign-On (SSO) for OBIEE. Monday, May 4 at 3:45pm. Room 1128.
Buy vs. Build - What's The Real Value of Pre-Built BI Analytic Applications?. Wednesday, May 6 at 11am. Room 1129.

May 3-7, 2009

BI Consulting Group Exhibit: Booth # 4358
Orange County Convention Center West, Orlando, Florida, USA

About Bi Consulting Group

BI Consulting Group is Oracle's premier consulting partner focused exclusively on Oracle Business Intelligence. Service offerings include consulting services, education services, support services as well as product services.

BICG's sole focus is Oracle Business Intelligence. Our experience with OBIEE is rooted in the origins of the software. Our consultants began using the business intelligence suite of products offered by Minnesota-based nQuire Software in late 1999. Siebel aquired nQuire in 2001, and Oracle aquired Siebel in 2006.

The experts at BI Consulting Group have collectively completed over 280 successful implementations of Oracle BI. Along the way, BICG has been honored with Oracle's Most Valuable Partner Award for Business Intelligence and the Oracle Excellence Award for creatively using Oracle Fusion Middleware with Oracle Applications (E-Business Suite, PeopleSoft, Siebel, JD Edwards etc) to create innovative and standards-based technology solutions. For further information about BICG, visit


COLLABORATE 09 is designed to help users of the full family of Oracle business applications and database technologies gain greater value from their Oracle investments. Created by and for users, COLLABORATE 09 offers an expert blend of customer-to-customer interaction and insights from technology visionaries and Oracle strategists. Representation at COLLABORATE 09 will include Oracle users, solution providers, consultants, developers and representatives from Oracle Corporation.

Jeremiah Johnson
Sr. Marketing Manager
BI Consulting Group
Orlando, FL

Pages: 1 ... 119 120 [121] 122 123 124