OraFAQ Forum: Reports & Discoverer » Problem in Report Builder

Home » Developer & Programmer » Reports & Discoverer » Problem in Report Builder (Report Builder 6.0.5.28.0, OS: Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in Report Builder [message #346739]

Tue, 09 September 2008 10:04

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

Report message to a moderator

Re: Problem in Report Builder [message #346820 is a reply to message #346739]

Tue, 09 September 2008 15:42

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Problem in Report Builder [message #346863 is a reply to message #346820]

Tue, 09 September 2008 23:26

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

Report message to a moderator

Re: Problem in Report Builder [message #346875 is a reply to message #346863]

Tue, 09 September 2008 23:57

Littlefoot
Messages: 21823
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:

/forum/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 2055 times)

Report message to a moderator

Previous Topic:	ORA-01785 ERROR
Next Topic:	Print Barcode PDF417 with Report and Form 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 15:48:48 CST 2025