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

    How to create a stored procedure with '&'

    dhman

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

       

      create procedure mytest is

        tmp_test varchar2(2);

      begin

        select '&a'

        into tmp_test

        from dual;

      end;

      /

       

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

      Can someone help.

      Thanks in advance.