Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22922
ORA-22922 [message #361598] Thu, 27 November 2008 02:39 Go to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
I am trying to save an text file into oracle blob. I am getting following error any one know in what situation this error will come thankQ.


2008-11-27 16:07:05,942 FATAL [org.psa.PortalUtil] - <java.sql.SQLException: ORA-22922: nonexistent LOB value
ORA-06512: at "SYS.DBMS_LOB", line 554
ORA-06512: at "PORTAL.WWSBR_API", line 3396
ORA-06512: at line 1



Re: ORA-22922 [message #361599 is a reply to message #361598] Thu, 27 November 2008 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-22922: nonexistent LOB value
  *Cause:  The LOB value associated with the input locator does not exist.
           The information in the locator does not refer to an existing LOB.
  *Action: Repopulate the locator by issuing a select statement and retry
           the operation.

Regards
Michel
Re: ORA-22922 [message #361604 is a reply to message #361599] Thu, 27 November 2008 03:11 Go to previous messageGo to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
hi,
ThankQ for very quick reply. But i already seen this message in the google. i am not understood what is

Repopulate the locator by issuing a select statement and retry
the operation



What do i need to repopulate?
What is locater?
Where do i use select statement?.

can you please explain me these things.

Thankq
Re: ORA-22922 [message #361613 is a reply to message #361604] Thu, 27 November 2008 03:22 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Show us the code that is causing the problem.
Re: ORA-22922 [message #361617 is a reply to message #361604] Thu, 27 November 2008 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Large Objects

Regards
Michel
Re: ORA-22922 [message #361621 is a reply to message #361613] Thu, 27 November 2008 03:29 Go to previous messageGo to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
Actually i am calling one storedproc from java.


String qualification = "begin ? := portal.wwsbr_api.upload_blob(? , ? , ?); end;";
			String systemDocName = null;
			OracleCallableStatement ocs = null;
			try {
				ocs = (OracleCallableStatement)conn.prepareCall(qualification);
				ocs.registerOutParameter(1, OracleTypes.VARCHAR);
				ocs.setString(2, pFileName);
				ocs.setBLOB(3, blob);
				ocs.setString(4, pMimeType);
				ocs.execute();//Here i am getting   error
				systemDocName = ocs.getString(1);
	
				if (ocs != null) {
					ocs.close();
				}
			} catch (SQLException sql) {
				log.error(sql);
	
				this.log.fatal(sql.toString());
				sql.printStackTrace();
			}



Thankq

[Updated on: Thu, 27 November 2008 03:31]

Report message to a moderator

Re: ORA-22922 [message #361635 is a reply to message #361621] Thu, 27 November 2008 04:00 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Apologies. Ignore my post.

Regards

Raj

[Updated on: Thu, 27 November 2008 04:14]

Report message to a moderator

Previous Topic: I need real examples for Temporary Tables
Next Topic: TO_NUMBER
Goto Forum:
  


Current Time: Mon Dec 05 15:06:44 CST 2016

Total time taken to generate the page: 0.12318 seconds