Can anyone give a pointer as to why I cant get a procedure to return several lines of data without getting this error:
OCIFetch: ORA-24374: define not done before fetch or execute and fetch in
I basically do the parse, bind the output variables then execute. I attempt to collect the returned lines in a while(OCIFetch) loop, but keep erroring.
The only theory I have is that it may be because there are multi line returns, as this works fine for a single line return.
Any ideas?
Thanks
Gj
OCIFetch: ORA-24374: define not done before fetch or execute and fetch in
I basically do the parse, bind the output variables then execute. I attempt to collect the returned lines in a while(OCIFetch) loop, but keep erroring.
The only theory I have is that it may be because there are multi line returns, as this works fine for a single line return.
Any ideas?
Thanks
Gj