v_db := 'test/test@ODBC:UG2000';
Are you trying to connect to a ODBC datasource? I don't think this is possible via exec_sql. If your datasource is an oracle database then simply connect via SQL*Net; if it is another database create a database gateway and use it:
You can connect via ODBC using exec_sql.open_connection.
HaiderAli, you have to give version information, the OS you are using, the exact error message etc.
Maybe it works on your local PC, but not on the server. If you are trying to connect from the server, make sure you can access the data source from this server.
There is certainly one thing wrong: the spec for using open_connection is:
(Username IN VARCHAR2,
Password IN VARCHAR2,
Data source IN VARCHAR2)
There are 3 parameters, not one. Look in the Help! Very simple.
(The Help is not too clear, I must admit. In the description they are talking about parameter Connstr, which is not in the definition of the procedure).
Message was edited by: InoL