Search Results

Ygor,
I have to replace a valid number to RSTART and RLENGTH right?
I tried to run the command it gives me a syntax error/bailing out

thanks

ZB,
I tried your suggestion but it still gives me the whole string, not the ORA-00942 text.

Hi,

Suppose I have the following text in a file.

ORA-00942: table or view does not exist
ORA-01555: snapshot too old: rollback segment number string with name "string"
too small

Is there...

Thanks..
Could you explain what the code do?

Hi,
Is there any function in Unix that could get the Time Differrence of two values? this would be used as statistic for how long a job completes, from start to finish..

Please help.

thanks,...

vino,
thanks! I think I got it now.

i placed your code in test.log file
then type in the commandline.. test.log

vino,
it didn't work.
do i have to replace something in you code?

Thanks for the reply.
Can we make it more flexible? Let say we don't know the 'zekmsam221_0730.log' string but we know that there is always an 'ORA-' after 'zekmsam221_0730.log' string.
Is it still...

Hi All,

I'm a newbie with scripting.
Can you help me on how to get the 'zekmsam221_0730.log' string from this string?

zekmsam221_0730.log:ORA-00942: table or view does not exist

Thanks,
Jet

Thanks for the reply.

What this code do?

v_message=`echo "$Z" | grep "ORA-"`
echo $v_message

Is it possible to assign value to a unix environment variable in .sql file?

Hi,

I have a script that will call a .sql file in unix.
My question is, incase the .sql file encountered an error on execution (e.g. 'ORA-00942: table or view does not exist') is it possible to...