«

Hi Experts,

I have sql interface which connects to oracle database. When I execute
sql, it connects to database and give prompt where user can type sql
statemets to be executed ... some thing like
$
$
$SQL;
SQL>
SQL>
SQL> select * from employee;
........<display the sql result>.......

I wanted to write wrapper script over SQL interface and read a file
having SQL statement and passed it to SQL interface.

Can you please guide me how to start writing this.
Thanks,
VS

vineet <> wrote:
>I have sql interface which connects to oracle database. When I execute
>sql, it connects to database and give prompt where user can type sql
>statemets to be executed ... some thing like
>$
>$
>$SQL;
>SQL>
>SQL>
>SQL> select * from employee;
>.......<display the sql result>.......
>
>I wanted to write wrapper script over SQL interface and read a file
>having SQL statement and passed it to SQL interface.

If you want the Perl program to interact with the external program's STDIO
then one of the "Expect" modules from CPAN is probably the best approach.

If you just want to pass parameters to the external program then system() or
qx// will do that already.

However, maybe you should investigate if accessing the database directly
from your Perl program is the best solution. Again, there are several
modules for database access on CPAN.

jue
>
>Can you please guide me how to start writing this.
>Thanks,
>VS

vineet wrote:
> Hi Experts,
>
> I have sql interface which connects to oracle database. When I execute
> sql, it connects to database and give prompt where user can type sql
> statemets to be executed ... some thing like
> $
> $
> $SQL;
> SQL>
> SQL>
> SQL> select * from employee;
> .......<display the sql result>.......
>
> I wanted to write wrapper script over SQL interface and read a file
> having SQL statement and passed it to SQL interface.
>
> Can you please guide me how to start writing this.
> Thanks,
> VS
would

sqlplus < statement.sql

not do it, where statement.sql is the file containing the SQL statements?

Thanks group for your valuable time and advise.
I was looking some thing like expect
Vineet