Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic SQL and Database Links

Dynamic SQL and Database Links

From: Jenny Farnham <farnham_at_spot.Colorado.EDU>
Date: 14 Jul 1999 19:03:48 GMT
Message-ID: <7mimuk$o4b@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 Wed Jul 14 1999 - 14:03:48 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US