Shell Programming and Scripting

Hello,

My requirement is based on Oracle where we run a perl script and it asked some questions.I want to write a wrapper which will answer all these questions.

How is it possible.

Thanks

You could try something like this:

Code:

#!/bin/sh

/path/to/oracle/script.pl <<"EOF"
answer1
answer2
answer3
EOF

This I have already tried and it does not work..

In what manner does it "not work". Be specific.

In fact, why not post the perl script?

Basically the answers are passed in the successive manner in 1 go..and the paramter keep telling null has been received...

Please post the perl script so we can see what form of input it needs. If it's simply reading from stdin, that ought to work.

#!/bin/sh

/mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/bin/adbldxml.pl <<EOF
apps
aa
rr
qq
EOF
[oracle@wkdevpr12rac1 bin]$

OUTPUT

Starting context file generation for db tier..
Using JVM from /mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/jre/bin/java to execute java programs..

/mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/jre/bin/java -classpath /mnt/oracle/oracle/product/11.2.0/dbhome_2/jdbc/lib/ojdbc5.jar:/mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/java:/mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/java/xmlparserv2.jar:/mnt/oracle/oracle/product/11.2.0/dbhome_2/jlib/netcfg.jar:/mnt/oracle/oracle/product/11.2.0/dbhome_2/jlib/ldapjclnt11.jar

-user apps
APPS Password:
The log file for this adbldxml session is located at:
/mnt/oracle/oracle/product/11.2.0/dbhome_2/appsutil/log/adbldxml_10031722.log
AC-20010: Error: File - listener.ora could not be found at the location:
/listener.ora
indicated by TNS_ADMIN. Context file can not be generated.

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server:
Enter Valid Input

Enter Hostname of Database server:
Enter Valid Input

Enter Hostname of Database server:
Enter Valid Input


It should have passed aa