Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compile plsql code with @ using sqlplus

Sanjeev ChauhanJan 26 2016 — edited Jan 26 2016

I have the following plsql code in a file, p.sql

create or replace package p

is

  procedure test;

end p;

/

create or replace package body p

as

  procedure test

  is

  begin

    dbms_output.put_line('

      @media

    ');

  end test;

end p;

/

In sqlplus when I try to compile the code, I get, SP2-0310: unable to open file "media.sql". How do I get sqlplus to escape '@'. set define off or set scan off does not work.

SQL> set def off scan off

SQL> @f.sql

Package created.

SP2-0310: unable to open file "media.sql"

Package body created.

SQL>

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2016
Added on Jan 26 2016
7 comments
2,304 views