User Profile

Collapse

Profile Sidebar

Collapse
sammak168
sammak168
Last Activity: Jan 7 '11, 07:03 AM
Joined: Feb 11 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sammak168
    replied to Perl script that cannot receive respond from Oracle stored procedure
    in Perl
    I tried to set the value of KeepAliveTime in the windows registry and not changed anything in the Perl code/batch file, but it still did not get the return code.

    The system was just transferred to our site. The program logic and system settings were new to us. We tried to keep the changes minimal to the system. And the database server and the application server was in trusted zone and DMZ respectively.

    Is there...
    See more | Go to post

      Leave a comment:

    • sammak168
      replied to Perl script that cannot receive respond from Oracle stored procedure
      in Perl
      Would anyone please give me some idea if I set the value of "KeepAliveT ime" to 300000 in the windows registry "\\HKEY_LOCAL_M ACHINE\SYSTEM\C urrentControlSe t\Ser vices\Tcpip\Par ameters", do I need to specify in my Perl code/bat file to use this feature ? Or I can leave it to the OS to handle ?

      I tried to search for the information in the internet, but could not find any information.

      Thanks in adv...
      See more | Go to post

        Leave a comment:

      • sammak168
        replied to Perl script that cannot receive respond from Oracle stored procedure
        in Perl
        Does anyone have any idea if I set the value of "KeepAliveT ime" to 300000 in the windows registry "\\HKEY_LOCAL_M ACHINE\SYSTEM\C urrentControlSe t\Services\Tcpi p\Parameters", do I need to specify in my Perl code/bat file to use this feature ? Or I can leave it to the OS to handle ?
        See more | Go to post

          Leave a comment:

        • sammak168
          replied to Perl script that cannot receive respond from Oracle stored procedure
          in Perl
          If I set the value of "KeepAliveT ime" to 300000, do I need to specify in my Perl code to use this feature ? Or I can leave it to the OS to handle ?
          See more | Go to post

            Leave a comment:

          • sammak168
            replied to Perl script that cannot receive respond from Oracle stored procedure
            in Perl
            Dear chaarmann,

            I searched the internet and found that a setting of "KeepAliveT ime" under "\\HKEY_LOCAL_M ACHINE\SYSTEM\C urrentControlSe t\Services\Tcpi p\Parameters" in the windows registry may help the issue.

            But it may require the application program to use this setting. May I have more information how to use this setting in batch file (.bat) or the Perl program (.pl) ?
            See more | Go to post

              Leave a comment:

            • sammak168
              started a topic Perl script that cannot receive respond from Oracle stored procedure
              in Perl

              Perl script that cannot receive respond from Oracle stored procedure

              I had a Perl script that called a sql file calling the stored procedure in Oracle database. The stored procedure ran for a long time (more than 1.5 hrs) and did not return the result code to the perl script. (I could see from the job log of the stored procedure that the stored procedure was successfully completed)
              Code:
              my $sql = "sqlplus -s userid/password $jobId";
$rtnCode = system($sql);
              I had other similar...
              See more | Go to post
              Last edited by numberwhun; Feb 11 '10, 03:14 PM. Reason: Please use code tags!
              No activity results to display
              Show More
              Working...