archives

Procedure - how to lock some records in table

Hello, I've got an PL/SQL (Oracle) problem. I've got a procedure that logic is to search for clean record (let it be TAKEN=0) that fulfits some kind of criteria. Easy. There is 5 sets of conditions checked one by one to get the record group. When the record is find (if one criteria success - rest of the criterias are

Can't TNSPing XE database

Morning all, I'm having difficulty getting TNSPING to see my local XE database. I'm running oracle XE on Vista business. I can connect to the database fine using SQL Plus and even SQL Developer After installing XE, I installed the Oracle tools for .NET from here ([link]

Oracle 11g Mini-tip: Ordering Trigger Execution

LewisC's An Expert's Guide To Oracle Technology Oracle does not guarantee that multiple triggers on a table will fire in any particular order. Well, they do guarantee some things. For example a BEFORE trigger will fire before an AFTER trigger and ROW triggers fire before STATEMENT triggers. But

RAC and hostnames

We have a customer running our application in a RAC cluster. The application runs on the database server and accesses an oracle database. Our application has the server hostname configured when installed. Customer says that in a failover scenrio that hostname will change. Is this the case? What can I do to ensure that our application runs Ok in failover

Business Cards - some simple tips

I've collected a lot of business cards over the years. I try to keep most of them - even though I now often scan them into my PC when the individual warrants it. However, today I was organizing some of the cards I've collected and I've developed some distinct opinions (who would have thought I'd be opinionated about something) on business cards. If you are looking into getting

process takes a long- BULK COLLECT

The loading process is very slow as optimize are 500000 records and takes 5 hours to insert in another table. and probe with insert / APPEND * * + / <table> into select ... but freezes any suggestions .. Thank you for your assistance CREATE OR REPLACE PROCEDURE SPGT147_CARGARPTRESUMENES ( p_fecha IN VARCHAR2,

vec() in lvalue sub

The subroutine is this: sub mess_with_bits(\$$;$) : lvalue { do { eval { ${$_[0]} = '' }; cluck $@ if $@; } if (!defined ${$_[0]}); my $r = shift; my $p = shift; if (@_) { my $o = vec($$r => $p, 1); vec($$r => $p, 1) = shift; return $o; } vec($$r => $p, 1);

Giving up on Work e-mail - Status Report on Week 26 (K.I.S.S. on Business Processes)

Continuing further with the weekly progress reports on my new mantra of giving up e-mail, as in corporate e-mail, here I am again with another progress report, this time for week 26... ,

Convert to Christianity takes his case to court - Daily News Egypt

Convert to Christianity takes his case to court Daily News Egypt, Egypt - 12 hours ago Hegazy was the first to file such a lawsuit.

Proper way to install module that uses shared libs

Hi All, Does anyone know the proper way to install a Perl module on Linux that loads several shared libraries? For standard libs that comes with Perl, the .so files are in the ${PERL_HOME}/i386-linux-thread -multi/ auto directory. Is this where my libs should go also? I do not want to depend on LD_LIBRARY_PATH if at all possible. Also, what about

FAQ 4.63 Why don't my tied hashes make the defined/exists distinction?

This is an excerpt from the latest version perlfaq4.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

It's Not Rocket Science! The Key to Determining if Your Company Gives Great Service

You can't fix what you don't know is broken. Define the problems. Find the solutions. Do this all over again in 3-6 months to see if anything is different.

Re: Perl - Statistics and AI

Dag meneer, If you're not a troll it would be nice if you yourself started talking about something instead of complaining, that the perl group doesn't discuss your topics. Did you implement anything in perl, which is more then the drops in the ocean that this group is normally talking about? Or did you implement in another language and you would be curious to see