SQL*Loader & Bind Variables: How to?
From: Richard Vernick <richvernick_at_iname.com>
Date: Tue, 23 Jun 1998 00:02:18 GMT
Message-ID: <egCj1.682$oN4.18959592_at_news.rdc1.pa.home.com>
I would like to use a bind variable in a loader file (to insert the same batch number for all of the rows in that session). I'm pretty sure you can do it. In the field definition I use:
BATCH CHAR "&BATCH"
and I don't know how to tell loader what the value of &BATCH is...
Date: Tue, 23 Jun 1998 00:02:18 GMT
Message-ID: <egCj1.682$oN4.18959592_at_news.rdc1.pa.home.com>
I would like to use a bind variable in a loader file (to insert the same batch number for all of the rows in that session). I'm pretty sure you can do it. In the field definition I use:
BATCH CHAR "&BATCH"
and I don't know how to tell loader what the value of &BATCH is...
The log file balks and says 'not all variables bound'....
Any suggestions?
.I already tried batch='100' on the command like.
there has to be a way like sql*plus &1, &2, etc.. Received on Tue Jun 23 1998 - 02:02:18 CEST