I would like create a sqlprofile then have got a problem with ' ' ' error
I would create a sqlprofile to understand the principe :
my sql is :
DECLARE
my_task_name VARCHAR2(30);
my_sqltext CLOB;
BEGIN
my_sqltext := 'select * from v$instance where INSTANCE_NAME='WT9PRD01'';
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_text => my_sqltext,
user_name => 'WT9PRD01',
scope => 'COMPREHENSIVE',
time_limit => 60,
task_name => 'my_sql_tuning_task_3',
description => 'Task to tune a query for test JPS ');
END;
/
>>>>>>>>>>> when I launched my script I have this next :
SQL> @CreateTest.sql
my_sqltext := 'select * from v$instance where INSTANCE_NAME='WT9PRD01'';
*
ERROR at line 5: