Forum Stats

  • 3,767,923 Users
  • 2,252,730 Discussions
  • 7,874,381 Comments

Discussions

SQLDeveloper automatically adding "set define off" on "procedure exports"

Alain Leg.
Alain Leg. Member Posts: 4 Red Ribbon

Hi

I'm trying to make the "set define off" line added by SQLDeveloper disappear when I export my procedures, because this line is not part of the output of dbms_metadata.get_ddl('PROCEDURE', 'XXXX', 'MYACCOUNT')...

It may be excluded by a DBMS_METADATA.SET_TRANSFORM_PARAM action, but can't find which one...

Any help will be appreciated.

Thanks.

Alain