Gregarius

Unread items (100)

Discussion Forums: Message List - Forms

Re: VB/Crystal Report vs Oracle Form/Report Developer

Fetched: July 22nd, 2008, 10:31pm EDT

Then how about user-friendliness, stability and etc?
hello expert.... can you please help me

Fetched: July 22nd, 2008, 10:31pm EDT

i have a problem with my program, i have an application program named bulletin viewer which function is to view all the approved messages and post
Re: How to print Out variable of a function in select statement

Fetched: July 22nd, 2008, 10:31pm EDT

Do you mean you want to see the value when it is called within a form?
How to print Out variable of a function in select statement

Fetched: July 22nd, 2008, 10:31pm EDT

Hi ,
Re: slower record navigation w/ jre

Fetched: July 22nd, 2008, 10:31pm EDT

Facing similar issue :)
Re: Oracle proc on linux line break \ is not recognized

Fetched: July 22nd, 2008, 10:31pm EDT

Thanks, i will change it
Re: Commit in Header Block, but cannot Commit in Control Block

Fetched: July 22nd, 2008, 10:31pm EDT

Gerd,
Re: Calendar in Oracle Apps Custom Form shows wrong year

Fetched: July 22nd, 2008, 10:31pm EDT

There are so many special cases and cases with Oracle Apps that you will need to ask this question in the dedicated Apps tech forum rather than here.
Re: Sending email via Lotus Notes

Fetched: July 22nd, 2008, 10:31pm EDT

A simple way is the host-command.
Re: Multiple vs one schema in a Forms context

Fetched: July 22nd, 2008, 10:31pm EDT

Hi,

Discussion Forums: Message List - SQL and PL/SQL

Re: Literals

Fetched: July 22nd, 2008, 10:31pm EDT

Hi , in the query where clause instead of using like
Re: Literals

Fetched: July 22nd, 2008, 10:31pm EDT

> Hi , in terms of improving the perfomance i'm trying to do this in query. You're trying to do what in what query? Show us an example.
Re: Literals

Fetched: July 22nd, 2008, 10:31pm EDT

Hi , in terms of improving the perfomance i'm trying to do this in query. Thanks
Re: One more time about COUNT(*)

Fetched: July 22nd, 2008, 10:31pm EDT

With a primary key, no index entries will be null so the COUNT can be determined only by using the index, the table is not needed.
Re: Literals

Fetched: July 22nd, 2008, 10:31pm EDT

What would be the purpose? SYSDATE returns a new date value every second. A literal would be fixed at one point. So you're going to fundamentally
One more time about COUNT(*)

Fetched: July 22nd, 2008, 10:31pm EDT

We have had related discussions, but looks like I missed something.
Literals

Fetched: July 22nd, 2008, 10:31pm EDT

Hi what we can instead of sysdate in a query , any literal we can use? Thanks
Re: Crash in Tablespace

Fetched: July 22nd, 2008, 10:31pm EDT

> It rather depends what Muttley's procedure is up to.
Re: supress/override the &

Fetched: July 22nd, 2008, 10:31pm EDT

You can also use [pre] update cer_bulk_purge set type = 'BOM' where contract = chr(38) || 'C0761-001'; [/pre]
Re: Dataflow Map between Oracle Databases.

Fetched: July 22nd, 2008, 10:31pm EDT

Depending on your database version, possibly.... [pre] select * from user_dependencies where REFERENCED_LINK_NAME is not null; [/pre]

OraNA :: Oracle News Aggregator

9 Reasons I Need to Blog More

Posted: July 22nd, 2008, 9:03pm EDT by Bradd Piontek

Almost on a daily basis, I sit and stair at the Prestidigitation of Oracle and wonder what I should blog about today. I know I have a lot of ideas floating around in my head and all it takes is that mental kick in the arse to get it out. And yet, here I am sitting on July 22nd, 2008 with only 3 blog posts since starting in February (That is a) not a good average and b) 2 posts, as the first one was an inaugural post). This is my attempt to kick my brain in the arse and do what I set out to do this year. Seth Godin blogged the other day about 12 ways to get your blog to the top of digg. I thought I'd try some of the tactics he mentioned in an earlier blog. I've also been semi-inspired by Fred Wilson's A VC Blog over the course of the year. While he tends to dwell in a world completely foreign to me, it is rarely not an interesting read and can get my creative juices going. Without further ado, and in no particular order:

1. Everybody is doing it
- I just threw that in there for the high school affect. I'm really not a follower (well, I am on twitter). You can definitely argue that I am on the bandwagon a bit late. But, better late than never. In all seriousness, I read a lot of interesting blog articles from Oracle professionals, venture capitalists, Social networking sites etc. I think I have something to offer and give back to the community.

2. More Blogging = Less TV time
- I love TV, I really do. The DVR was the best (and worst) invention to come in the past 5-10 years. Although, now that I think about it, I can sit in front of my laptop with a favorite TV show in the background. Maybe I should find a better hobby :)

3. What goes better with beer than blogging?
- I've seen lists like "Best Beer Drinking Sports" and the like. Well, blogging is a perfect fit for beer drinking. I love beer, I love making it, drinking it, and finding new beer. The thought of sittin back, relaxing with a cold one, and writing the thoughts in my head seems like a perfect blend.

4. Time to increase my Oracle breadth
- I spent my most of my days working on company-related database issues. There doesn't seem to be nearly enough time to do R&D. Keeping an Oracle-related blog is a great way to force me to do my own research and improve my Oracle DBA skills on my own. Now I just need to get this laptop's memory increased so I can get Oracle 11g running on VirtualBox and I'll be in business. I've started keeping a daily list of topics I want to blog about. The next step is to get that done.

5. Aspirations
- I have aspirations to present at Oracle technical conferences. I look at blogging as a great first step to getting to that goal. This will force me to come up with ideas and not only find my voice, but also an audience (I hope).

6. Peer Pressure
- I suppose that sounds an awful lot like reason #1. However, it is a bit different. I look at peers and see the amazing things they are doing on their blogs and the great content they are creating and sharing with the oracle community (Look at Dan Norris, Eddie Awad, Greg Rahn, Don Seiler to name a few) and I say "hey, I can do that, and can hopefully add my own perspective".

- An interesting aside related to Greg Rahn. He probably doesn't realize it, but without Greg Rahn, I probably wouldn't even be an Oracle DBA. In 2000, I had just been hired on as a full-time developer at a local utility. Greg was a DBA there. He resigned later that year , I think to find his fortunes out west during the Dot Com boom. That left an opening on the DBA team. I was approached by one of their Senior DBAs to be a DBA. I thought it was a crazy idea. Those DBAs didn't do anything ;) I was a C developer, I knew it all. Luckily, I decided to take the leap and have been loving it ever since. Thanks Greg for resigning and opening up that door to me ;)

7.Twitter: Sometimes 140 characters just isn't enough
- I love twitter. It is a somewhat emerging social networking idea. Some think blogging is dead and microblogging is the wave of the future and replace blogging. I'm not sure I agree at this point but I do find it a very useful medium to share ideas and expand my horizons. Sometimes (okay, a lot of times) my thoughts take up more than 140 characters. That is where the Prestidigation of Oracle needs to take over.

8. Unload some of those brain cells.
- I'm a big believer in the Use It or Lose it Principle. I think this applies to daily life. Whether it be that new whiz-bang Oracle feature you just read about, the latest training class you are thinking about taking or documenting that new package you just wrote.

9. Comfort Zone
- I think it is real easy to get into a comfort zone. Life can get hectic and it is simple to get into a routine. You need to challenge yourself and shake things up to grow. I look at blogging as a natural way to do this. While I feel I've always been a decent writer, it has generally been with little purpose (essays, papers, etc). I need to find a purpose and hopefully this can get me on the right track.
Fun After Oracle OpenWorld, Part 2

Posted: July 22nd, 2008, 7:15pm EDT by jack.flynn

Cross the Bay Bridge and Discover What Nobody in San Francisco Will Tell You

In this second of four posts on San Francisco Bay Area getaways, we'll travel east. Know what you'll find there? Sunshine. Easy (or at least easier) parking. World-class—and hugely diverse—dining and music venues. The Raider Nation and the Oakland A's. Charming, strollable neighborhoods. And countless parks and nature areas.

Check it out.

TO THE EAST
Berkeley: There are all sorts of music venues, the Tony Award-winning Berkeley Repertory Theater, and all the tie-dye you could ever want. Try to get a reservation at Chez Panisse, which was ground zero for California Cuisine. Take a walk around the Cal campus.

Oakland: Just as cool—if not cooler—than Berkeley, with better parking, its own baseball and football franchises, and quite possibly the best pizza (Arizmendi, Pizzaiolo, Zachary's) and strawberry shortcake (Bakesale Betty) on the face of the earth.

East Bay Parks: Discover miles and miles of hiking and biking; remarkable vistas, lakes, and picnic areas; and off in the distance, Mount Diablo.

If we reveal more, the Let's-Keep-the-East-Bay-to-Ourselves Coalition will come after us in force. On the other hand, if you have some great East Bay haunts, or want to recommend something to the Oracle OpenWorld community, leave your comments.

Otherwise, we'll get back to you after the next A's game.

Part 1: North
Our Database Environment became Famous

Posted: July 22nd, 2008, 6:37pm EDT by kocakahin

Recently Oracle has created a customer snapshot for our database environment and recently published it on Oracle Website
Ace Adventures - Dan Morgan

Posted: July 22nd, 2008, 6:15pm EDT by Jeff Erickson, Tech Editor, Oracle Publishing

I’m trying to decide what was the best part of PSOUG’s Oracle Days event up in Seattle last week. Was it hearing an advocate of IBM Z series fire back, quite convincingly, at IBM’s blade server rivals? Was it getting a serious lesson in data storage by Pillar Data Systems as they introduced the Axiom 600? No, the best part would have to be riding to Microsoft in Dan Morgan’s Jaguar to shoot clandestine video for our upcoming Oracle Magazine story and video podcast.

As we were driving, Morgan, second in command at the Puget Sound Oracle User’s Group, discussed the benefits of being an Oracle Ace Director. “It doesn’t lead directly to money,” he said. But it does, he said, come with interesting speaking opportunities, such as upcoming engagements that Oracle booked for him in Finland and, I think, Bulgaria. And it does lead indirectly to money.

When Morgan, a professor of database technology in University of Washington, does go out to do consulting, being an ACE Director can help land gigs. “”When I walk into a client who is also talking to a global giant like Accenture, I simply ask if the firm is going to put someone on their account who is recognized by Oracle as one of the top people on the planet who really, really knows his stuff,” he said. “So in that way, I guess it does lead to money.”

Take a look at Morgan’s library and you will see one reason he’s an Oracle Ace Director. Also check out the other resources on the PSOUG Website and you’ll see just how good a resources a regional user group can be.
My Oracle Open World 2008 XMLDB Sessions

Posted: July 22nd, 2008, 6:08pm EDT by Marco Gralike

For those who might me interested I will try to post the XML(DB) related presentations here on this website, but don’t forget to mark the following in your schedule… Session ID: S300192 Session Title: Oracle XML DB: Building Blocks and Best Practices Track: Oracle Develop: Database Room: Golden Gate C3 Date: 2008-09-21 Start Time: 10:30 Session ID: S298824 Session Title: Real-World Experience with [...]
Design:: Spare time to throw something together

Posted: July 22nd, 2008, 5:27pm EDT by admin

I had a couple hours spare today and threw a quick concept for a MOD website (MODern Housing Solutions) that was in need of an urgent facelift. (Left img is their current site)

Didn’t have a spec, so it will probably be all wrong but for 2hrs work it isn’t bad for a draft concept of possible branding and design schema.
Kathi’s 8 Things

Posted: July 22nd, 2008, 5:21pm EDT by Kathi Chenoweth

It’s taken me awhile to come up with my list. My colleagues are just so much more interesting than I am!

1. I was born in Northwest Indiana; I grew up in Northwest Indiana; I currently live in Northwest Indiana. See - I’m not kidding about being boring. I did branch out and live in Chicago for four years – which is about 40 miles away, quite an adventure which required crossing a state line! Also spent a couple of years sampling apartments in various suburbs of Chicago. So I have used every mode of public transportation in what we call “Chicagoland” in order to get to my jobs in downtown Chicago. That was back in the days when I actually had to commute to work. Now I walk three steps from my bedroom to my office.

My mom lives less than 2 miles from me. My sister lives about 3 miles from me. And my brother lives about 4 miles away. It’s nice having family nearby.

2. Growing up I had four imaginary friends. First there is the trio of Candy, Uh-um and Apadasadum, they always hung out together. I am not sure how to spell their names since I didn’t know how to read/write/spell when I met them. The fourth was Danger. He took the heat for anything bad that happened. “Danger did it”.

3. I have an unusual musical background. My mom always wanted me to take piano lessons, which I resisted because I thought it was too nerdy. I seriously don’t know why I thought that would put me over the edge into nerdiness, because the straight A’s and goody-two-shoes behavior already pretty much sealed it. So instead I played the viola (sure, being in orchestra isn’t nerdy!). Viola is unusual because it uses alto clef, which doesn’t help you read music for any other instrument. So you can figure the rhythm but nothing else if you try to read,say, music for a piano.

My other musical skill is handbells. I loved playing in handbell choir at church (no that’s not nerdy either…). I even performed as part of the Purdue University Musical Organizations Handbell choir, and got pretty good at the four-in-hand technique. This was a blast despite the hideous tuxedo-looking, long black skirt /cumberbund/bow-tie uniforms we had to wear.

Oh, and when I was in high school I finally thought it would be cool (sigh, I have no idea what cool is) to learn piano so I took lessons for two years. So I know how to play some very easy songs very poorly. On the bright side, I have the piano that my parents bought for this purpose and one day I’m going to learn how to play it properly (if only the music came in alto clef, I’d be set)!

4. I am skilled in Mirror Writing. I do not know why I can do this.

5. In college, my friends and I came in 2nd place in a lip synch contest.

6. I lived/worked in Munich for a spell back in the mid 90’s. My apartment was a block away from the Oktoberfest fairgrounds. I loved, loved, loved Oktoberfest and spent many nights there over the course of two seasons. It combined a few of my interests such as Beer and Singing Loudly While Standing on a Table. My all time favorite Oktoberfest songs was John Denver’s “Take Me Home Country Roads”. One day my friends pooled their money and paid for me to get up on stage and conduct the Oompa band, to, what else…Take Me Home Country Roads.

Also while working in Munich, I was part of the infamous Bleifrei Incident but I am sworn to secrecy on that one.

7. I am a fan of the show The Bachelor (and The Bachelorette). These shows are just so stupid but I really like them. I used to watch the even worse variations such as Joe Millionaire and Average Joe but after a couple of seasons where the bachelor(ette) picked the “wrong” person, I vowed never to watch them again.

8. My stepsons have a Wii. When they first got it, they showed me how to create my own Mii. Seemed fun — so I brought up the default female Mii to start. Hmmm, that looks like me already. That can’t be. So I tried changing some things – nope now it looks less like me. So, yes, I am the default Mii. I did change her to a purple outfit just to jazz things up. See, I told you I was boring!
Full Outer Joins in OWB

Posted: July 22nd, 2008, 5:13pm EDT by jean-pierre.dijcks

One of the questions I noticed recently was on full outer joins. How do you do that in OWB. Well it is quite simple, but I guess not that obvious. So here is a quick post on how to do this.

Here we have a simple mapping, where I join on code. I want to get all records (yeah not a great business case I know) from both tables, so I know if there are records on either side without matches.

My join looks like this:

Now if I complete the mapping to look like this, I can generate code.

As you see by default (this is OWB 10.2.0.3) you get an ANSI join syntax:

Want something not ANSI, go to configuration on the mapping and uncheck the ANSI SQL Syntax code option. Note that if you are doing Multi Config, you can change this per deployment of the mapping...
ORA-22809: nonexistent attribute

Posted: July 22nd, 2008, 4:59pm EDT by Byte64

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

As recently promised in an OTN forum posting, i am now ready to say something more detailed about ORA-22809 and other issues i encountered during recent experiments with XML db.

For once let's begin from a working script and then modify it to reproduce the problem.
Given the limitations
Advisories for the July 2008 Critical Patch Update and exploit code

Posted: July 22nd, 2008, 4:46pm EDT by (author unknown)

There has been a number of emails posted to the bugtraq and full-disclosure mailing lists in the last few days detaling some of the vulnerabilities fixed in the recent Oracle Critical Patch Update July 2008. It is worth detaling some....[Read More]

Posted by Pete On 22/07/08 At 09:29 PM
The “Dude” Guy has made a Blog…

Posted: July 22nd, 2008, 4:10pm EDT by Marco Gralike

The “Dude” Guy has made a Blog, also to his surprise, have a look here: http://www.ora600.be/ora600-blog Welcome Mr. Kurt van Meerbeeck to the wonderful world of “blogging”, let them ‘backup & recovery” war stories roll in…
Lost in translation - Globalisation Gotchas

Posted: July 22nd, 2008, 3:11pm EDT by Peter O'Brien

When we think of Globalisation, we often think of the manufacture and trade of goods. With the advent of the European Union came the more formalised notion of 'the four freedoms' (people, goods, services, capital) of the internal market. People, goods and capital is fairly tangible, but what is interesting from an IT point of view is globalisation (or free movement) of services. It's not just fashionable to outsource your call centre department, but also development effort.

High speed internet aspect takes care of one of the challenges of communication, but what about the language itself? When outsourcing, how does one ensure the requirements are communicated correctly. Using online translation tools can go horribly wrong. In this case journalists from Isreal managed to insult a prominent Dutch politician and his mother!

The top destination for outsourcing is India. India has the world's second largest labour force with 516.4 million (2007 est.), 27% of them involved services (2003 est.). Global consultancy firm PricewaterhouseCoopers has more details. This is a highly skilled, well educated workforce and though not always needed, Hindi translation, Punjabi translation and Urdu translation services are available. While Hindi is the official language, English enjoys the status of 'subsidiary official language'. Certainly within the services sector there is a English language revolution going on. Add to that the fact that most of the development languages, and IT infrastructure product documentation, are in English and there are obvious advantages here.
Outsourcing is no longer just for Fortune 500 companies. Small and mid-sized firms, as well as busy professionals, can outsource their work to increase their productivity and free time for more important commitments. It's time for the world to take advantage of this revolution.

Vivek Kulkarni (CEO Brickwork India and former IT Secretary, Bangalore)

Of course this level of outsourcing still requires commitment and a lot of upfront preparation and documentation. A lot of industries are moving away from the heavy weight processes of the 20th century. It will be interesting to see how Agile development methodologies, which put a greater emphasis on communication over documentation, work with distributed development teams, in different timezones. Feel free to share your experiences.
Tuxedo good to Rehost COBOL Batch?

Posted: July 22nd, 2008, 3:07pm EDT by Jason Williamson

Tuxedo for batch

We know that Tuxedo gives Oracle a great advantage for rehosting IMS and CICS COBOL from the Mainframe on to Open Systems. With TUX we can now provide Mainframe Quality of Service on the entire stack for CICS and IMS. So that means, our customers can gain a lot of savings from high cost hardware and OS from Z/OS by running on Linux (Even z/linux too) while opening up more standards...etc. All the good stuff we talk about.

What if you want to rehost batch programs? Is Tux good for that too? You may think the main advantage of using Tux for rehosting is that it provides the ability to do transaction processing and two phased commits, but for batch you can just use a standard COBOL compiler for linux or windows (Like MF/Accu..Fujitsu...etc)

Well, you miss out on some key RAS featuers. Let's look a bit closer.

What makes up Mainframe Batch? Let's look at this for a second. Batch on the mainframe usually looks like --> Z/OS + JES + LPRS +JCL + COBOL

Now, if you rehost batch with Micofocus Cobol only you get --> Distrubted OS (good) + JCL + COBOL

Tux looks like --> Distrubuted OS (Still good) + Tuxedo (Z/OS Like features...LPRS, JES Like runtime) + COBOL + JCL

Tuxedo provides also provides:
Connection Pooling
Clustering
Failover
Scalability
So, ask yourself, would you run a production batch system off the mainframe without these features? It's great to rehost and save money, but you CAN'T sacrifice RAS.

So here are some great reason for Batch with Tuxedo:

:: RAS (reliability, availability, scalability) built in
:: Sizable number of implementations
:: Over 2,000 implementations
:: Provides a ‘Java like’ container for COBOL applications
:: Supports C/C++ so languages like PL/1 and Assembler can be migrated to C/C++ instead of COBOL
:: SOA enabled out of the box
:: Can use any Job Scheduler you want including the free Oracle Scheduler solution
Hyperion Financial Reporting 11.1 - Annotations and Cell level Commentary

Posted: July 22nd, 2008, 2:30pm EDT by Venkatakrishnan J

One excellent feature of the new EPM 11.1 release is that one can now add cell level/report level comments in Hyperion Financial Reporting. Since Hyperion Financial Reporting(HFR) is primarily used for creating financial reports out of Essbase, this feature makes a lot of sense wherein users can add attachments/comments to a report which other users can see & comment/reply upon. For example, consider a scenario wherein there are 2 users admin1 and admin2 who are analyzing the same HFR report. Consider admin2 to be a financial analyst and admin1 to be an Essbase/HFR Administrator. Now, lets assume that the HFR administrator has created the below shown report based on the DMDemo data which one would get by default after installing EPM 11.1.





As you see, the above is a very simple report wherein users can analyze the product sales across different years for different scenarios. Now, once this report has been created admin1 would then publish the report out to admin2 so that he/she can do the analysis on the report. Admin2 user, after doing an analysis realizes that there is a huge mismatch in the data. There are some negative numbers which is not possible since sales can only be positive or zero. In a normal scenario, if admin2 wanted to raise a flag to the Report Administrator (admin1), he would have to send an email to admin1 stating that the report data is wrong. Now with the introduction of Annotations, one can add comments to a report at the report level, cell level, grid level and individual member levels. So, admin2 would basically come inside the HFR report and would enable the Annotations window.



The annotation window would look similar to the screenshot shown below.



Now, the admin2 user would click on New to create an annotation.



One can assign different categories to the annotation. Also, one can assign contexts and also attach an URL or a custom document to the annotation.







In our example, admin2 realizes that 2003 numbers are totally wrong (since they are all negative). Hence he would be creating 2003 Year member level annotation indicating to the admin1 user that 2003 data is wrong.



He would also assign a 2003 member context to the above annotation.



Now, the annotation would automatically come on the 2003 member as a cell document (shown in the below screenshot)



The admin2 user would then set a permission on this annotation so that admin1 can see this annotation.



Now if we log in as admin1, we should be seeing an annotation on the 2003 member. Now, admin1 user can reply back to this annotation, informing admin2 that he would look into the reporting issue.



A very interesting feature. I believe this was part of the Hyperion Planning product before and this has now been incorporated into Hyperion Financial Reporting. It would be very interesting to see how this feature comes over to BI EE since dashboard commentary is something that is lacking currently in BI EE. Though i have blogged about the method of implementing the dashboard commentary for BI EE here, the major problem there is it maintains all the commentary in the database which should typically not be the case. Report and member level commentaries should be maintained only in the report metadata.
CURSOR_SPACE_FOR_TIME to be deprecated in future releases

Posted: July 22nd, 2008, 1:50pm EDT

According to a recently published metalink note (565424.1) the parameter "CURSOR_SPACE_FOR_TIME" is going to be deprecated starting release 11.1.0.7 onwards. In fact Oracle's next patch set release for 10g - 10.2.0.5 will also de-support this parameter. We will have to remove this parameter whenever these 2 patch sets - 10.2.0.5 for 10g and 11.1.0.7 for 11g are released and we decided to migrate. CURSOR_SPACE_FOR_TIME was introduced to reduce latch contention; This parameter may no longer be required with introduction of cursor mutexes hence Oracle has decided to deprecate this in future releases.

OAM Identity XML (IDXML) via XMLHttpRequest

Posted: July 22nd, 2008, 1:27pm EDT by Mark Miller

It makes sense that the ideal HTTP Client for IDXML processing is the authenticated user's browser. After all, it already has the ObSSOCookie.

JQuery is the Javascript library of choice for all my client work lately. You can see why in the following example of processing an IDXML request via Javascript straight from the client. The use cases for this capability are endless.

This is the proverbial 'tip of the iceberg' in utilizing OAM Identity in a modern web development context. The end result: Perfectable user experiences based on data and services made available and secured through OAM's web based configuration tools. It's a powerful combination.

Lets take a simple create user workflow request and turn out a simple Javascript templating function to build the string for us:


getSoap = function(data){
  var dat = [];
  dat[dat.length] = '<?xml version="1.0" encoding="UTF-8"?>';
  dat[dat.length] = '<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas-xmlsoap.org/soap/envelope/" xmlns:oblix="http://www.oblix.com">';
  dat[dat.length] = '<SOAP-ENV:Body>';
  dat[dat.length] = '<oblix:request function="workflowSaveCreateProfile" version="NPWSDL1.0">';
  dat[dat.length] = '<oblix:params>';
  dat[dat.length] = '<oblix:ObWorkflowName>obworkflowid=672fcf2e9c5946a8b5b225b349acd46b,obcontainerId=workflowDefinitions,OU=Oblix,OU=apps,DC=company,DC=com</oblix:ObWorkflowName>';
  dat[dat.length] = '<oblix:ObDomainName>OU=people,DC=company,DC=com</oblix:ObDomainName>';
  dat[dat.length] = '<oblix:noOfFields>5</oblix:noOfFields>';
  dat[dat.length] = '<AttributeParams xmlns="http://www.oblix.com/">';
  dat[dat.length] = '<GenericAttribute>';
  dat[dat.length] = '<AttrName>uid</AttrName>';
  dat[dat.length] = '<AttrNewValue>'+data.uid+'</AttrNewValue>';
  dat[dat.length] = '<AttrOperation>ADD</AttrOperation>';
  dat[dat.length] = '</GenericAttribute>';
  dat[dat.length] = '<GenericAttribute>';
  dat[dat.length] = '<AttrName>cn</AttrName>';
  dat[dat.length] = '<AttrNewValue>'+data.cn+'</AttrNewValue>';
  dat[dat.length] = '<AttrOperation>ADD</AttrOperation>';
  dat[dat.length] = '</GenericAttribute>';
  dat[dat.length] = '<GenericAttribute>';
  dat[dat.length] = '<AttrName>mail</AttrName>';
  dat[dat.length] = '<AttrNewValue>'+data.mail+'</AttrNewValue>';
  dat[dat.length] = '<AttrOperation>ADD</AttrOperation>';
  dat[dat.length] = '</GenericAttribute>';
  dat[dat.length] = '<GenericAttribute>';
  dat[dat.length] = '<AttrName>givenName</AttrName>';
  dat[dat.length] = '<AttrNewValue>'+data.givenName+'</AttrNewValue>';
  dat[dat.length] = '<AttrOperation>ADD</AttrOperation>';
  dat[dat.length] = '</GenericAttribute>';
  dat[dat.length] = '<GenericAttribute>';
  dat[dat.length] = '<AttrName>sn</AttrName>';
  dat[dat.length] = '<AttrNewValue>'+data.sn+'</AttrNewValue>';
  dat[dat.length] = '<AttrOperation>ADD</AttrOperation>';
  dat[dat.length] = '</GenericAttribute>';
  dat[dat.length] = '</AttributeParams>';
  dat[dat.length] = '<oblix:obactorcomment>IDXML from browser via Javascrip</oblix:obactorcomment>';
  dat[dat.length] = '</oblix:params>';
  dat[dat.length] = '</oblix:request>';
  dat[dat.length] = '</SOAP-ENV:Body>';
  dat[dat.length] = '</SOAP-ENV:Envelope>';

  return dat.join("");
};

Then, if we prep a little data object with values (presumably pulled from the user interface):


var userdata = {
  uid:"marmil",
  cn:"Mark Miller",
  mail:"mark[at]nulli.com",
  givenName:"Mark",
  sn:"Miller"
};

I can call my template and consider my soap envelope ready to go:


var createUserSoapRequest = getSoap(userdata);

All over but the sending (and response handling):


// process the request
$.ajax({
  type: "POST",
  dataType:'xml',
  url: "/identity/oblix/apps/userservcenter/bin/userservcenter.cgi",
  data: createUserSoapRequest,
  contentType:"text/xml",
  processData:false,
  success: function(idxmlResponse){
    // crude
    alert(idxmlResponse);

    // better
    $("ObConfirmation",idxmlResponse).find("ObValue").each(function(i,o){
      alert($(o).text());
    });

    // in the real world, employ dom trickery to keep the user oriented...
  }
});

Cool, no?

!$title$!

Posted: July 22nd, 2008, 1:16pm EDT by Jake

!$text$!
!$title$!

Posted: July 22nd, 2008, 1:16pm EDT by Jake

!$text$!
OMS version not checked yet …

Posted: July 22nd, 2008, 12:44pm EDT by Hector Rivera Madrid

When a grid control agent was installed during a RAC setup an error showed up at the end of the agent configuration assistant.

The agent was started successfully, but it was not possible to force the agent to have the XML files uploaded to the grid server, it was when the dreaded error "EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet.." showed up.

The problem basically was due to a password typing error during the configuration phase.

The Troubleshooting Procedure Outline was:

Setup the Agent Home environment
export AGENT_HOME=/u01/app/oracle/pruduct/10.2.0/agent10g
export PATH=$AGENT_HOME/bin:$PATH

Startup the Agent
emctl start agent

Clear the Agent status
emctl clearstate agent

Reset Credentials
emctl secure agent

Retry and verify synchronization operations
emctl upload agent
emctl status agent

###
### EM Agent Troubleshooting log
###

$ export AGENT_HOME=/u01/app/oracle/product/10.2.0/agent10g
$ export PATH=$AGENT_HOME/bin:$PATH

$ # Start agent
$ emctl start agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Starting agent ......... started.
$
$
$ # Trying to force XML files uploading
mct$ emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

$ # Clear EM Agent status
$ emctl clearstate agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
EMD clearstate completed successfully

$ # Configuring OMS Credentials
$ emctl secure agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Enter Agent Registration password : *******
Agent successfully stopped... Done.
Securing agent... Started.
Requesting an HTTPS Upload URL from the OMS... Done.
Requesting an Oracle Wallet and Agent Key from the OMS... Done.
Check if HTTPS Upload URL is accessible from the agent... Done.
Configuring Agent for HTTPS in CENTRAL_AGENT mode... Done.
EMD_URL set in /u01/app/oracle/product/10.2.0/agent10g/eg6881.us.oracle.com/sysm
an/config/emd.properties
Securing agent... Successful.
Agent successfully restarted... Done.

$ # Retrying operations
$ emctl status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.1.0
OMS Version : 10.2.0.1.0
Protocol Version : 10.2.0.0.0
Agent Home : /u01/app/oracle/product/10.2.0/agent10g/eg6881.us.oracle.com
Agent binaries : /u01/app/oracle/product/10.2.0/agent10g
Agent Process ID : 5307
Parent Process ID : 5260
Agent URL : https://eg6881.us.oracle.com:3872/emd/main
Repository URL : https://eg6876.us.oracle.com:1159/em/upload
Started at : 2008-07-22 15:40:37
Started by user : oracle
Last Reload : 2008-07-22 15:40:37
Last successful upload : 2008-07-22 15:40:58
Total Megabytes of XML files uploaded so far : 0.79
Number of XML files pending upload : 18
Size of XML files pending upload(MB) : 1.86
Available disk space on upload filesystem : 27.54%
Last successful heartbeat to OMS : 2008-07-22 15:40:43
---------------------------------------------------------------
Agent is Running and Ready

$ emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully

$ emctl status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.1.0
OMS Version : 10.2.0.1.0
Protocol Version : 10.2.0.0.0
Agent Home : /u01/app/oracle/product/10.2.0/agent10g/eg6881.us.oracle.com
Agent binaries : /u01/app/oracle/product/10.2.0/agent10g
Agent Process ID : 5307
Parent Process ID : 5260
Agent URL : https://eg6881.us.oracle.com:3872/emd/main
Repository URL : https://eg6876.us.oracle.com:1159/em/upload
Started at : 2008-07-22 15:40:37
Started by user : oracle
Last Reload : 2008-07-22 15:40:37
Last successful upload : 2008-07-22 15:41:13
Total Megabytes of XML files uploaded so far : 2.65
Number of XML files pending upload : 1
Size of XML files pending upload(MB) : 0.03
Available disk space on upload filesystem : 27.54%
Last successful heartbeat to OMS : 2008-07-22 15:40:43
---------------------------------------------------------------
Agent is Running and Ready
$
Wordle

Posted: July 22nd, 2008, 12:33pm EDT by billy.cripe

check out wordle - a word clouding tool. This is the start of an interesting kind of concept mapping. It displays words and sizes based on frequency. This is the Wordle cloud of this blog's rss feed: (click it for a bigger version)

The ORACLE-BASE Blog

WALL-E…

Posted: July 19th, 2008, 2:49am EDT by Tim...

WALL-E is probably one of the most impressive CGI films I’ve ever seen. The first thing that struck me was how realistic everything looked. At times you could be fooled into thinking it was live action with a computer generated character superimposed. That’s Pixar Animation Studios for you. The second half of the film looks less real, but that’s due to the nature of the scenery, not the quality of the animation.

The story isn’t too bad. It’s quite funny at times, but overly mushy in my opinion. I’m not totally sure what the target audience is for this film. It’s a “U” rating, but I can’t see my nephews being happy watching it. At the start there are long periods where it’s visually interesting, but not entertaining as such, so I don’t think it would hold their attention. The cinema was deathly quiet for most of the film, so I guess the adult audience were hooked. The second half of the film becomes more like your standard kids cartoon. I guess you could say it feels like a film of two halves.

Cheers

Tim…
More Server Builds and Presenting…

Posted: July 18th, 2008, 4:08am EDT by Tim...

Server Builds

My room is full of servers again. I’m still rebuilding loads of kit to send to the new site. Yesterday I installed RHEL4 on two servers ready for 10gR2 installations, and RHEL3 on three servers ready for AS10g (9.0.4) installations. The versions, especially App Server, may sound strange, but this is to duplicate the current environment, so my hands are tied.

The three application servers are all going to be installed as 1 node clusters, so we can configure and test them before releasing the remaining nodes. Just trying to reduce the impact of the move.

Hopefully, by the end of today we will have at least one node for every layer in the new production and test environments.

It’s not long until I leave this company, so I’m really keen to get everything moved and bulletproof.

Presenting

OpenWorld: Booked, and I’m ready to go.

AUSOUG: I’ve just received confirmation of my conference presentations in Australia. I’m presenting two papers at both the Perth and Gold Coast events.

NZOUG: I’ve been confirmed for the New Zealand conference in Rotorua, but I don’t know how many papers I’m presenting yet.

One of my friends is trying to sort out a presentation at a local user group in New Zealand after the main conference is over. Seems a shame to go all that way and not do as much as possible.

So it looks like the world tour is back on.

By the end of the year I will have been to Austria, Denmark, Estonia, America, Australia and New Zealand. I guess this seems a little tame for some of the consultants out there, but for a regular Joe DBA / Developer from Birmingham it seems a bit crazy.

Cheers

Tim…

Discussion Forums: Message List - Forms

Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

i think i found it
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

i've already downloaded the demos.
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

i found that enable_item and disable_item
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

try that http://download.oracle.com/otndocs/demos/Forms_Demos_10gr2.zip it might not prompt you for username/paswd
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

i can't
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

could you send me menudef.mmb?
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

do you have a "demo" directory under your forms 6i but not for 10g ? chk Note:459165.1 from metalink. you might need to install 10g demos
Re: lib path

Fetched: July 17th, 2008, 3:00pm EDT

now i can see it my self that code is from ora samples menudef.mmb has the same code i have just downloaded the samples and i can see it now...
Problems with NLS_SORT

Fetched: July 17th, 2008, 3:00pm EDT

Hi,
Re: Change LOV, record group using Custom.pll

Fetched: July 17th, 2008, 3:00pm EDT

This can be done using Global variable.

Discussion Forums: Message List - SQL and PL/SQL

Re: what is the PIPELINED TABLES

Fetched: July 17th, 2008, 3:00pm EDT

There is no such thing as a [b]pipelined table[/b]. However there are [b]table functions[/b] (functions that return a collection), which can be
Re: uderstanding SQL

Fetched: July 17th, 2008, 3:00pm EDT

The CHR(N) will return an ascii character based on it's decimal code. Ascii character 186 appears to be a degrees symbol. See
Re: sql doubt

Fetched: July 17th, 2008, 3:00pm EDT

If those are quarters:
Re: Space in the Table

Fetched: July 17th, 2008, 3:00pm EDT

Hi , Thanks alot that worked just great.. Regards Maverick
uderstanding SQL

Fetched: July 17th, 2008, 3:00pm EDT

What is CHR(186) here. Any idea

Gregarius

Feeds

Unread items (100)

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Fetched: July 22nd, 2008, 10:31pm EDT

Posted: July 22nd, 2008, 9:03pm EDT by Bradd Piontek

Posted: July 22nd, 2008, 7:15pm EDT by jack.flynn

Posted: July 22nd, 2008, 6:37pm EDT by kocakahin

Posted: July 22nd, 2008, 6:15pm EDT by Jeff Erickson, Tech Editor, Oracle Publishing

Posted: July 22nd, 2008, 6:08pm EDT by Marco Gralike

Posted: July 22nd, 2008, 5:27pm EDT by admin

Posted: July 22nd, 2008, 5:21pm EDT by Kathi Chenoweth

Posted: July 22nd, 2008, 5:13pm EDT by jean-pierre.dijcks

Posted: July 22nd, 2008, 4:59pm EDT by Byte64

Posted: July 22nd, 2008, 4:46pm EDT by (author unknown)

Posted: July 22nd, 2008, 4:10pm EDT by Marco Gralike

Posted: July 22nd, 2008, 3:11pm EDT by Peter O'Brien

Posted: July 22nd, 2008, 3:07pm EDT by Jason Williamson

Posted: July 22nd, 2008, 2:30pm EDT by Venkatakrishnan J

Posted: July 22nd, 2008, 1:50pm EDT

Posted: July 22nd, 2008, 1:27pm EDT by Mark Miller

Posted: July 22nd, 2008, 1:16pm EDT by Jake

Posted: July 22nd, 2008, 1:16pm EDT by Jake

Posted: July 22nd, 2008, 12:44pm EDT by Hector Rivera Madrid

Posted: July 22nd, 2008, 12:33pm EDT by billy.cripe

Posted: July 19th, 2008, 2:49am EDT by Tim...

Posted: July 18th, 2008, 4:08am EDT by Tim...

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT

Fetched: July 17th, 2008, 3:00pm EDT