Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to call stored procedure from Perl
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... -
How to call stored procedure from Perl
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... -
How to call stored procedure from Perl
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... -
Data Structure and Memory
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... -
Data Structure and Memory
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()... -
Data Structure and Memory
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... -
Data Structure and Memory
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... -
Data Structure and Memory
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... -
Removing an element from array
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()... -
Removing an element from array
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... -
Removing an element from array
could anyone please give me more hints about this? thanks lucas -
Removing an element from array
duncdude, In your case, this only deals with those arrys have the same length, right? Thanks, lucas -
Removing an element from array
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 -
Removing an element from array
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"... -
Removing an element from array
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 =... -
Find Dups from Array Itself
Thank you, guys. Both scripts are working great. Lucas -
Find Dups from Array Itself
I really new in Perl. I tried to create a simple script to find the duplicate items in array. Here is my source code: ########################################################### @arry = ("1", "2", "2", "2", "3", "3"); @dups = (); @copiedArry = @arry; $size = @arry; $arryLoc = $size - 1; for... -
Hash of Hashes ( again )
133tcamel, thank you so much for your explaination. Kevin, you bring a very good point -- why your script is using that specific data structure? This is only part of the one scripts. "Hash of Hashes" is used all over the scripts. It is pain in my ass to fully understand the scripts. I need... -
Hash of Hashes ( again )
From the last post, first, thank you for your reponses, but I am still not clear about "hash of hashes". I have one more example here, support, ######################################################### $statement = "select A, B , C from myTable"; if ($db -> Sql($statement)) { # ..doing error...
