Forum Stats

  • 3,768,181 Users
  • 2,252,755 Discussions
  • 7,874,485 Comments

Discussions

procedure access from one schema to another

User_ISH63
User_ISH63 Member Posts: 50 Blue Ribbon
edited Aug 12, 2013 5:17AM in SQL & PL/SQL

Dear All,

      I have created one procedure in SCOTT schema. just i need to see that same procedure information to TEST schema. how its possible.

if im using SELECT DBMS_METADATA.GET_DDL('PROCEDURE','PROC_NAME','SCOTT') FROM DUAL in scott schema mean i can see that full procedure information,

like wise i need to see in TEST schema mean what command i need to use.

Thanks ALL...

«1

Answers

This discussion has been closed.