Re: Sql*Plus /Parameter Limit?

In article <CtIpIK.I4r_at_cnsnews.Colorado.EDU>

           farnham_at_spot.Colorado.EDU "Jenny Farnham" writes:

> On a VAX system using DCL, is there a
> parameter limit?
>
> For example:
>
> $ sqlplus -s _at_someprogram p1 p2 p3 p4 p5 p6 p7 p8
>
> In my program, I get the prompt such as:
>
> Enter value for &8
>
> Can you only send 7 parameters?
>

The limit is operating system-dependent, and I seem to remember that it's eight on VAX. (So maybe the username/password counts as one).

Depending on your application, you could try any of the following naff solutions:-

1. putting the parameters in a table, keyed on the program name and using that as the only parameter. (Pretty naff, admittedly)
2. sending the parameters as a delimited string ('thingone,thingtwo....eight') and then using a combination of new_value and the instr/substr functions to select them into variables within the prog. (Almost as naff, but strangely impressive)
3. (interactive programs only) using the 'accept' command. (Only naff because it's far too straightforward.

Or write it in rpt. Or whichever ReportWriter version you've got.

Alternatively, I could be wrong about the system-dependent thing, in which case you have a totally different problem.

M

-- 
-----------------------------------------------------------------------------
                                                    MarkB_at_aboy.demon.co.uk
Lyric Quiz of the Week: "You snatch a tune and you match a cigarette..."