Re: Dynamic SQL and Database Links

From: Stephen Hirsch <stephen.hirsch_at_pharma.novartis.com>
Date: Thu, 15 Jul 1999 09:38:28 -0400
Message-ID: <378de476.0@guardhouse.chbs>

Hi,

Yes, I have. I didn't have a problem with the 2000 character limit; however, one solution may be to split the Insert statement into an Insert and then an Update.

Steve
Jenny Farnham wrote in message <7mimuk$o4b_at_peabody.colorado.edu>...
>Scenario:
>
>We need to insert data into a table via a database
>link.
>
>Questions:
>
>1.) Has anyone used dynamic sql to create
>the insert statement so that depending on what
>database you are logged into - the correct
>database link is used? and if so, how did you
>get around the 2000 character limit?
>
>We have this huge insert statement with lots
>of data.
>
>Any ideas?
>
Received on Thu Jul 15 1999 - 08:38:28 CDT