Unanswered: How to Print the value of variable used in Oracle Procedure
I am new for oracle.
I am writing a dynamic query in stored procedure and i am passing a parameter in the query i want to verify the query that how the parameter is getting reflected in the query for that i want to print the query during the execution of procedure.
Please suggest me how to print the query and i am using TOAD.
SQL> set serveroutput on format wrap
2 x varchar2(30) := 'My name is neo.';
5 dbms_output.put_line ('The value of variable "x" is: ['||x||']');
The value of variable "x" is: [My name is neo.]