Home » Other » General » pl/sql unable to open the file
pl/sql unable to open the file [message #583825] Sun, 05 May 2013 05:53 Go to next message
sravani22
Messages: 1
Registered: May 2013
Junior Member
iam using oracle 10g express edition... when i execute a pl/sql program it gives an error " sp2_0310 unable t oopen the file filename.sql" ..
i wrote program in notepad..and saved it in documents ... when i try to execute using the command @filename it gives the above error .. how can solve the problem.. plzz help me... thanks

Report message to a moderator

Re: pl/sql unable to open the file [message #583826 is a reply to message #583825] Sun, 05 May 2013 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ This is not a PL/SQL error but a SQL*Plus one.
2/ Use SQL*Plus and COPY AND PASTE what you do and get
3/ Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel

Report message to a moderator

Re: pl/sql unable to open the file [message #583831 is a reply to message #583826] Sun, 05 May 2013 08:20 Go to previous message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
when i execute a pl/sql program it gives an error

Where did you do that? SQL*Plus? Some GUI (if so, which one)?

Report message to a moderator

Previous Topic: Oracle OS Combination
Next Topic: Implementation of database vault, VPD & TDE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 05 09:01:42 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.