i want to call a oracle function in my shell script

Shell Programming and Scripting
1

i want to call a oracle function in my shell script

2

run sqlplus

3

Can u please give me an example

4

depending on the exit status of the function i should create a control file. can someone help me with an example script

5

Can you give us some pseudo code (or cleaned up actual code) that we can look at to see what you want exactly?