| ORA-16951: Too many bind variables supplied for this SQL statement (merged) [message #676596] |
Fri, 21 June 2019 06:02  |
dba4oracle
Messages: 100
Registered: June 2010
|
Senior Member |
|
|
Hi Guys,
I am running dbms_sqltune for tuning sqlid,most of sqlid i am able to execute with this ,few times i get error ORA-16951 in some of sqlid
below is syntax i used
DECLARE
stmt_task VARCHAR2(64);
BEGIN
stmt_task:=dbms_sqltune.create_tuning_task(sql_id => '1XXXXXXXXXX',
time_limit => 3600,
task_name => 'Tune_name1',
description => 'Task to tune Tune_name1 sql_id');
END;
/
its getting executed and report also coming,but its not giving suggestion but error as below
-------------------------------------------------------------------------------
ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-16951: Too many bind variables supplied for this SQL statement.
-------------------------------------------------------
I checked query only 2 bind variables are used,i successfully run many sqlid with 6 or more bind var also so i rule out this is issue
and i gone through oracle docs,they mentioned to remove bind_list => sql_binds(anydata.convertnumber(100))
but i am not using this parameter in my syntax so this also is ruled out (if it try to use it giving syntax error)
please suggest what could be issue
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
