Re: passing parameter when calling db-script as file

From: Thomas Schelhorn <tomsonn_at_my-deja.com>
Date: Thu, 07 Dec 2000 11:44:30 GMT
Message-ID: <90nt6t$5mo$1@nnrp1.deja.com>

found a solution by myself: you can do this by calling the script with the following syntax from sql-plus-prompt:

'start scriptname parameter1 parameter2 ...'

inside the script you'll have to use '&1', '&2' ... to reference the passed in parameters

Tom

In article <90nslq$5ah$1_at_nnrp1.deja.com>, Thomas Schelhorn <tomsonn_at_my-deja.com> wrote:
> Hi everybody!
>
> I've got the following challenge: I want to write several
> table-insert-scripts for testing-purposes. Every developer should be
> able to call the script as a file with his own id passed as a
> parameter (to be stored in the table). Is there a way to do this or do
I
> have to work arround?
>
> thanx in advance
> Tom
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 07 2000 - 05:44:30 CST