TSQLStoredProc affected by ORA-08261 but not TSQLQuery

TSQLStoredProc affected by ORA-08261 but not TSQLQuery

Postby Francesco » Mon 14 Feb 2011 12:03

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
Francesco
 
Posts: 9
Joined: Thu 20 Jan 2011 16:33

Postby AlexP » Tue 15 Feb 2011 11:00

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle