Recent content by mrniice

Here is what we use in our auditing triggers if you want to get a little fancier and find the osuser and terminal. SELECT UPPER(username), UPPER(osuser), UPPER(terminal), UPPER(machine) INTO v_username,v_osuser,v_terminal,v_machine FROM v$session WHERE audsid in (SELECT...

Has anyone installed OC4J Standalone? Is there a standard directory where it should go? When I unpack the download it places is in the current directory. The other problem that I'm having is that I download the Solaris version, which for some reason is a .zip file, when I unzip the file all...

I have a configuration that includes a public Option 81 that has a TIE card to an Option 11C. The 11C then has a number of TIE cards with spans going into a lab with a number of IVR platforms. I can sit at my desk phone that is connected to the Option 81 and dial 8200008 which will give me a...

Thanks to all so far. One last question I think. When I look at the ACOD it comes out to be 7025 but I actually dial 8025. Why the difference?

So, what information to I take out of the ld 20? >ld 20 REQ: prt TYPE: TRK ... DES TBD_CSU_4 TN 007 15 TYPE TIE CUST 0 TRK DTI PDCA 1 PCML MU NCOS 0 RTMB 86 3 TGAR 0 SIGL EM4 STRI/STRO WNK WNK SUPN YES AST NO IAPG 0 CLS CTD DTN CND ECD WTA LPR APN THFD HKD P10 VNL...

I have an Option 11C that is supplying some spans into my lab where the administration of this thing has now fallen into my lap... How do I print off the information as to what number I have to dial to get a call to go out an a loop? The information that I have is that loops 2&5-9 have...

Try select * from my_table where substr(name,1,3)='JOE';

Has anyone installed OC4J Standalone? Is there a standard directory where it should go? When I unpack the download it places is in the current directory. The other problem that I'm having is that I download the Solaris version, which for some reason is a .zip file, when I unzip the file all...