OraFAQ Forum: Reports & Discoverer » what is the maximum size of parameter that we can pass thro URL .......

Home » Developer & Programmer » Reports & Discoverer » what is the maximum size of parameter that we can pass thro URL .......

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

what is the maximum size of parameter that we can pass thro URL ....... [message #160327]

Fri, 24 February 2006 08:05

sam_dinesh
Messages: 18
Registered: February 2006
Location: india

Junior Member

what is the maximum size of parameter that we can pass thro URL .......

I am calling one report(Oracle 10g report) from a stored procedure........

when i am trying to pass more than 50 parameters in one procedure thro SRW.ADD_PARAMETER_LIST, i am getting the error

the procedure which i have written

CREATE OR REPLACE PROCEDURE P1 AS
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
myStatus SRW.STATUS_RECORD;
BEGIN
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
SRW.add_parameter(myPlist,'GATEWAY','server_name/reports/rwservlet');
SRW.add_parameter(myPlist,'REPORT','narr_2.jsp');
SRW.add_parameter(myPlist,'USERID','sapreport/sapreport@oracleas');
SRW.add_parameter(myPlist,'DESTYPE','file');
SRW.add_parameter(myPlist,'DESFORMAT','pdf');
SRW.add_parameter(myPlist,'DESNAME','d:\jub1.pdf');
SRW.add_parameter(myPlist,'c_1','111');
SRW.add_parameter(myPlist,'c_v1','111');
SRW.add_parameter(myPlist,'c_2','111');
SRW.add_parameter(myPlist,'c_v2','111');
SRW.add_parameter(myPlist,'c_3','111');
SRW.add_parameter(myPlist,'c_v3','111');
SRW.add_parameter(myPlist,'c_4','111');
SRW.add_parameter(myPlist,'c_v4','111');
SRW.add_parameter(myPlist,'c_5','111');
SRW.add_parameter(myPlist,'c_6','111');
SRW.add_parameter(myPlist,'c_v6','111');
SRW.add_parameter(myPlist,'c_7','111');
SRW.add_parameter(myPlist,'c_v7','111');
SRW.add_parameter(myPlist,'c_8','111');
SRW.add_parameter(myPlist,'c_v8','111');
SRW.add_parameter(myPlist,'c_9','111');
SRW.add_parameter(myPlist,'c_v9','111');
SRW.add_parameter(myPlist,'c_10','111');
SRW.add_parameter(myPlist,'c_v10','111');
SRW.add_parameter(myPlist,'c_11','111');
SRW.add_parameter(myPlist,'c_v11','111');
SRW.add_parameter(myPlist,'c_12','111');
SRW.add_parameter(myPlist,'c_v12','111');
SRW.add_parameter(myPlist,'c_13','111');
SRW.add_parameter(myPlist,'c_v13','111');
SRW.add_parameter(myPlist,'c_14','111');
SRW.add_parameter(myPlist,'c_v14','111');
SRW.add_parameter(myPlist,'c_15','111');
SRW.add_parameter(myPlist,'c_v15','111');
SRW.add_parameter(myPlist,'c_16','111');
SRW.add_parameter(myPlist,'c_v16','111');
SRW.add_parameter(myPlist,'c_17','111');
SRW.add_parameter(myPlist,'c_v17','111');
SRW.add_parameter(myPlist,'c_18','111');
SRW.add_parameter(myPlist,'c_v18','111');
SRW.add_parameter(myPlist,'c_19','111');
SRW.add_parameter(myPlist,'c_v19','111');
SRW.add_parameter(myPlist,'c_20','111');
SRW.add_parameter(myPlist,'c_v20','111');
SRW.add_parameter(myPlist,'c_21','111');
SRW.add_parameter(myPlist,'c_v21','111');
SRW.add_parameter(myPlist,'c_22','111');
SRW.add_parameter(myPlist,'c_v22','111');
SRW.add_parameter(myPlist,'c_23','111');
SRW.add_parameter(myPlist,'c_v23','111');
SRW.add_parameter(myPlist,'c_24','111');
SRW.add_parameter(myPlist,'c_v24','111');
SRW.add_parameter(myPlist,'c_25','111');
SRW.add_parameter(myPlist,'c_v25','111');
SRW.add_parameter(myPlist,'c_v26','111');
SRW.add_parameter(myPlist,'c_v27','111');
SRW.add_parameter(myPlist,'c_v28','111');
SRW.add_parameter(myPlist,'c_v29','111');
--myIdent := SRW.run_report(myPlist);-----line 122
END P1;
/

exec p1

when i commented the line 122,procedure got executed succesfully.

when i uncomment, i got the following error

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SCOTT.SRW", line 472
ORA-06512: at "SCOTT.SRW", line 543
ORA-06512: at "SCOTT.SRW", line 790

whether the error occured due to SRW package..PARAMLIST can hold upto 255 parameters.

it needs to change any settings in the config file in Oracle Reports Server 10g.

I need solution .

Thanks
Sam

Report message to a moderator

Re: what is the maximum size of parameter that we can pass thro URL ....... [message #222691 is a reply to message #160327]

Tue, 06 March 2007 00:23

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

Hi,

Did u find a fix to ur problem. I too have the same problem,Im passing the report parameters as a URL string like this--

http://<my system IP> :7778/reports/rwservlet?report=D:/oracle/Ora91/reports/cs/sample.jsp&P_END_DATE=11/03/2007P_EMPID=181&destype=cache&desfo rmat=pdf&userid=apps/apps@test.oracle.com

I need to find what is the maximum length of the string that can be passed to IE browser?

Any suggestions is highly appreciated,
Thanks

Report message to a moderator

Previous Topic:	URL for report Submittal
Next Topic:	Button in Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:32:24 CST 2024