I have multiple datawindows that call Oracle stored procedures. Each procedure returns only ONE result set. I'm finding in datawindow they do NOT like datatypes of NUMBER or LONG. I've been changing them to Decimal(0) yet I can't really say that's fixing it in all cases.
I get errors like this in the deployed app.
(where can I find that model?)
In PB, if I create a datawindow from a stored procs, it still creates datatypes of NUMBER and LONG.
I can't find any info on this. Any ideas/recommendations?
Thanks in advance
Jay