Recent content by hubud

Tested on Solaris Unix, using perl5.6.1. You'll have to specify the correct location for your perl compiler at the top of the script. Hope this helps someone out. #!/usr/local/perl5.6.1/bin/perl # @(#) Script that checks last 150 session log files for any failures or errors and reports...

Right I follow, so if I drop the array value into another variable prior to the s/// then the array will be left intact. I'll try it tomorrow. cheers simmo

Hi, I've the following snippet of code; foreach my $match (@matchlist) { if ($hndlread =~ /$match/) { $match =~ s/ORA/Oracle based error, see log file for details/; push (@temp, "$space$cause$match"); } } My understanding is...

tried the ";" after the eval and still nothing. The piece of code in the eval block is designed to check the contents of $hndlread for each value in the array @matches, which is declared at the top of the script outside the eval block. So for each value in @matches if it finds that string in...

Still not getting anything. I've made some changes and have found i'm getting the following error Use of uninitialized value in pattern match (m//) at check_session.pl line 90. This refers to the line: eval { $hndlread =~ /(@matches) Also I'm not sure about it being syntax in the eval. I've...

To be honest the codes a whopper, and there are three of them. The relevant bits that check for the updates are as follows: IF UPDATING ('sent_to_gcr_flag') AND :NEW.sent_to_gcr_flag = 'Y' THEN RETURN; END IF; This runs right at the beginning of the main piece of processing. As far as I...

Hi, I have a process that updates a table with three triggers on it. Two of the triggers are row level before update/insert. One is statement level. The two row level triggers have catch code that checks to see if the only field being updated is "sent_flag" and that the value is "Y". If this...

Hi, I've just installed oracle forms 6i on my laptop and run into a few problems. 1) It appears that from the command prompt that sqlplus is pointing to the sqlplus in the new oracle forms home. I have to access sqlplus in the oracle db home to get it running to connect to the db. Is there any...

Hi, Sorry about the load of code below but I though I'd best include as much as I can. The script is peppered with print() commands to troubleshoot and i've found the only part thats not working is when it tries to enter the EVAL block towards the end. If anyone has any ideas much...

So how does the user kick off the session. Via a gui. Do they have to click a button? If this is the case then could you not; 1) Code the oracle app to write a temporary unix file with the users email address. 2)This could be a field in a table that the oracle app can look up and then use...

Actually you can get the username from $USER as well which is a bit easier. If the post session command can't pick up the $USER variable try creating a temporary file with this value which can be read then deleted following the session run cheers simmo

Not sure about 6 but in 5 you can simply choose insert else update in the server manager session. If this doesn't work in 6 then I would choose no cache which performs a normal search of the lkp table each time rather than cache the entire table. Dynamic lookup caching sucks the whole table...

A session from informatica server manager has a post session command that you can email to specific users. However for your example I'm assuming that the session is started by pmcmd command. To do this, in unix solaris, the user through the oracle app will have to log in as a user that has...

Hi, I have a normaliser transformation used to normalise a denormalised record into 7 new records on a staging table. In this way I have the same primary key evt_num with 7 records each with a single piece of denormalised data. e.g. source evt_num, attr_1, attr_2, attr_3,attr_4 target...

I'm looking to do the upgrade exam IZO-030. Can anyone recommend any books that will prepare me for the exam. I'm looking specifically for a single book that will cover the course requirements. Any ideas, cheers simmo