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 ... 120 121 [122] 123 124 125
1816
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.

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

Errors
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.

1818
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: http://www.crn.com/security/216500197

Conficker Eye Chart:
http://www.confickerworkinggroup.org/infection_test/cfeyechart.html


1819
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.


1820
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

1821
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.

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

WHAT:
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.

WHEN:
May 3-7, 2009

WHERE:
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 www.biconsultinggroup.com.

About COLLABORATE 09

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.

Contact:
Jeremiah Johnson
Sr. Marketing Manager
BI Consulting Group
Orlando, FL
651.403.6527
jeremiah.johnson@biconsultinggroup.com
http://www.biconsultinggroup.com

1822
PSOUG / Re: Still curious about what really happened
« on: April 02, 2009, 10:06:42 AM »
We are out of state as well and would be interested in some affordable distance-learning. Please update this forum if you have any further details.
Thank you for your interest; we certainly will update this as things develop.

1823
Lol, April Fools!  ;D


1824
PSOUG / Re: Still curious about what really happened
« on: March 30, 2009, 12:41:59 PM »
Yes, actually I asked my question because I read that blurb.   ;)
Well, there you have it. We're not sure what else to say, but if there's anything else you want to know, please ask.



To be honest, I am out of state (way out of state). I really was excited about the Boot Camp ideas and was hoping to bring some of that more local (ie, perhaps Niemiec's Chicago-based MOUG).
Well, perhaps MOUG members might be interested in some distance-learning, like what we'll be offering through the OLC. I mentioned www.SQLUniversity.net- they have some good courses up now and they'll be adding more shortly which we'll probably mirror (possibly at a reduced cost). We're still working out the details but it's going to happen.

We will also likely be offering some Boot Camp courses here at a local vendor's site, and the possibility exists that we would have instructors have courses at other interested user groups as well. Stay tuned, there's lots of stuff in the works. :)

1825
PSOUG / Re: Still curious about what really happened
« on: March 30, 2009, 11:16:27 AM »
In the interests of telling the whole truth without lying, disparaging, casting libel, disambiguity, etc, what really happened? =) So Mr. Dan Morgan left to pursue his own interests; great, fine.
A short explanation can be found on the PSOUG News page.

For example, Dan seemed to have been the spokesperson for the PSOUG Online initiative. Although he had a schedule and was taking orders, now I see that the Online Learning Center is suddenly dark ("coming soon"). When is "coming soon"?
We hope to have a number of the video-based courses available within a week or so, in cooperation with http://sqlniversity.net. These will include courses by Dan Morgan, Joe Celko, Steven Lewis, PhD, and others.



What happened to the previous schedule? For those of us who registered for classes, is anything going on next week, or is the whole thing canned?
To be honest, we don't know. We're not involved with Mr Morgan's current activities and can't speak for him or what he intends to do.

Again, I am not interested in the dirty details, nor the politics of why things happened. I am more curious about what the future of PSOUG looks like, specifically things like the famed DBA Boot Camp. Obviously, Mr. Morgan will still be heavily involved in his own efforts - I cannot help but to wonder what PSOUG's role will be.
We'll be re-forming the User Group for the Seattle/Pacific Northwest area, and there's a post detailing that here: Oracle User Group.

We intend to pick up where the PSOUG user group left off and support the Oracle community in ways that the old PSOUG never did. For example, job placement assistance, regular meetings, mentoring programs, code exchanges, networking, etc.

As we re-form the User Group, we'll be looking for a number of people to help make it happen by taking on key leadership roles (President, VP, Chairpersons, Membership Directors, etc).

We don't want to continue the past policies that included a somewhat haphazard schedule and a rather loosely-coupled management style. Our goal would be to have a group of Oracle professionals who see the value in a well-respected User Group, the way PSOUG was a year or so ago.

The key thing to keep in mind is that this sort of thing doesn't happen in a vacuum- we want to hear from people who would like to take an active role in the User Group. If this is something that you're interested in seeing happen, PM us and let us know, or discuss it here. We'd love to see some discussion about this and find out if there's a desire for this and a willingness to make it happen. It's not hard, but it will take some people to make it happen. Those people will share in the benefits of the group at every level.

Let us make it clear: The PSOUG site is going to grow and expand, including its reach and services. We sincerely want to support the Oracle community.

1826
PSOUG / Ellison mocks cloud computing, sells it anyway
« on: March 30, 2009, 09:36:30 AM »
Full Article: http://www.thestandard.com/news/2009/03/26/larry-ellison-grits-his-teeth-takes-oracle-cloud

Oracle CEO Larry Ellison has had a tough year. The man who was once dubbed the "Muhammad Ali of software" is helplessly watching as the competitive landscape shifts and his personal wealth takes a hammering.

And don't get Larry started on nansy-pansy buzzwords taking over the industry. The term that really rubs him the wrong way is "cloud computing," as an audience of analysts discovered last October during a Q&A session:

    "The computer industry is the only industry that is more fashion-driven than women’s fashion. Maybe I’m an idiot, but I have no idea what anyone is talking about. What is it? It’s complete gibberish. It’s insane. When is this idiocy going to stop?"

Unfortunately for Ellison, not any time soon. This morning's Wall Street Journal notes that there is some confusion over the definition of cloud computing. Still, that hasn't stopped practically every major IT vendor from jumping on the cloud computing bandwagon with products that promote the potential of Internet-based storage, processing, and software services.

Full Article: http://www.thestandard.com/news/2009/03/26/larry-ellison-grits-his-teeth-takes-oracle-cloud

1827
I need to rebuild a string value programmatically which has '&' and insert the same into another table.
Now the string may contain n no of '&' occurrances.
I may not understand exactly what the issue/problem is- is it a problem with the '&' characters specifically, or....?

1828
PSOUG / Best. Oracle. Error. Message. Ever.
« on: March 27, 2009, 08:23:40 AM »
Lol, from another forum:

"Got this little gem while running sqlldr:

SQL*Loader-926: OCI error while uldlfca: unexpected cvtret with ldret of no_data for table xxyyzz

Thanks Oracle."
 

1829
PSOUG / Oracle Updates for Multiple Vulnerabilities
« on: March 26, 2009, 03:06:43 PM »
May be old news for some, but if not, better start patching.

Oracle Updates for Multiple Vulnerabilities
Original release date: January 15, 2009
Source: US-CERT

Systems Affected

    * Oracle Database 11g, version 11.1.0.6
    * Oracle Database 10g Release 2, versions 10.2.0.2, 10.2.0.3, and 10.2.0.4
    * Oracle Database 10g, version 10.1.0.5
    * Oracle Database 9i Release 2, versions 9.2.0.8 and 9.2.0.8DV
    * Oracle Secure Backup, versions 10.1.0.1, 10.1.0.2, 10.1.0.3, 10.2.0.2, and 10.2.0.3
    * Oracle TimesTen In-Memory Database, versions 7.0.5.1.0, 7.0.5.2.0, 7.0.5.3.0, and 7.0.5.4.0
    * Oracle Application Server 10g Release 3 (10.1.3), version 10.1.3.3.0
    * Oracle Application Server 10g Release 2 (10.1.2), versions 10.1.2.2.0 and 10.1.2.3.0
    * Oracle Collaboration Suite 10g, version 10.1.2
    * Oracle E-Business Suite Release 12, version 12.0.6
    * Oracle E-Business Suite Release 11i, version 11.5.10.2
    * Oracle Enterprise Manager Grid Control 10g Release 4, version 10.2.0.4
    * PeopleSoft Enterprise HRMS, versions 8.9 and 9.0
    * JD Edwards Tools, version 8.97
    * Oracle WebLogic Server (formerly BEA WebLogic Server) 10.0 released through MP1, 10.3 GA
    * Oracle WebLogic Server (formerly BEA WebLogic Server) 9.0 GA, 9.1 GA, 9.2 released through MP3
    * Oracle WebLogic Server (formerly BEA WebLogic Server) 8.1 released through SP6
    * Oracle WebLogic Server (formerly BEA WebLogic Server) 7.0 released through SP7
    * Oracle WebLogic Portal (formerly BEA WebLogic Portal) 10.0 released through MP1, 10.2 GA, 10.3 GA
    * Oracle WebLogic Portal (formerly BEA WebLogic Portal) 9.2 released through MP3
    * Oracle WebLogic Portal (formerly BEA WebLogic Portal) 8.1 released through SP6

For more information regarding affected product versions, please see the Oracle Critical Patch Update - January 2009.


Overview
Oracle products and components are affected by multiple vulnerabilities. The impacts of these vulnerabilities include remote execution of arbitrary code, information disclosure, and denial of service.


I. Description

The Oracle Critical Patch Update - January 2009 addresses 41 vulnerabilities in different Oracle products and components. The document provides information about affected components, access and authorization required, and the impact from the vulnerabilities on data confidentiality, integrity, and availability.

Oracle has associated CVE identifiers with the vulnerabilities addressed in this Critical Patch Update. If significant additional details about vulnerabilities and remediation techniques become available, we will update the Vulnerability Notes Database.


II. Impact

The impact of these vulnerabilities varies depending on the product, component, and configuration of the system. Potential consequences include the execution of arbitrary code or commands, information disclosure, and denial of service. Vulnerable components may be available to unauthenticated, remote attackers. An attacker who compromises an Oracle database may be able to access sensitive information.


III. Solution

Apply the appropriate patches or upgrade as specified in the Oracle Critical Patch Update - January 2009. Note that this document only lists newly corrected issues. Updates to patches for previously known issues are not listed.

IV. References

    * Oracle Critical Patch Update for January 2009 - <http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujan2009.html>
    * Critical Patch Updates and Security Alerts - <http://www.oracle.com/technology/deploy/security/alerts.htm>
    * Map of Public Vulnerability to Advisory/Alert - <http://www.oracle.com/technology/deploy/security/pdf/public_vuln_to_advisory_mapping.html>

1830
PSOUG / Scott McNealy bashes Oracle as "heroin"
« on: March 26, 2009, 02:52:07 PM »
Full Article: http://searchdatacenter.techtarget.com/news/article/0,289142,sid80_gci1351994,00.html

By Alex Barrett, News Director - 26 Mar 2009

BOSTON -- With rumors of a takeover by IBM swirling around him, Sun Microsytems' chairman Scott McNealy tried to pitch a room of customers this week on the idea that Sun is a wily innovator whose software and hardware are far less costly than proprietary solutions from Oracle and IBM. But McNealy had little to offer loyal customers with Sun's legacy Sparc hardware.

Open source gets a plug
Like the man who succeeded him at the job of CEO, Jonathan Schwartz, McNealy also loudly beat the open source drum, but in his own inimitable style. Open source code is less buggy and more stable than proprietary code and insulates companies from the "shelf-life-of-a-banana problem" in which technology becomes obsolete 18 months after it was released.

And because the code is available for all to see, open source software such as Sun's MySQL offers a "low barrier to exit." Compare that with Oracle's database and applications. "We all know the first hit of heroin is free -- in fact, Oracle will probably pay you to roll up your sleeve," McNealy said. But sooner rather than later, your data is trapped in proprietary Oracle databases, and "contract negotiations become contract explanations."

Full Article: http://searchdatacenter.techtarget.com/news/article/0,289142,sid80_gci1351994,00.html

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