Hi,
I want to execute plsql codes from perl script without using the DBI module.
I am abale to connect to Sql.But not able to execute any query
$user= "scott";
$pwd="tiger";
$database = "perltest";
system ("sqlplus $user/$pwd\@$database ");
This is my code I am using to connect.
Could anybode suggest me any way to execute plsql blocks
itzaps
Last Activity: Nov 2 '07, 08:40 AM
Joined: Sep 21 '07
Location:
-
Hi,
Thank you very much for your reply..
I am very new to perl scripting so didn't having much idea about the hash.
Could you please give a detail about the code.
I have tried the program in another way this time it is working fine
[code=perl]
#!/usr/bin/perl
$APPLI_LOG_SHL_ DIR ='none';
$JOB_ID = 'none';
$LOG_MSG = 'none';
$tmp ='none';
$ENV{'PATH'} = 'C:\shared\IQA\ appli.env';... -
Perl Script Problem
Hi,
I want to write a perl script that will take value from an external file
the file will be in name=value format and write those values to another file
My problem is I am not able to select variables from the file randomly.
My program is always reading the value line by line.
The program so far I tried
[code=perl]
$ENV{'PATH'} = 'C:\shared\IQA\ appli.env';
open(ENV,"$ENV{ PATH}")... -
I tried printing the 1st character like
[code=perl]
$fname = "C:\shared\IQA\ appli.env";
open(FILE,$fnam e) || die "cannot open File: $!";
$answer=<FILE>;
chomp($answer);
print $answer;
close(FILE);
[/code]
But it is giving output as $name=value where i want the value only...Leave a comment:
-
Perl Script Problem
I am writing one perl script which will take value from an external file and then append the value to another file.
The external file will be in the format like
$name=value;
$name1=value1;
and so on.
The file may contain several variables like this.
My problem is how to get these variable values and append those values to another file using a perl script.
Can anybody help me? I am stuck.
No activity results to display
Leave a comment: