Home » Developer & Programmer » Reports & Discoverer » Problem in Report Builder (Report Builder 6.0.5.28.0, OS: Windows XP)
icon9.gif  Problem in Report Builder [message #346739] Tue, 09 September 2008 10:04 Go to next message
oracle_user1
Messages: 45
Registered: May 2008
Member
Hi to all,

I have problem when using Oracle Report Builder.


function F_username1FormatTrigger return boolean is
v_usr sv_user.us_usrid%type;
begin
SELECT user INTO v_usr
FROM dual;
srw.set_field_char(0,v_usr);
return (TRUE);
end;

When i wrote above coding then i compile, i got error
PDE-PER0001 Internal error
(REP-3335: Unhandled Internal CA Error.deucx 9 Cool

Hope you all can help me.

regards,
oracleuser
Re: Problem in Report Builder [message #346820 is a reply to message #346739] Tue, 09 September 2008 15:42 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is, actually, "sv_user.us_usrid%type"?

I don't have Reports Builder 6i to test, but - if v_usr variable is set to a VARCHAR2 datatype, this code compiles successfully and report runs well on Reports Builder 10g.
Re: Problem in Report Builder [message #346863 is a reply to message #346820] Tue, 09 September 2008 23:26 Go to previous messageGo to next message
oracle_user1
Messages: 45
Registered: May 2008
Member
Hi littlefoot,

The sv_user.us_usrid%type"
us_usrid is varchar2 and my variable for v_usr also varchar2
(same length)

Thanks.

Regards,
oracle user1
Re: Problem in Report Builder [message #346875 is a reply to message #346863] Tue, 09 September 2008 23:57 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Running the same code on Reports Builder 6i (patch 13) installed on MS Windows XP seems to be fine as well:

./fa/4988/0/

REP-3335 is an abnormal condition; it's been said that
Reports Builder Online Help System
Sometimes you may encounter an error that is known as an abnormal condition, which may arise from one of the following causes:
  • Someone has done something that prevented your application from completing the requested task. For example, if someone bypassed the user interface and changed data in a database table, they might have typed an invalid value.
  • A software bug prevented the requested task from completing.

Action: First contact your system administrator to determine if the message was caused by something other than Oracle Reports. If you determine that the message was not the result of user error or a system problem, then contact Oracle Support Services.
  • Attachment: rep_user.PNG
    (Size: 17.21KB, Downloaded 709 times)
Previous Topic: ORA-01785 ERROR
Next Topic: Print Barcode PDF417 with Report and Form 10g
Goto Forum:
  


Current Time: Fri Dec 09 06:07:45 CST 2016

Total time taken to generate the page: 0.08453 seconds