Search Results

Hi.

Did you mean:

jeffvar=`ls -tr *jhxxxxx* | tail -1`
with almost-impossible-to-tell-the-difference-backticks?

Nicer on the eye is

jeffvar=$(ls -tr *jhxxxxx* | tail -1)

UTL_FILE won't work if his database is running on a different machine than his shell script.

Try this.

$ cat use_oracle_proc.ksh
#!/bin/ksh

run_sql()
{
$ORACLE_HOME/bin/sqlplus -S...

Hi

i want to call a oracle stored procedure from unix (using bash shell).

consider this is my oracle stored procedure with parameter

create procedure testproc(name IN varchar, age IN...