Home » SQL & PL/SQL » SQL & PL/SQL » Ora-22289 ,ora-22288 using demo mail (merged) (oracle 10g)
Ora-22289 ,ora-22288 using demo mail (merged) [message #483677] Wed, 24 November 2010 02:53 Go to next message
TAHIRJADI
Messages: 16
Registered: September 2010
Location: KARACHI
Junior Member

Dear Sir/Medom,
i am trying my best but raised attached error .Related package is attached. kindly help me and resolve it.
Best Regards.
Tahir
Re: Ora-22289 ,ora-22288 using demo mail [message #483679 is a reply to message #483677] Wed, 24 November 2010 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing is attached.
Do NOT attach something post it inline as some of us can't or don't want to download files.

Use SQL*Plus and copy and paste your session, the WHOLE session including package creation.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
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" button to verify.
Also always post your Oracle version, with 4 decimals.

ORA-22289: cannot perform %s operation on an unopened file or LOB
 *Cause: The file or LOB is not open for the required operation to be
 performed.
 *Action: Precede the current operation with a successful open operation
          on the file or LOB.

ORA-22288: file or LOB operation %s failed\n%s
 *Cause: The operation attempted on the file or LOB failed.
 *Action: See the next error message in the error stack for more detailed
          information.  Also, verify that the file or LOB exists and that
          the necessary privileges are set for the specified operation. If
          the error still persists, report the error to the DBA.

Regards
Michel

[Updated on: Wed, 24 November 2010 03:00]

Report message to a moderator

Demo Mail Error ora-22289 ora-22288 ora-06512 [message #483716 is a reply to message #483677] Wed, 24 November 2010 04:30 Go to previous messageGo to next message
TAHIRJADI
Messages: 16
Registered: September 2010
Location: KARACHI
Junior Member

Dear Sir/Modem,
i am trying my best but raised attached error .Please look is it.
problem is PACKAGE BODY demo_mail.i think problem is (DBMS.fileclose(fil)Wink.
kindly help me and resolve it.
Best Regards.
Tahir
  • Attachment: demo_mail.pck
    (Size: 16.22KB, Downloaded 952 times)
Re: Demo Mail Error ora-22289 ora-22288 ora-06512 [message #483722 is a reply to message #483716] Wed, 24 November 2010 04:42 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't post new topics for same question
Re: Demo Mail Error ora-22289 ora-22288 ora-06512 [message #483724 is a reply to message #483716] Wed, 24 November 2010 04:46 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do NOT attach something post it inline as some of us can't or don't want to download files.


Quote:
Use SQL*Plus and copy and paste your session, the WHOLE session including package creation.


Kindly post what I requested. Wink

Regards
Michel

Previous Topic: Any function which can solve this kind of problem.
Next Topic: A query with LOB's requires OCI8 mode, but OCI7 mode is used.
Goto Forum:
  


Current Time: Thu Sep 19 13:02:11 CDT 2024