This content has been marked as final. Show 4 replies
That works fine for me (in Oracle 10.1.0.2.0, with SQL*Plus 10.1.0.2.0).
Is the command all on one line? Make sure it is.
Is the command you posted given at the SQL> prompt, or is it part of some PL/SQL code? (Don't say CALL inside PL/SQL.)
Can you call the procedure with fewer arguments, say, just the owner and table name? If so, add the other arguments back, on at a time. Which argument causes it to fail?
Forreging wrote:No, it's fine in SQL*Plus. I was just saying it won't work in PL/SQL.
Dear Frank Kulash,
I run this at the SQL> prompt AND on one line
do you mean this is not allowed to use call directly in SQL*PLUS?
Another way to call it from SQL*Plus is to say EXEC instead of CALL:
What happens when you call it with just 2 arguments?
SQL> EXEC dbms_stats.gather_table_stats(ownname => 'XXXX',tabname => 'XXX_TBL');