Db link creation
Date: 2 Nov 2005 04:43:03 -0800
Message-ID: <1130935383.379038.23130_at_g43g2000cwa.googlegroups.com>
Hi,
I'm stuck up with an intersting issue on DB links. The syntax (which I presume most of u guyzz are very familiar with) for creating a DB link is as follows:
create database link <link_name> connect to <username> identified by <password> using '<connection string>'
Notice that username and password are NOT in quotes.. The problem arises when the password contains special characters (like ',',';','~' etc) or when the password starts with a number, the latter being a very relevant issue.. The remote database can certainly allow passwords starting with numbers or containing special characters, but the command gives an invalid SQL exception as there are many restrictions on schema object names.. Moreover, these objects (like the password field) cannot be bound using :1 in dynamic SQL.. So far, I'm stumped as far as creating a db link with special characters in passwords (or passwords starting with numerals) is concerned.. Any workarounds/ solutions anyone ?????? Received on Wed Nov 02 2005 - 13:43:03 CET