Hi Eveyone,
Could you please help us , Oracle Jpublisher is giving error while generating the classes from the command prompt.
At first i created record type in a package and then package body in sql developer like this :
create or replace
package testpack as type My_Rec is record (a number,b number);
procedure testprocedure(e_name table1.empname%type,e_id table1.empid%type,e_sal My_Rec);
end testpack;
create or replace
package body testpack as
procedure testprocedure(e_name table1.empname%type,e_id table1.empid%type,e_sal My_Rec)is
begin
insert into table1 values(e_name,e_id);
end testprocedure;
end testpack;
DECLARE
esal testpack.My_Rec;
BEGIN
esal.a := 1;
esal.b := 2;
testpack.testprocedure(10, 100, esal);
END;
The above is my sample.To create the "My_Rec" related
java class from the command prompt it is giving me the error is "oracle.jpub.JPubException: J2T-116, ERROR: Type or package TESTUSER.TIMEREC was not found in the database" .
i confirmed that in the "testuser" user the package and its type has been created . But from cmd it is not able to find. . Could you please help us if anybody have an idea?