Re: passing parameter when calling db-script as file

Alternatively, use the pseudo column USER as a value in the insert. If each developer is using unique usernames then you have your solution.

eg: insert into schema.table values USER,&1, &2...

...neil

On Thu, 07 Dec 2000 11:44:30 GMT, Thomas Schelhorn <tomsonn_at_my-deja.com> wrote:

>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 - 19:45:52 CST