Search Results

Friends,

I'm trying to do below in ksh script, while requesting user to provide src_db and dest_db values
1. Extract src_db and dest_db Oracle home from oratab file
2. Don't find db if it starts...

Don and Durdent .. thank you for those inputs and appreciate your replies, it help to solve my problem, also yes last line was misspell.. :)

I have a large file and many lines are duplicated. I'm trying to delete lines with every second occurrence of a pattern. Did tried searching similar question but no luck.


I can delete all...

Thanks cero... user has OS authentication so it can login without password.

I have a SELECT query which I need to put in a package (procedure or function) so other can use it. Query accepts some...

rbatte1, yes $1-4 are just example I showed of what will be runtime parameter will look like... I don't use them in actual script... yes script gets run like
my_script 10 30 50 20150114

problem...

Friends,
I pass some runtime arguments (date, number) through ksh script to Oracle procedure, use input value and pass it on to procedure.

Oracle procedure gets input value, run query and logs...

How to close this thread??

I plan to run procedure manually after db connection.

Jim,

I have got package created in the database which has got couple of procedures.
I'm using ksh shell script to login into database and call that store procedure which runs some "Alter...

Friends,

I'm newbie with ksh so wanting some help....

1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute...