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 -> pro c database link problem

pro c database link problem

From: <kshave_at_health.gov.mb.ca>
Date: Fri, 12 Mar 1999 14:15:22 GMT
Message-ID: <7cb7hg$amk$1@nnrp1.dejanews.com>


I have the following Pro C code ...

strcpy(link_name, "DEVL");

exec sql

   select prod_e
   into :DIN_prod_e
   from dinmst_at_link_name
   where din = :DIN_din;

The database link DEVL exists in the database. Link_name is a variable holding DEVL is not being properly translated. When executing, dinmst_at_link_name is used instead of the contents of link_name which would provide dinstmst_at_DEVL.

Is there another way to accomplish this?

-Keith

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 08:15:22 CST

Original text of this message

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