Re: plsql question

Pascal,

This is a known bug on OAS 4.0.8.1. There is a patch available:

1. For Windows NT Patch 1081186
2. For Solaris Patch 1117837

If you go to metalink.oracle.com and search for "ora-01036", you'll find a document stating this.

Hope this helps,

Anna

In article <39C8DE31.AC80352B_at_ie.oracle.com>,   Pascal Byrne <pbyrne_at_ie.oracle.com> wrote:
> This is a multi-part message in MIME format.
> --------------8A84B6E3ED005F046EF08EC8
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I have an 8.1.6 procedure which uses the Oracle web toolkit to
 generate an HTML page that do a
> form submit to another procedure.
>
> The first procedure generates, at run-time, an arbrary number of
 checkboxs
> which may be checked or not (depending on database contents). They are
 named v_NUM
> where NUM is an integer generated in code from 1 to 50.
>
> The code is currently generating 28 of these checkboxs which set v_1
 .. v_28 to 'on'.
>
> The second procedure is defined to accept up to fifty checkboxes i.e.
> procedure two (v_1 in VARCHAR2:= 'off', v_2 in VARCHAR2:= 'off',
> .
> .
> v_49 in VARCHAR2:= 'off', v_50 in VARCHAR2:=
 'off') is
>
> I am getting the following run-time error from OAS when all or nearly
 all are checked:
>
> Error occured while accessing
> "/v2k-test/plsql/bertupdateuser.out"
> at Wed Sep 20 16:33:48 2000
>
> OWS-05101: Execution failed due to Oracle error 1036
> ORA-01036: illegal variable name/number
>
> PL/SQL Cartridge SERVICE: APP_BERT_TEST/BERT_TEST
> PROCEDURE: bertupdateuser.out
>
> Any help would be most appreciated.
>
> Thanks,
> pascal
>
> --------------8A84B6E3ED005F046EF08EC8
> Content-Type: text/x-vcard; charset=us-ascii;
> name="pbyrne.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pascal Byrne
> Content-Disposition: attachment;
> filename="pbyrne.vcf"
>
> begin:vcard
> n:Byrne;Pascal
> x-mozilla-html:FALSE
> adr:;;;;;;
> version:2.1
> email;internet:pbyrne_at_ie.oracle.com
> title:WPTG Engineering
> end:vcard
>
> --------------8A84B6E3ED005F046EF08EC8--
>
>

--
                _        _
Anna Wilkins   /-)/\//\//-)
Oracle Web Developer
Peterson's


Sent via Deja.com http://www.deja.com/
Before you buy.