Re: Sql*Plus /Parameter Limit?

In article <CtIpIK.I4r_at_cnsnews.Colorado.EDU>, <farnham_at_spot.Colorado.EDU> writes:
> Newsgroups: comp.databases.oracle
> Path:
syntex.com!barrnet.net!agate!howland.reston.ans.net!europa.eng.gtefsd.com!newsx fer.itd.umich.edu!ncar!csn!boulder!cnsnews!spot.Colorado.EDU!farnham
> From: farnham_at_spot.Colorado.EDU (Jenny Farnham)
> Subject: Sql*Plus /Parameter Limit?
> Message-ID: <CtIpIK.I4r_at_cnsnews.Colorado.EDU>
> Sender: usenet_at_cnsnews.Colorado.EDU (Al Marti)
> Nntp-Posting-Host: spot.colorado.edu
> Organization: University of Colorado, Boulder
> Date: Mon, 25 Jul 1994 22:37:32 GMT
> Lines: 19
>
> 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?
>
> I use &1 &2 &3 &4 & 5 , etc.... they seem fine.
> Only &8 seems to be ignored.
>
> Thanks,
> Jenny
>

From DCL you can only pass eight parameters to a DCL command script. You can extend this by writing you own routines to split each parameter into seperate parameters whenever you find a ^, but each DCL parameter can only be up to 250 characters in length.

From Sql*Plus running on VMS you only have seven parameters available as the first parameter contains the executable filename which is used internally by VMS. A way around this problem is to get Sql*Plus to prompt for input and via a DCL script feed the parameters to Sql*Plus, i.e.

DCL script:

$ SQLPLUS /
_at_some_sql_file

param_1
param_2
param_3
.

Lee C. Received on Tue Jul 26 1994 - 22:53:38 CEST