Devart Forums

I try ODAC for Delphi 7 and have problem with
ORApackets

When execute:
param1 and param2 are string where param2='C'

OraPackage.PackageName:='DBMS_SNAPSHOT';

ORaPackage.ExecProcEx('REFRESH',[param1,param2]);
i become error ' Could not convert variant of type
(string) into type (boolean)

Thanks

For ExecProcEx method parameters must be supplied in Params array as pairs of parameters' names and values so that every value comes immediately after its name. For example:

plash wrote:For ExecProcEx method parameters must be supplied in Params array as pairs of parameters' names and values so that every value comes immediately after its name. For example:

Code: Select all

OraPackage.ExecProcEx('REFRESH', ['list', Param1, 'method', Param2]);

Thanks, but not respond,

this my code:
self user and pass

in sqlplus is ok execute DBMS_SNAPSHOT.REFRESH('ESQUEM.TABLE','C');

but in deplhi

OraPackage2.PackageName:='DBMS_SNAPSHOT';
OraPackage.ExecProcEx('REFRESH',['ESQUEM.TABLE','C']);
ERROR: paramnt not found

To execute stored procedure using ODAC you should supply parameters for ExecProcEx method as pairs of parameters' names and values so that every value comes immediately after its name.
Also you can use TOraStoredProc component.

plash wrote:To execute stored procedure using ODAC you should supply parameters for ExecProcEx method as pairs of parameters' names and values so that every value comes immediately after its name.
Also you can use TOraStoredProc component.

Ist Ok with DBMS_SNAPSHOT.REFRESH('list','ESQUEM.TABLE','method','C');
but is very slow


thank

See reply in Execute command topic