PL/SQL (MOSC)

MOSC Banner

Why do I get the ORA-13775 error in PL-SQL invoking DBMS_SQLTUNE.LOAD_SQLSET?

in PL/SQL (MOSC) 2 commentsAnswered

Hello everyone.

I want help on Why do I get the ORA-13775 error in PL-SQL when invoking DBMS_SQLTUNE.LOAD_SQLSET?

That is to say,

I have this block of code:

SQL> SET SERVEROUTPUT ON;

SQL> VARIABLE task_id NUMBER;

SQL> VARIABLE workload_name VARCHAR2(255);

SQL> VARIABLE sql_id VARCHAR2(50);

SQL> EXECUTE :workload_name := 'MY_STS_WORKLOAD_J';

PL/SQL procedure completed successfully.

Transcurrido: 00:00:08.36

SQL>

SQL> EXECUTE :sql_id := '&sqlid';

Introduzca un valor para sqlid: 7nqx4mwb0w4n3

PL/SQL procedure completed successfully.

Transcurrido: 00:00:00.01

SQL>

SQL> EXEC DBMS_SQLTUNE.CREATE_SQLSET(:workload_name);

PL/SQL procedure completed successfully.

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