I will run some sql scripts to put data in my oracle database.
I found this solution:
Are you a developer who uses NSIS to distribute your application? Are you a Winamp plug-in developer who wants to use NSIS to distribute your plug-in? Have suggestions for other people like you? This is the place.
I use this command to run sqlplus: nsExec::Exec '$0 $2/$3@$1 @$4 '
The values:
$0 "$oradir\BIN\sqlplusw.exe"
$1 = "XE"
$2 = "gpr"
$3 = "gpr"
$4 "$INSTDIR\sql\opvullen_tab.sql"
When I run the nsExec:Exec command, Sqlplus ask me to connect (give up a username, password and hostname). Can I skip that and run the sql command directly?
Is it also posible to run a commando so I can create a user before I run the other sql scripts?