I am facing problem to to execute .sql command in sql prompt using perl script. I am able to connect sql promt using "
Expand|Select|Wrap|Line Numbers
- my $odbcinput = "odbcinput.txt";
- my $odbcoutput = "odbcoutput.txt";
- open (ODBCSQLFH, ">$odbcinput") || die "Unable to create input file ($odbcinput) for odbcsql\n";
- print ODBCSQLFH "/ade/jareddy_lcm/lcm/sysman/admin/emdrep/sql/lcm/latest/tgt_types/fsn_tgt_types.sql";
- close ODBCSQLFH;
- {
- print ODBCSQLFH "sqlplus sysman/sysman@repos /o $odbcoutput $odbcinput\n";
- system ("sqlplus sysman/sysman\@repos");"
SQL> "@ADE_LCM_ROOT/lcm/sysman/admin/emdrep/sql/lcm/latest/tgt_types/fsn_tgt_types.sql"
using Perl script.
Thanks,
Ram.