Home » SQL & PL/SQL » SQL & PL/SQL » unable to use dbms_lob.append or writeappend (10g)
unable to use dbms_lob.append or writeappend [message #303997] Mon, 03 March 2008 11:39 Go to next message
sangleweb
Messages: 10
Registered: March 2006
Junior Member
I cannot seems to use the dbms_lob.append nor the writeappend in my PL/SQL script. I am getting the following error:

PL-00222: no function with name "APPEND" exists in this scope

If I try to use writeappend, it says the same "WRITEAPPEN" but substr method seems to compile fine.

Is this has to do with privileges of the method?
Re: unable to use dbms_lob.append or writeappend [message #304003 is a reply to message #303997] Mon, 03 March 2008 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Regards
Michel
Re: unable to use dbms_lob.append or writeappend [message #304029 is a reply to message #303997] Mon, 03 March 2008 15:20 Go to previous message
sangleweb
Messages: 10
Registered: March 2006
Junior Member
Never mind, I've figured it out. The method is a procedure and I was using it as a function.
Previous Topic: Oracle 10g DML error logging
Next Topic: REGEXP_REPLACE: How to replace a list of words to null
Goto Forum:
  


Current Time: Sat Feb 15 08:05:55 CST 2025