Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SP2-0552: Bind variable

user10274093Feb 25 2014 — edited Feb 25 2014

Hi,

I receive this error while running the following :

SQL> DECLARE

  2

  3  VARIABLE v_task  :='TÂCHE_338';

  4

  5  BEGIN

  6    DBMS_SQLPA.execute_analysis_task(

  7      task_name       => :v_task,

  8      execution_type  => 'test execute',

  9      execution_name  => 'after_change');

10  END;

11  /

SP2-0552: Bind variable "V_TASK" not declared.

How should I write that code ?

Thank you.

This post has been answered by Sergei Krasnoslobodtsev on Feb 25 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2014
Added on Feb 25 2014
3 comments
598 views