Can we call a stored procedure from a unix script which is run
using command task
Answer Posted / prabhu
Yes.we can.Use sqlplus -s command in unix to connect to
oracle from unix.Then we can execute the stored proc.
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What's the layout of parameter file (what does a parameter file contain?)?
Explain the types of transformations?
Why do we need informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
How do we call shell scripts from informatica?
What are the different types of olap? Give an example?
What are the tasks that can be performed using sq?
What are the data movement modes in informatica?
How might you approve all mappings in the archive all the while?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Tell me about MD5 functions in informatica
What is a filter transformation and why it is an active one?
What is a difference between complete, stop and abort?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain the pipeline partition with real time example?