Bhayya Evarina Perl Mida Work Chesthunara

[ronitreddy]

chilaka doubt ento adugu

Do you work on Unix?

[koncham2]

ledu

 

:police:  puncha icharu gaa.. meeru cheppina cmds, google thalli toh thelusukunna

 

anyway gud to learn new, for me  ()>>

sHa_clap4

[compose]

ledhu bhayya nenu plsql scripts ni execute cheyali ivi execute cheyadaniki second proc undhi adi connection open chesi execute chesthadi, nenu rase script lo ade database nundi oka process id techukuntunna dbh open chesi

i am thinking second proc is a child/forked from a parent proc....so fork chesinappudu sariga fork avvutunnatu ledu

[compose]

Do you work on Unix?

ledu kani school lo nerchukunna

[chilakottudu]

i am thinking second proc is a child/forked from a parent proc....so fork chesinappudu sariga fork avvutunnatu ledu

ledhu bhayya second script fork cheyadam ledhu rendu veru veru db connections

[compose]

ledhu bhayya second script fork cheyadam ledhu rendu veru veru db connections

so basically child process complete aye varaku parent process wait cheyadam ledu and somewhere in between aa child process status carry avvadam ledu... anduke no child process ani vastundi when you are trying to query for the status of child process

[ronitreddy]

ledu kani school lo nerchukunna

scripting baga ocha mari?

[compose]

scripting baga ocha mari?

yes vachu :)

[ronitreddy]

yes vachu :)

mari naku oka unix script lo help cheyochu gaa..

[compose]

mari naku oka unix script lo help cheyochu gaa..

cheppu try chesthanu... bash ,csh or sh aa?

[chilakottudu]

so basically child process complete aye varaku parent process wait cheyadam ledu and somewhere in between aa child process status carry avvadam ledu... anduke no child process ani vastundi when you are trying to query for the status of child process

exactly bhayya em cheyalo ardam kavadam ledhu

[compose]

exactly bhayya em cheyalo ardam kavadam ledhu

hmmm script kani script pics kani share cheyagalava mari?

[chilakottudu]

hmmm script kani script pics kani share cheyagalava mari?

bhayya meku cal cheyocha

[chilakottudu]

hmmm script kani script pics kani share cheyagalava mari?

my $dbh2 = DBI->connect( 'dbi:Oracle:', $cogs_ora_user, $cogs_ora_user_pwd)

         or die( 'Oracle connect, using user , error:' . $DBI::errstr . "\n" );

    my $sql = qq/select PROCESS_SEQ.nextval from dual/;

    my $sth2 = $dbh2->prepare($sql);

    $sth2->execute();

    my $id = $sth2->fetchrow_array();

    $sth2->finish();

    $dbh2->{InactiveDestroy} = 1;

    $dbh2->disconnect

    or warn "Disconnection failed: $DBI::errstr\n";

    ##$dbh2->{InactiveDestroy} = 1;

    return $id;

 

first script lo ila rasa bhayya

[compose]

my $dbh2 = DBI->connect( 'dbi:Oracle:', $cogs_ora_user, $cogs_ora_user_pwd)
or die( 'Oracle connect, using user , error:' . $DBI::errstr . "\n" );
my $sql = qq/select PROCESS_SEQ.nextval from dual/;
my $sth2 = $dbh2->prepare($sql);
$sth2->execute();
my $id = $sth2->fetchrow_array();
$sth2->finish();
$dbh2->{InactiveDestroy} = 1;
$dbh2->disconnect
or warn "Disconnection failed: $DBI::errstr\n";
##$dbh2->{InactiveDestroy} = 1;
return $id;

first script lo ila rasa bhayya

error vastundi ee script lone na?