• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Jpublisher is giving error while generating the class ? ? ?

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
To get a wish, you need a genie. To get a genie, you need a lamp. To get a lamp, you need a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic