apm_load_in_sqlplus

apm_load_in_sqlplus   path

Executes a file in SQL*Plus, returning any output or error.

Source code:

    global env

    set default_pool [ns_config "ns/server/[ns_info server]/db" DefaultPool]
    set user_pass "[ns_config ns/db/pool/$default_pool User]/[ns_config ns/db/pool/$default_pool Password]"

    # Use $ORACLE_HOME in the environment to determine where the sqlplus binary lives.
    if { [catch { return [exec "$env(ORACLE_HOME)/bin/sqlplus" $user_pass "@$path"] } error] } {
	return $error
    }