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
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
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: 21806
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)?
Previous Topic: Oracle OS Combination
Next Topic: Implementation of database vault, VPD & TDE
Goto Forum:
  


Current Time: Thu Mar 28 17:15:28 CDT 2024