Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Please help .. cannot directly access remote package variable

Sarma12Jun 19 2006 — edited Jun 23 2006
Hi gurus,

I am using Forms 6i and Oracle (database) 9i .. In database, i have created a package speciication (without body) like this

Create package p1 is
var1 varchar2(20);
end;

And I switched on to the forms, now, I have created a block dept .. in which deptno, dname, and loc are fields ..

I have placed push button .. in which, I have written code like
Declare
var2 varhcar2(20);
Begin
var2 := :dept.dname;
p1.var1 (referring package in the database) := var2;
end;

It is displaying an error

Cannot directly access remote package variable or cursor ..

Can anyone suggest me what's the remedy for this

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2006
Added on Jun 19 2006
9 comments
8,051 views