• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jpublisher is giving error while generating the class ? ? ?

 
Ramesh Bandari
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic