Oracle Report Error (string buffer too small) in Portal

Advertisement

Hi,
I have registered an oracle report (.rdf) with portal which works fine outside in Reports Builder, but when I try to run it in Portal it keeps throwing this error:
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 923
ORA-06512: at line 1
Anyone know what needs to be done to fix this?
Thanks

Advertisement

Sean:
Thank you very much for wading through my post.
>"if (NIerror = DAQmxCfgInputBuffer(h, numSamples*4))"
>I would leave this line out. DAQmx should create an input buffer automatically
>based on the number of channels and number of samples per channel.
Yeah- I put that in trying to fix the problem. The error message doesn't say *which* buffer is too small
>If you just call the DAQmxReadDigitalLines() function with "numSampsPerChan" set to -1,
>DAQmx will wait until all samples are acquired before performing the read.
I'm trying to avoid the wait. That's why I'm trying to figure out how many samples are ready.
I suppose I can try numSampsPerChan=-1, set a short timeout and check for the timeout error.
>If this does not help, please send me a small section of code that reproduces that behavior,
>and I will try running it on my machine.
I will try modifying one of the examples to do what I'm trying to do.
Again, Thank you!
John Weeks
WaveMetrics, Inc.
Phone (503) 620-3001
Fax (503) 620-6754
www.wavemetrics.com

October 11, 2015

Oracle Report Error (string buffer too small) in Portal

Hi, I have registered an oracle report (.rdf) with portal which works fine outside in Reports Builder, but when I try to run it in Portal it keeps throwing this error: SQL-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too s

PL/SQL: numeric or value error (character string buffer too small)

Hi All, Below is the procedure used to send notifications. It was working fine in previous DB version :- 10.1.0.5.0 and there was recent upgrade to 11.2.0.2.0. I complies fine, but when executing it throws the error. PROCEDURE PROC_STATUS_MAIL_UNADJ

"Character String Buffer too small" Classic Report Apex 3.2.1

Hello Everyone, I know it is very old version I am discussing here but that is what we have in our environment, would really appreciate if anyone can help out. I have a classic report with the below query, in this I have added a filter using a select

"Character string buffer too small" in translated application

Recently upgraded to Apex 3.1 After translating an aplications to arabic something strange happened! ALL the report regions are showing error: ORA-06502: PL/SQL: خطأ رقمي أو قيمة: character string buffer too small I have not experienced this in 3.01

Character string buffer too small problem

hi, guys: I have a question that may be silly, I got error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" when I run a query. if I uncomment "and rox.status='Active'" condition, I do not have the error.

ORA – 06512: Character String Buffer Too Small.

hi.. when i'm call the Stored Procedure from php i'm getting this error ORA – 06512: Character String Buffer Too Small. but its working fine via pl/sql block in sqlplus CREATE OR REPLACE procedure sp_RecurringDetails(v_p in out pmxpackage.gen ,v_pmCo

ORA-06502: numeric or value error: character string buffer too small

I have a stored proc with a parameter pio_med_rec_nbr patient.med_rec_nbr%TYPE where patient.med_rec_nbr is a varchar2(12) . character set is we8mswin1252 semantics are bytes the stored proc retrieves max(med_rec_nbr) into nTmp( number) from a refere

String buffer too small

In order to get they layout of the report the way the end user wanted it (basically embedded tables), I created a function that generates an html table and just call that function during the main report query. For example: select col1, col2, col3,   

ORA-06502: PL/SQL :character string buffer too small

Dear Sir, Hi, in htmldb I am trying to create package body, but when I select the package name which I already have the specification part for it, and click next I got this error. what should I do please help thanksWhat do you mean "execute the packa

ORA- 06502: PL/SQL: numeric or value error: character string buffer too sma

Hi Everybody, Please, I Need of Your Help. We have a table with the following characteristics: PS_NAMES ( EMPLID VARCHAR2(33), NAME VARCHAR2(150), ... ) In this table a Trigger exists... CREATE OR REPLACE TRIGGER TG_NAMES BEFORE UPDATE ON PS_NAMES RE

"buffer too small for string or missing null byte" inserting CR in excel

I have created a Crystal Report based on below stored procedure. DELIMITER $$ DROP PROCEDURE IF EXISTS `ww_test`.`PRD_Data_sp` $$ CREATE PROCEDURE `ww_test`.`PRD_Data_sp` (in cyear int, in cmonth int, in groupby varchar(20), in Inv_type varchar(4)) B

Error "roll area too small"! Can't find a way to resolve!Please hep.

Hello everyone:        i am getting the error "roll area too small" when I am looping through an internal table and calling the code below on change of some value. === CALL FUNCTION 'GET_PRINT_PARAMETERS'       EXPORTING         authority       

Oracle Report Error:

Good morning, All: I am having to do a quick turn and burn on the use of the Oracle Report Bulder 10g with no prior experience. I am a Crystal Reports and somewhat Cosnos user. I have found the Oracle Report Builder to be pretty easy application to l

Report error: ORA-02020: too many database links in use

I am getting error ORA-02020 in a report that works exactly the same in other APEX instance. The query refers several tables from Oracle Financials with a single database link. The weird thing is that for some parameters the report shows the expected

XL Reporter error "STRING 8005 NOT FOUND"

Dear all, We have installed XL Reporter 6.80.01.29 on a computer with office 2007 and everything worked well. However, we have installed it on an office 2000 computer and we get an error when we try to launch it: "STRING 8005 NOT FOUND" Variable

PL/SQL numeric error:character buffer string too small

I am always getting this error message when I first try to run my package. But this always happen on the first time. When I then try to run it for second time, no problem. So it can't be due to syntax or logic. Could it be due to package state?How ar

Error in multi-select LOV in Portal Report parameter

Hi, I have a Report from SQL Query that currently has a combo-box parameter that's linked to an LOV. Now the client requires for this parameter to be a multiple select instead of a combo box. I changed the LOV display to multiple select in Customizat

Error: ORA-06502: PL/SQL: numeric or value error: host bind array too small

Hello, I am getting this error when i am trying to execute a PL/SQL script using an Oracle API We are using Oracle 10g release 2 database. I am getting this error only on some instances. This script is running fine in Development instances. Script: S

Large XML Publisher reports fail with client-error-request-value-too-long

We are running BI Publisher 5.6.3 with Oracle Applications 11.5.10.2 (ATG.H RUP 5), and are having frequent failures with client-error-request-value-too-long messages on large PDF reports that cause the entire report to not print. The exact error mes

Gettting error while trying to upload an xml in oracle report builder11g

REP-0069: An internal error occured. JDBCPDS-62008 : java.lang.NullPointerException This is the error m getting while trying to upload an xml with the option Open an existing report in Oracle Forms and Reports 11g An xml to be uploaded is as follows