OraFAQ Forum: Forms » Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable or cu

Home » Developer & Programmer » Forms » Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable or cu (FORMS 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable or cu [message #436536]

Thu, 24 December 2009 01:22

sourabh.shukla
Messages: 2
Registered: December 2009

Junior Member

Hello,

I need urgent help in implementing DBMS_LOB package.

I need to write data in LOB object using DBMS_LOB object

following code is written in PRE-UPDATE Trigger for the block CTX
on the form i have taken Clob_Desc_f as non database field of type CHAR(26000)
After querying the data I change Clob_Desc_f and enter the new data when saved it shoud empty the lob field based on the key value with empty lob
and then write the data into lob

DECLARE
w_Description_Clob CLOB;

BEGIN
/*
Here Clob_Desc is the lob field in table cxt
*/

UPDATE Cxt
SET Clob_Desc = Empty_Clob()
WHERE Cxt.Key_Field = :Cxt.Key_Field RETURNING Clob_Desc INTO
w_Description_Clob;

Dbms_Lob.OPEN(w_Description_Clob, Dbms_Lob.Lob_Readwrite);

Dbms_Lob.WRITE(w_Description_Clob
,Length(:Cxt.Clob_Desc_f)
,1
,:Cxt.Clob_Desc_f
);

Dbms_Lob.CLOSE(w_Description_Clob);

END;

The above code gives error saying
1] RETURNING clause is not supported in client-side program.
2] For the statement
Dbms_Lob.OPEN(w_Description_Clob, Dbms_Lob.Lob_Readwrite);
gives error as " Implementation Restriction Dbms_Lob.Lob_Readwrite : Cannot directly access remote package variable.
"

How can I use this
Dbms_Lob.OPEN

Thanks in advance.

Regards,
Sourabh

/forum/fa/7219/0/

Attachment: error.JPG
(Size: 32.30KB, Downloaded 2543 times)

Report message to a moderator

Re: Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable o [message #436780 is a reply to message #436536]

Mon, 28 December 2009 05:03

sourabh.shukla
Messages: 2
Registered: December 2009

Junior Member

Help needed

Report message to a moderator

Re: Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable o [message #437066 is a reply to message #436536]

Wed, 30 December 2009 19:12

bellouch
Messages: 5
Registered: December 2009

Junior Member

Add Clob_Desc to your block CTX. Add the following code to your trigger:

begin
	:Cxt.Clob_Desc := :Cxt.Clob_Desc_f;
end;

Regards Abder

Report message to a moderator

Re: Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable o [message #437067 is a reply to message #437066]

Wed, 30 December 2009 19:42

bellouch
Messages: 5
Registered: December 2009

Junior Member

Use When-Validate-record rather than Pre-Update.

Regards Abder

Report message to a moderator

Previous Topic:	Exceptional Error in Post Insert Trigger
Next Topic:	Disappearing Tabs on Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:18:39 CDT 2024