Perplexed on My PLSQL
Hi Folks
Regarding DBMS_STATS.get_column_stats
I have been trying to figure out what is wrong with my code and do not see the issue regarding the difference between the code that runs fine and the code that errors out.
When I put the code on one line it runs just fine but when i break it up into seperate lines it errors out
I know it must be something simple, but I can't see the problem
Any assistance is appreciated
DECLARE
n_distcnt NUMBER;
n_density NUMBER;
n_nullcnt NUMBER;
rec_srec DBMS_STATS.statrec;
datevals DBMS_STATS.DATEARRAY;