Please help .. cannot directly access remote package variable
Sarma12Jun 19 2006 — edited Jun 23 2006Hi 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