oracle exception handling

Filed Under (Others) by admin on 03-07-2009

Been having  Stored Procedures problems on oracle lately keeps on getting errors, and its really hard to trace, especially when u don’t know where to start. good thing exception handling comes handy on oracle, here’s what I usually do to raise exceptions.

CREATE OR REPLACE PROCEDURE myproc IS
BEGIN
NULL; — do something here insert or update
EXCEPTION
WHEN OTHERS THEN
emesg := SQLERRM;
dbms_output.put_line(emesg);

END;

**************************************************************************************
The code is basic put he EXCEPTION on the end just beofre the end; then put
EXCEPTION
WHEN OTHERS THEN
emesg := SQLERRM;
dbms_output.put_line(emesg);

this means that any instance there is an exception pass the SQLERRM, the sql error message toemesg and print it using dbms_output.put_line

that is you simple and quick exception handing ang prblem tracing

more exception handling techniques available here http://www.psoug.org/reference/exception_handling.html

Eclipse for php developers

Filed Under (Others, php) by admin on 01-07-2009


Eclipse PDT has been available for sometime not the best PHP IDE, maybe the best free PHP IDE, and for some looking for alternative to the pricey dreamweaver eclipse pdt should do the trick

Tools for PHP developers creating Web applications, including PHP Development Tools (PDT), Web Tools Platform, Mylyn and others. More…

download ECLIPSE PDT at http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/galileo/R/eclipse-php-galileo-win32.zip

Eclipse Galileo is here

Filed Under (Others, java) by admin on 01-07-2009

Tagged Under : ,

http://www.eclipse.org/galileo/images/friends.pngEclipse is a popular JAVA IDE,  Eclipse is a fast JAVA IDE (Netbeans is slow), Eclipse has a new version.
And with the tradition of naming their releases with moons, the new version is to be called GALILEO.

From eclipse.org
The new features in the Galileo release reflect three important trends in the Eclipse community: 1) Expanding adoption of Eclipse in the enterprise, 2) innovation of Eclipse modeling technology and 3) advancement of EclipseRT runtime technology. Each project has published “new and noteworthy” documentation for their specific release.

Download eclipse galileo http://www.eclipse.org/downloads/

more at eclipse.org

See how ubuntu name their releases http://itlivewire.com/devblog/?p=43

Firefox 3.5 available for download on wednesday Phil. time

Filed Under (Others) by admin on 29-06-2009

In case you did not get the memo, or for others who might be asking whats new with it, or maybe for who already switched to chrome.

http://cache.gawker.com/assets/images/lifehacker/2009/06/firefox.jpg
It’s releasing and it has big improvements as per Mozilla especially the speed and the mem-hog issue, they have this chrome incognito thing too, tracemonkey the javascript engine, and ohh yeah everybody’s favorite because it’s “new” HTML5

But I wont be expecting a billion downloads this time, especially chrome has been gaining some users already

See the streets on google maps street view

Filed Under (google maps) by admin on 17-06-2009

Tagged Under :

See the streets, have some fun
4050347.jpg (500×375)
http://bit.ly/9HKIi

Im having problems inserting iframes tags on my wp blog, it won’t render, for now just click on the link or the ny street pic.

Yahoo Mail! apps

Filed Under (Others, yahoo mail) by admin on 16-06-2009

Tagged Under :

Yahoo Mail! has a new feature, it can run apps in you inbox, apps like paypal and picnik, these apps are connected to your inbox info, mail, files.

How does it work?
Run apps inside the yahoo mail  web ui,  these apps integrates with you inbox info, on its first run it will ask you if you want to connect your inbox files to the apps like facebook apps,
e.g. picnik, this app can open your inbox picture files mostly photos attached in your mail and you can edit or create directly inside yahoo mail.

Was it any cool?
It’s not, not yet, maybe a cool app will be developed that maximizes the inbox info on your yahoo mail, ahmm I’m thinking of twitter why not, “AGAIN….”, or some kinda timeline tool like plurk timeline, see you inbox message in timeline mode.

Just a caution?
Yahoo mail is a huge MEMHOG in firefox especially when web chat is open, the yahoo web chat uses flash w/c results to super duper memory usage, don’t use a yahoo mail web app with chat open, sign out of chat first.
I dont’t know why memory comsumption is that huge in firefox in IE its not that big though, Yahoo mail on firefox is notoriously slow and hangs much of the time for machines with small memory.
You can always try opening yahoo mail in google chrome.

Tilted Twister

Filed Under (Others) by admin on 11-06-2009

Tagged Under :

Here’s a vid of Tilted twister a lego mindstorm robot that can solve rubiks cube, cute brilliant and cool


more on tilted twister

Facebook presence bar, on other websites

Filed Under (Others) by admin on 11-06-2009

FB’s presence bar is one of the UI feature I loved a lot, its the gray bar at the bottom of the fb page where chat and messages are accessed. Its presence presents quick access, so If I scroll down I dont need to go back up or go down low just to access the usual fb links, or applications like mafia wars, chat and etc. Quick and conveniece gets the job done.

http://www.techdigest.tv/facebook-IM-chat.jpg

This UI feature should only be present on FB, this feature should also be on
1. non panel or framed email apps
2. Web apps with long lists
3. mobile apps, this should be a must.
4. Web pages or apps with big content and many activities.

Thrilla in Search-Ahh : google vs bing

Filed Under (Others) by admin on 02-06-2009

Tagged Under : ,

MS wants to square it out with G, and this search engine battle will always be a classic match for the ages

http://www.btvision.bt.com/wp-content/uploads/2008/09/8632.jpg
The contender MS a.ka Microsoft
http://ts2.images.live.com/images/thumbnail.aspx?q=958635776541&id=e49cae30c46014e682a904c82f42181c
MS the desktop king unable to acquire Yhoo… and with a history of a lousy live.com, did not gave up easily on the search engine arena, received lot punches from consumers lately (vista related), round by round (web, phones, maps, search, UI, mp3 player) they have been the underdog. But it seems that MS is picking up the pace once more with BING.

The champion G a.ka Google
http://www.insideria.com/upload/2008/10/google.jpg
G The reigning pound for pound web and search champion of the world, GOOGLE billions pages indexed, hundreds of thousands of search results for the keywords “beyonce single ladies”, the reigning WBC (Web Based Company ) heavy wieght champion, Praised by many for not being evil, their android ultimately sucks, google maps, mail, and youtube is the best in my opinion.

Ladies and gentlemen let’s get ready too rumbleeeeerrrrrerrrererererer.

Round 1: Search home page

plain and simple                                                 nice graphics what is it for?


Round 2: Search landing page

In my example I used the keyword dwight howard, you will notice the result difference right away D-howard is a b-ball player,

In google the first result is latest new bout D-howard with how many mins the article was posted then nba.com,the wikipedia, there is a search option it will show up a left pane for search filters lets say u want to see d-howard topis on forums, or latest new bout d-howard in the last 24 hours.

In bing the players stats of like his last 3 games, then news, then wikipedia, on the left side we also have the smart filter, d-howard is good on dunks so they also group some search result on d-howards dunks good thing, and there also related searches of similar b-ball superstars like dwyane wade.


Round 2: Auto Suggest

Google - check - results is what you have expected auto suggest kinda lag (ajax thingy)
Bing     - check - same with google results is what you have expected but it’s much faster

BTW for my readers who do not know yet I’m from cebu “bisdak kaayo ko”, So now I tried the keyword “PC express” hoping it would auto suggest

Google - The next word to appear is cebu looks like this “PC express cebu”
Bing     - The next word to appear is manila and will look like this “PC express manila”

I’m not going to comment yet on this if google is more good in local features


Round 3: Did you mean?/Were you looking for?

Google - check - corrects wrong spellings, suggests correct much sound keyword
Bing     - check - same with google, corrects wrong spellings, corrects your keywords and etc.


Round 4: Quick Info

Ahh what’s again the number for HSBC credit card toll free
So I type it in both google and bing “HSBC Phlippines toll free “ then hit space bar hoping it would suggest another word like “number” or “hotline” google suggested number, bing did not append another word. Both of them did not gave me the correct number right away I need to digg down at the 3rd result for bing and 4th for google. Well at least I don’t have go click another page, the complete number is found at the result.

My first example is too local, well that’s the future local information at your fingertips never mind, let just try this one out “NBA finals” current events and a popular search,  I just want a quick info score maybe, schedule, who won in the last game?.

Google’s top result NBA.com:FINALS 2009 they want me to go to nba.com, hoping i might get my quick info on the next click,

Bing on the otherhand is quick enough to hand me an info though, “great left hook” as of this writing the finals has not yet started it somehow showed on top result the final score of the last game that was CLE vs ORL for east finals orl won w/c earned them the right to face LAL for finals (congrats d-howard) and the sched for the next game LAL vs ORL for nba championship game1, that’s quick, and only means that glancing is faster than a click.

Going back to round 2 I typed in pc express google gave me cebu, and google also gave me a map right on top of my result where pc express cebu is located, that’s quick info also so I know where’s the store at is located, “another killer jab” for google’s local feature.

Round 5: Relevance

On search engines relevance is putting the most relevant content on top of your results, For me relevance depends on what you “REALLY WANT TO” achieve in your search, let say “cebu hotels” results should be hotels in cebu, it would be nicer if hotel info such as contact num, accommodations, and prices are present within the results. both G and B did a good job on relevance, both toped Cebu marriot hotel in their results followed by shang and waterfornt, G showed again its power punching local feature, this time showing the cebu hotels in maps i think about 10 of them.

Round 6: Speed, Agility, Brain, and Belly
G - Is quick even with a big stomach - I tried “enterprisedb” Its not referring to database used in the enterprise it’s the commercial version of postgre database,  Results 1 - 10 of about 277,000 for enterprisedb with Safesearch on. (0.05 seconds) , G gave out 277,000 natural for 5 years or so.

B - Is quick also, stomach is not that full maybe bcoz of relevance and not all pages are indexed yet, 1-10 of 59,000,000 results, B gcve out 59,000,000 results in 0.05 seconds.

Round 7: Over all scorecard

G - Is still my preference more indexed pages, hard to find keywords, mature, and local feature, in the future more local restos or events will be searched on the net, I remember someone saying that with internet on the mobile more search will be focused on local. and I like clean boring plain white.

B - If you live in US I think B is a winner, it has indexed lots of US sites already so you get more relevant results for travel, local places, events and business, B focuses on decisions it gives you results you can compare. I still don’t like yet as of now the graphics on the home page it lags when being loaded or I think its the javascripts.

Project natal on xbox is way cool

Filed Under (Others) by admin on 02-06-2009

Way cooler than wii no controls required, you become the controller, cool games so far hope their cheap will they also have an isotre like to download games since this now connects to the web, and also a new way of browsing the web

see the video quick quickfrom gizmodo c/o game trailer
http://cache.gawker.com/assets/images/gizmodo/2009/06/Natal_Intro_Video.jpg

games - check
entertainment - check
internet - check
multiplayer - check
facebook, twitter - check
skype - ?
spotify - ?

It seems microsoft is amazing us this past few weeks first is bing, now xbox

read more at gizmodo http://bit.ly/EPMzL

ads
ads

Jobs at Lexmark Cebu

Software Tools Developer 5 Dec 2008, 7:11 am

Software Tools Developer

Source: Jobs at Lexmark Jobs at Lexmark |

Company Nurse 5 Dec 2008, 7:11 am

Company Nurse

Source: Jobs at Lexmark Jobs at Lexmark |

Industrial Designer 5 Dec 2008, 7:11 am

Industrial Designer

Source: Jobs at Lexmark Jobs at Lexmark |

Data Owner 5 Dec 2008, 7:11 am

Data Owner

Source: Jobs at Lexmark Jobs at Lexmark |

Firmware Product Systems Engineer (FPSE) 5 Dec 2008, 7:11 am

Firmware Product Systems Engineer (FPSE)

Source: Jobs at Lexmark Jobs at Lexmark |

Talent Management Specialist 5 Dec 2008, 7:11 am

Talent Management Specialist

Source: Jobs at Lexmark Jobs at Lexmark |

Business Control Analyst (Auditor) 5 Dec 2008, 7:11 am

Business Control Analyst (Auditor)

Source: Jobs at Lexmark Jobs at Lexmark |

SAP System Analyst 5 Dec 2008, 7:11 am

SAP System Analyst

Source: Jobs at Lexmark Jobs at Lexmark |

Firmware Development Engineers 5 Dec 2008, 7:11 am

Firmware Development Engineers

Source: Jobs at Lexmark Jobs at Lexmark |

HR Officer (Shared Services) 5 Dec 2008, 7:11 am

HR Officer (Shared Services)

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Writers 5 Dec 2008, 7:11 am

Technical Writers

Source: Jobs at Lexmark Jobs at Lexmark |

Spanish-speaking Customer Service Representative 5 Dec 2008, 7:11 am

Spanish-speaking Customer Service Representative

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Illustrator 5 Dec 2008, 7:11 am

Technical Illustrator

Source: Jobs at Lexmark Jobs at Lexmark |

Recruitment Assistant 5 Dec 2008, 7:11 am

Recruitment Assistant

Source: Jobs at Lexmark Jobs at Lexmark |

Team Lead 5 Dec 2008, 7:11 am

Team Lead

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Support Representative 5 Dec 2008, 7:11 am

Technical Support Representative

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Trainer 5 Dec 2008, 7:11 am

Technical Trainer

Source: Jobs at Lexmark Jobs at Lexmark |

Software Build and Library Administrator 5 Dec 2008, 7:11 am

Software Build and Library Administrator

Source: Jobs at Lexmark Jobs at Lexmark |

Business Database Administrator 5 Dec 2008, 7:11 am

Business Database Administrator

Source: Jobs at Lexmark Jobs at Lexmark |

EDI - Support Analyst 5 Dec 2008, 7:11 am

EDI - Support Analyst

Source: Jobs at Lexmark Jobs at Lexmark |