how to connect to oracle from unix and get the error code in unix

[smitamahadik]

Hi,

I need to connect to oracle from unix , excute a stored procedure and find out the error code if any in unix. Can somebody give detail commands to extract the error code?

[chella]

Hi,

I need to connect to oracle from unix , excute a stored procedure and find out the error code if any in unix. Can somebody give detail commands to extract the error code?

Hi,
We can connect to Oracle from Unix just by giving the command sqlplus at the prompt and log into Oracle using the appropriate username and password.

sqlplus -s userid/password@database
In case you want to connect to SQL database

sqsh -S Servername -U username -P password

In case of SYBASE

isql -S Servername -U username -P password

Regards,
Chella

[smitamahadik]

found out a way to fetech the error code.
Following will connect to oracle from unix and fetch the error code.

sqlplus -S user/psswd@dbname<<EOC>/temp/sql-unix.log
set feedback off
set head off
var rc number;
exec proc_add_daily_range_part('${TNAME}','${RUN_DT}',: rc);
print :rc;
EOC
export error=`sed -e '/^$/d' /temp/sql-unix.log | sed 's/^[ ]*//g'`