Ref cursor and dynamic sql are soft parsed every time they are called.

I said post the trace data file not the tkprof output.

Tamil