Printable View
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
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...
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? :confused: :confused:
post the codeQuote:
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? :confused: :confused:
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?? :rolleyes: