TSQLStoredProc affected by ORA-08261 but not TSQLQuery

[Francesco]

Hello,

I got cppbuilder 6, oracle 11g, dbexpoda 4.70.20, windows vista.

I have a TSQLConnection object, I turned BCD feature off. When I open a TSQLQuery everything works fine, when I execute a TSQLStoredProc I got the error: "ORA-08261: ora_addr: cannot find name in nameserver.". I used the same TSQLConnection object. I cannot figure out where is the error, thanks in advance.

Francesco

[AlexP]

Hello,

I cannot reproduce the problem.

Please try to execute the following code:

Code: Select all

  TSQLConnection *SQLConnection = new TSQLConnection(NULL);
  TSQLStoredProc *SQLStoredProc = new TSQLStoredProc(NULL);

  SQLConnection->DriverName = "DevartOracle";
  SQLConnection->GetDriverFunc = "getSQLDriverORA";
  SQLConnection->LibraryName = "dbexpoda.dll";
  SQLConnection->VendorLib = "OCI.DLL";
  SQLConnection->LoginPrompt = false;
  SQLConnection->Params->Values["DataBase"] = "SERVER";
  SQLConnection->Params->Values["User_Name"] = "USER";
  SQLConnection->Params->Values["Password"] = "PASSWD";
  SQLConnection->Connected = true;
  SQLConnection->Execute("CREATE OR REPLACE PROCEDURE test AS BEGIN NULL; END;",NULL,NULL);


  SQLStoredProc->SQLConnection = SQLConnection;
  SQLStoredProc->StoredProcName = "test";
  SQLStoredProc->ExecProc();

if error persists, please download the latest version of dbExpress driver for Oracle (4.70.23) and try again.