2 Replies Latest reply on Oct 24, 2018 7:48 AM by dhman

    How to create a stored procedure with '&'


      On SQL developer I'm trying to create the following procedure:


      create procedure mytest is

        tmp_test varchar2(2);


        select '&a'

        into tmp_test

        from dual;




      I'm getting prompted to enter a variable. I want the procedure to created like this.

      Can someone help.

      Thanks in advance.