Error running oracle report

[mooks]

Hi All

I have encountered the following error when I tried to run the test.rdf report from the demostrations. Has anyone encountered this error? Please help, thanks.


SQL-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PORTAL.WWV_RW_USR", line 444
ORA-06512: at "PORTAL.WWV_RW_USR", line 921
ORA-06512: at line 1

[Srinivas_Sharma]

check ur variables width if any u r using,

one gets this msg if u have assigned a variable varchar2(10) and pass in more characters into that variable...

[mooks]

I did not assign any variable width to it. It was runnign fine until I commented the destination and security tag in my rep_server.conf file. I did undo all teh changes, but it doesn't work now even after a reboot of my server. I am not too sure if that is the cause of it. Any more hints please?

[stmontgo]

Originally posted by mooks
I did not assign any variable width to it. It was runnign fine until I commented the destination and security tag in my rep_server.conf file. I did undo all teh changes, but it doesn't work now even after a reboot of my server. I am not too sure if that is the cause of it. Any more hints please?

post the code

[mooks]

I uncommented the following codes in rep_server.conf :

<security id="rwSec" class="oracle.reports.server.RWSecurity">
<!--property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->
<property name="oidEntity" value="reportsApp_testdb.oracle.com_D8F1A42517CD767CE030A8C03F0060FB"/>
</security>

<destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<!-- <property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/ -->
</destination>


But I corrected it as the original codes. Any advices??