TDBXError 'Schema or user name separated by a '.' must be sp

TDBXError 'Schema or user name separated by a '.' must be sp

Postby jsaumell » Mon 16 Aug 2010 09:04

Hi,
I'am upgrading a Delphi 2006 application where I was using version 4.20.4 of dbExpress driver to RAD 2007 with version 4.20.11.

Delphi raises an error 'Schema or user name separated by a '.' must be specified' when filling StoredProcName property calling a Stored Procedure (same code is working in old Delphi).

Here is the code:

procedure ExecSomething (strConnection: String);
var StoreProcedure: TSQLStoredProc;
begin
StoreProcedure := TSQLStoredProc.Create(nil);
with StoreProcedure do
try
SqlConnection := GetConnection (strConnection);
SChemaName := 'SEC';
PackageName := 'SEC_PKG';
StoredProcName := 'SETPROP'; <--- Exception raises here
........
ParambyName('value').AsString := 'test';
........
jsaumell
 
Posts: 9
Joined: Thu 05 Jun 2008 16:02

Postby jsaumell » Mon 16 Aug 2010 10:43

Solved.

I was using old version of library.
LibraryName=dbexpoda30.dll -> LibraryName=dbexpoda40.dll
jsaumell
 
Posts: 9
Joined: Thu 05 Jun 2008 16:02


Return to dbExpress driver for Oracle