We had the same problem - it appears there is some limit (20 parameters?)
for later versions. We got around it by using varrays to pass the parameters
and their values.
--
Greg Cooper
Customer Solutions
Advantra P/L
Mailto: greg.j.cooper_at_team.telstra.com
Anup Mistry wrote in message <8jn1d7$fim$1_at_nnrp1.deja.com>...
>Hello !!
>
> I have this weird problem ....
>
> I am using the PLSQL cartridge
>
> It is a registration form with about 27 parameters to be accepted from
>the user validatd thur javascript and then inserted into the Oracle
>Database.. Thats it that simple.
>
>
> My code Runs perfectly on the OAS407. Oracle805 combination without any
>errors
>
> When I upgraded to 815 the following errors where seen in the Event
>Viewer of NT and the Browser respectively.
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>+++++++++++++++++++++
>Following error in the Event Viewer
>
>The description for Event ID ( 0 ) in Source ( OracleWRBService ) could
>not be found. It contains the following insertion string(s): 07-02-1999
>14:03:20 0 java1 `ehtapp/ehtcart Cartridge`
>324 1 0x400fff ` Value[0]: `
>.
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>++++++++++++++++++++++++++++++++++++++++++
>Following error in the Browser
>
>------------------------------------------------------------------------
>--------
>Request Failed
>------------------------------------------------------------------------
>--------
>
>We were unable to process your request at this time.
>
>
>Error occured while accessing
> "/iis/eht/reg_pk.mt"
>at Fri Jul 02 14:03:13 1999
>
>OWS-05101: Execution failed due to Oracle error -6513
>
> PL/SQL Cartridge SERVICE: ehtapp/ehtcart
> PROCEDURE: reg_pk.mt
>
>
> PARAMETERS:
> ===========
> RUNAME_IN:
> vendor
> RPASSWORD:
> 12345
> REPASSWORD:
> 12345
> RHINT_Q_IN:
> Hint Question
> RHINT_A_IN:
> answer
> RDFNAME_IN:
> fname
> DMNAME_IN:
> Middle Name
> RDLNAME_IN:
> lnamw
> REMAIL:
> email_at_email.com
> RDADDRESS1_IN:
> address
> DADDRESS2_IN:
>
> RDCITY_IN:
> mumbai
> RDSTATE_IN:
> Maharashtra
> RPIN:
> 38383838
> RDCOUNTRY_IN:
> indisa
> RHPHONE:
> 222222222
> ROPHONE:
> 222222233
> FAX:
>
> MOBILE:
>
> SSN1:
>
> SSN2:
>
> SSN3:
>
> PAGER:
>
> SOURCE_IN:
>
> OTHER_IN:
>
> DEGREE_IN:
>
> DEGREE_MJ_IN:
>
> TYPING_SPEED_IN:
>
> WORKPROC_SKILL_IN:
> NeverUsed
> RRATELINES_IN:
> 10
> SPEC_IN:
> none
> 1
> 2
> 3
> OTHER_SPEC_IN:
>
> EMPLOYERNAME_IN:
>
> EMPLOYERADDRESS_IN:
>
> FROMMONTH_IN:
> 0
> FROMYEAR_IN:
> 19
> TOMONTH_IN:
> 0
> TOYEAR_IN:
> 19
> DUTIES_IN:
>
> EMPLOYERNAME1_IN:
>
> EMPLOYERADDRESS1_IN:
>
> FROMMONTH1_IN:
> 0
> FROMYEAR1_IN:
> 19
> TOMONTH1_IN:
> 0
> TOYEAR1_IN:
> 19
> DUTIES1_IN:
>
> COMMENTS_IN:
>
>
>
>
>Please try again later
>------------------------------------------------------------------------
>--------
>Kindly mail or reply to this message for the solution or a tip through
>which I can solve the problem
>
>
>
>--
>Anup Mistry
>(SOFTWARE POWERS THE INTERNET -- Oracle)
>Programmer / Analyst
>IIS Pvt Ltd,
>Mumbai, India
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jul 21 2000 - 00:00:00 CDT
