Hello,
I am new to Oracle development so first I am wondering if there is a good place with some simple how to's on how to create stored procedures? I am looking for the basics at this point for a quick read.
Second, currently have hacked and slashed my way through getting one built. It has 3 in parameters and a sys_refcursor out parameter. That proc works.
I want to have another procedure created that will call the working procedure above and loop through each line of the out parameter and have it write to a file. Can someone point me to an example of this by chance?
Thanks for the help.