Home » Developer & Programmer » Forms » Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable or cu (FORMS 10g)
Implementation Restriction 'DBMS_LOB.READWRITE' Cannot directly access remote package variable or cu [message #436536] Thu, 24 December 2009 01:22 Go to next message
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


./fa/7219/0/
  • Attachment: error.JPG
    (Size: 32.30KB, Downloaded 1126 times)
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 Go to previous messageGo to next message
sourabh.shukla
Messages: 2
Registered: December 2009
Junior Member
Help needed
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 Go to previous messageGo to next message
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
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 Go to previous message
bellouch
Messages: 5
Registered: December 2009
Junior Member
Use When-Validate-record rather than Pre-Update.

Regards Abder
Previous Topic: Exceptional Error in Post Insert Trigger
Next Topic: Disappearing Tabs on Oracle Forms
Goto Forum:
  


Current Time: Thu Dec 08 01:57:50 CST 2016

Total time taken to generate the page: 0.08249 seconds