HELIOS BLOG

Helios Database Journey

line 16442

Kasım 30, 2020

There was a problem creating the SQL Profile ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1

I face with that error while try to set SQL Plan on one of my sql. This is the one of he published bug. Bug 10313110 SQL Advisor raises an ORA-13786 when Trying to Implement a Recommended Parallel Profile If I try to use below syntax its also through error message such as: Continue reading

Oracle Database&EBS General

line 16442, line 31, ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", ORA-13786: missing SQL text of statement object, There was a problem creating the SQL Profile ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1