OraFAQ Forum: Client Tools » Unable to open file

Home » Other » Client Tools » Unable to open file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to open file [message #551012]

Sat, 14 April 2012 15:22

Anil09
Messages: 8
Registered: April 2012
Location: Pune

Junior Member

when i run the script file 1.sql
It throws me following error
SQL> @/c/temp/1.sql
SP2-0310: unable to open file "/c/temp/1.sql"
How this is resolved
thank you
Anil Kumar

Report message to a moderator

Re: oracle 10g Express Edition [message #551013 is a reply to message #551012]

Sat, 14 April 2012 15:26

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Not familiar with DOS, eh? Try

SQL> @c:\temp\1.sql

Or, even better, start SQL*Plus from a directory that contains your SQL scripts - it will be much easier for you. For example:

C:\>cd temp

C:\temp>sqlplus scott/tiger

SQL*Plus: Release 11.2.0.2.0 Production on Sub Tra 14 22:26:48 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> @p

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL>

Report message to a moderator

Re: Unable to open file [message #551026]

Sat, 14 April 2012 22:59

Anil09
Messages: 8
Registered: April 2012
Location: Pune

Junior Member

Hi
It throws me following error
SQL> @1
SP2-0042: unknown command " ■c" - rest of line ignored.

Report message to a moderator

Re: Unable to open file [message #551029 is a reply to message #551026]

Sat, 14 April 2012 23:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post content of 1.sql file

Report message to a moderator

Re: Unable to open file [message #551030]

Sat, 14 April 2012 23:13

Anil09
Messages: 8
Registered: April 2012
Location: Pune

Junior Member

Hi All
SQL> ed
Wrote file afiedt.buf

1 create or replace procedure p as
2 x varchar2(12);
3 begin
4 dbms_output.put_line('Message '||x);
5* end;
SQL> /

Procedure created.

SQL> exec p
Message

PL/SQL procedure successfully completed.

Now My problem is solved
thank you again for helping me out of this.
Shocked

Report message to a moderator

Previous Topic:	Help in getting the results correctly
Next Topic:	Schema Broswer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 27 22:12:34 CDT 2023