
July 1st, 2004, 02:56 PM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 9
Time spent in forums: 2 m 39 sec
Reputation Power: 0
|
|
|
Inserting Clob Datatypes Within Packages
I am currently passing a Clob DataType to a stored procedure
contained in a package. I am running Oracle 10g. Currently I am trying this method which is not working
procedure INSERTINTONARRATIVE(p_FIELD in varchar2, P_Field IN VARCHAR2, P_CLOB in clob, p_Field in Varchar2)
IS
l_clob CLOB;
BEGIN
INSERT INTO SomeTable (AField,BField,CLOBFIELD,CFIELD )
VALUES
( p_Field,P_Field,empty_clob(),PField )
returning CLOBFIELD into l_clob;
dbms_lob.write( l_CLob, 1, length(p_CLOB),p_CLOB );
Does anybody know what I am doing Wrong. The error I receive is ora-22275.
Any Help would be greatly appreciated.
|