1 Reply Latest reply on Feb 7, 2013 2:07 PM by Jeff Smith Sqldev Pm-Oracle

    SQL developer newbie queries - howto


      I took over my colleague's PC that has installed SQL developer and using it to perform deployment for sql scripts for developers and it is working fine.

      There are already stored procedures created before I took over in the databases under the database / schema in sql developer. Now I want to deploy (create) new store procedure in the existing database / schema by right clicking the procedure title on the left of the sql developer. After clicking the create / key in the name of the procedure name / key in the database / pasted the procedure on the right side of the sql developer and saving it. Till this stage, there is no error but on the left side of the sql developer under the database / schema, I can't find the procedure that I have just created.

      Appreciate any advice and thanks in advance.