| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Exception in calling Oracle Storedproc - CLOB input parm |
« View previous topic :: View next topic » |
| Author |
Message
|
| sknrt1 |
 Posted: Tue Jun 21, 2005 1:45 pm Post subject: Exception in calling Oracle Storedproc - CLOB input parm |
 |
|
Apprentice
Joined: 22 Jan 2003
Posts: 39
Location: USA
|
Scenario:
----------
I have a Oracle Stored Procedure, having an input CLOB parameter.
The actual Table Column is not CLOB, its Varchar.
Stored Proc takes the incoming CLOB field and inserts it as char (multiple 4k rows).
I am using PASSTHRU to call the stored proc. It works good in case of passing value to this field. But it fails, if passed NULL or ''(empty string).
Also tried without using PASSTHRU and the same issue.
Is there a way to pass NULL (or '') value, without getting the error below.
something similar to setNull(x, java.sql.Types.Clob) in JAVA, which sets a Database null for CLOB field.
Exception:
-----------
SQLErrorText = '[DataDirect][ODBC Oracle driver][Oracle]ORA-22275: invalid LOB locator specified ORA-06512: at "XXXXX_INSERT", line 157 ORA-06512: at line 1 '
Environment:
--------------
WBIMB v5.0.4
Oracle 9.2.x
AIX
ODBC driver: UKOR818 (DataDirect)
will PASSTHRU work, to call this? (its working when data is passed)
According to the ESQL documentation: in case of calling an external stored proc:
"Parameters cannot map onto the database LOB types (for example, BLOB and CLOB)"
Thanks in Advance |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
