Recent content by perln00b

dbms_output_enable $dbh->func('dbms_output_enable'); Enables the DBMS_OUTPUT package. The DBMS_OUTPUT package is typically used to receive trace and informational messages from stored procedures. Thank you very much, LelandJ!! Great appreciated. Since my stored procedure handles all the...

Is this an assignment or homework? This is neither an assignment nor homework. I know how to use Java to handle this. Unfortunately, my environment does not allow me to use Java. I can either use Perl or batch files, but I don't what is the best way to handle this. And I am not familiar...

I created a stored procedure from Oracle9i to deal with some data transactions from DB to DB. I am going to use Perl to handle the following actions: 1) connect to the database 2) call stored procedure 3) catch any messages from DBMS_OUTPUT.print_line() inside my stored procedure. Does...

What databases are you working with? We use Oracle9i. You suggested that I should create a temp table to hold all the incoming data. Locally, I can use a stored procedures to loop through all the data. I have some concerns about the performances of Oracle. Since there are (7-8 millions x...

Andrew, I made a mistake in my post. The source code should like this. $statement = "select studentID, studentName, courseID from student_table"; if ($db -> Sql($statement)) { # ..doing error handling } while ($db -> FetchRow()) { @fields = $db -> Data()...

The code you posted above seems to store a lot of duplicated data. OMG, Andrew, you are great, man!!! I just wonder how you predict the duplicated data without looking at the real codes/database. For real, we HAVE a lot of duplicated data. That's pain in my butt to get rid of those god...

we have about 8 million rows of data load to the memory to do the comparisons. (3 million rows) |--------| |----------| |------------| load to |database| | incoming |load to | Data...

Thank you Trojan and Kevin giving me a good lesson on comparison by using hash. However, I have some concerns about memory and hash. I want to use the same structure showed below to load all my data into hashes, and so I can compare the incoming data before I can insert or update the data...

rharsh, I am appreciated for your help. Now I want to go back to my previous post about hash of hashes. $statement = "select studentID, studentName, courseID from student_table"; if ($db -> Sql($statement)) { # ..doing error handling } while ($db -> FetchRow()) { @fields = $db -> Data()...

rharsh, thank you so much for your help. when you assigned 1 as a value for a hash, can you assign other values as well? Now, suppose, see below ##################################################### @arry = ("peter", "smith", "john", "kelly"); foreach $person (@arry) { $group{$person} = 1...

could anyone please give me more hints about this? thanks lucas

duncdude, In your case, this only deals with those arrys have the same length, right? Thanks, lucas

Trojan, If creating a hash using element in arry1 as keys, how to assign the corresponding values, and how to compare those elements in arry2? Sorry, I am really a noob in perl. Thanks, Lucas

Trojan, I am appricated if you have a chance to show me how to do it. And I did try to use array itself to handle it, but I got "Use of uninitialized value in string/print". Here is my code: ########################################################### @arry1 = ("1", "2", "3"); @arry2 = ("9"...

Support I have two arrays, and each of them doesn't have repeat elements. And compare the first array to the second one, if element repeats in 2nd array, the element has to be removed from the 1st one. i.e. ################################################### @arry1 = ("1", "2", "3"); @arry2 =...