PL/SQL (MOSC)

MOSC Banner

Perplexed on My PLSQL

edited Jun 10, 2014 4:29PM in PL/SQL (MOSC) 2 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center