(not sure if this is the right subforum to ask this)
I have a legacy Oracle Forms Developer program, which at some places in the PL/SQL code calls the HOST command to call SQLPlus and run an external *.sql file with SQL commands in it.
As in:
HOST('sqlplus username/password@database myfile.sql outputfile');
We're not happy with having the password on the command line like this. Is there another way we can execute the code in the 'myfile.sql' file? Can that code be embedded in the PL/SQL code somehow? Or is there a more direct way to run sqlplus?