Execute immediate in perl script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Execute immediate in perl script
# 1  
Old 04-26-2013
Execute immediate in perl script

hi All,

i have to modify a shell script written in Perl. i have to use execute immediate within this. i have to create a temporary table but it should have name like ar_data_$mmyyyy , how can i achieve this?

any help on this would be highly appriciated.

Last edited by vbe; 04-26-2013 at 05:11 AM.. Reason: typo icodes
# 2  
Old 04-26-2013
Post your code...
# 3  
Old 04-26-2013
its a large script, do you want me to post entire script here?
# 4  
Old 04-26-2013
Can you post that portion of the script..
# 5  
Old 04-26-2013
here is the portion of code where we are referencing a procedure through a package

Code:
 $user=$ENV{CREDIT_LOAD};
    $password=$ENV{CREDIT_PSWD};


        $dbname=$ENV{ORACLE_SID} || mail_abort("ar_portfolio.pl","Environment not setup! no SID");
    $dbh = DBI->connect( 'dbi:Oracle:' . $dbname,$user,$password)  ||
                mail_abort("ar_portfolio.pl","Database connection not made $DBI::errstr");

        $dbh->{PrintError} =0;
        $dbh->{RaiseError} =0;
        $dbh->{AutoCommit} =1;


        IdxCntrl->init($dbname,$user,$password);

        TrxLog::begin("AR Portfolio");

        set_color_pct();
        print "60 green: $pct60_green_limit\n";
        print "60 yellow: $pct60_yellow_limit\n";
        print "120 green: $pct120_green_limit\n";
        print "120 yellow: $pct120_yellow_limit\n";

        $sth = $dbh->prepare("BEGIN ar_portfolio.insert_into_ar_new; END;")or mail_abort("ar_portfolio.pl", "cant prepare: $s
ql\n");


Last edited by Corona688; 04-26-2013 at 12:57 PM..
# 6  
Old 04-26-2013
i didn't find the below one in the above code...
Code:
ar_data_$mmyyyy 

# 7  
Old 04-26-2013
that's the table name which needs to be created through execute immediate, and name should be like that only ar_feed_$mmyyyy
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Perl script with lock to execute only once in a day

Hi, I am new to perl and have a script to which i want to ensure that no matter how many ever times i execute the script it should execute only once per day. Cronjob is not a safe method as I want to built in capability inside the script. (1 Reply)
Discussion started by: ctrld
1 Replies

2. Programming

PERL: In a perl-scripttTrying to execute another perl-script that SETS SOME VARIABLES !

I have reviewed many examples on-line about running another process (either PERL or shell command or a program), but do not find any usefull for my needs way. (Reviewed and not useful the system(), 'back ticks', exec() and open()) I would like to run another PERL-script from first one, not... (1 Reply)
Discussion started by: alex_5161
1 Replies

3. Shell Programming and Scripting

[perl] execute remotely script

Hello Can some help with write part of perl script I need something like this in perl SSH="/bin/ssh -o BatchMode=yes -o" USER="test" SRV="server" SCRIPT_TO_EXEC="/tmp/test.sh" -> shell script OUT=/tmp/out.file ${SSH} -l ${USER} ${SRV} 'sudo /usr/bin/ksh -s' < ${SCRIPT_TO_EXEC} >> ${OUT}... (1 Reply)
Discussion started by: vikus
1 Replies

4. Shell Programming and Scripting

perl script to check read/write/execute permission for 'others'

I want to check access rights permissions not for 'user', not for 'group', but for 'others'. I want to do it by system command in which i want to use 'ls -l' and 'awk' command. I have written the following program : #!/usr/bin/local/perl #include <stdlib.h> system ("ls -l | awk... (1 Reply)
Discussion started by: shubhamsachdeva
1 Replies

5. Programming

CGI Perl script to execute bash script- unable to create folder

Hi I have a bash script which takes parameters sh /tmp/gdg.sh -b BASE-NAME -n 1 -s /source/data -p /dest/data/archive -m ARC gdg.sh will scan the /source/data and will move the contents to /dest/data/archive after passing through some filters. Its working superb from bash I have... (0 Replies)
Discussion started by: rakeshkumar
0 Replies

6. Shell Programming and Scripting

Cannot execute Unix command in a simple perl script

Am trying to lean perl scripting in Unix OS to automate my tasks. Please find the below perl script i have tried #!/usr/bin/perl -w print "Please Enter the VG name to be checked:"; $A = <>; print "Please Enter the free size to be checked in GB:"; $B = <>; $vgcheck = `vgdisplay... (7 Replies)
Discussion started by: jayachandran87
7 Replies

7. Shell Programming and Scripting

Perl Script to execute todays date.

Hi Folks, I have created a script last month to retrive files thru FTP and cronjob was running fine till yesterday. But the naming convention of the daily file is Filename_<date>.xml where date is YYYYMMDD. But today i have received file name as Filename_20110232.xml :( Part of my Perl... (4 Replies)
Discussion started by: Sendhil.Kumaran
4 Replies

8. Shell Programming and Scripting

[Solved] how Execute a Perl Script from any location on the machine

hi guys, i have a query, i wrote a perl script that will collect cpu statistics Scripts/myScripts/ cpu.pl i want to make this file so that i can run it from any location on any drive, without giving the path explicitly. like $/home/ravi/perl cpu.pl i tried this... (8 Replies)
Discussion started by: niteesh_!7
8 Replies

9. UNIX for Dummies Questions & Answers

a cron job needs a perl script to execute

Hello evreyone, this is my first post, and to say i'm new to this is an understatement. I know very little about perl scripts and hope some one can help me. i'm looking to get a script that a cron job can execute. what the script needs to to is 1) connect to a mysql database 2) go to a... (2 Replies)
Discussion started by: Exader
2 Replies

10. Shell Programming and Scripting

execute a ksh script from perl script!

Hi, I have used exec ("/bin/ksh -c /path/file.ksh arg1"); to execute the file.ksh script from a test.pl script. But it doesnt work.. can anyone tell me what exactly the systax should be?... i have tried system("/path/file.ksh arg1"); too....still no luck... quick replies are highly appreciated (1 Reply)
Discussion started by: meghana
1 Replies
Login or Register to Ask a Question