ODAC ORaPackage , Urgent :(

[EDDY]

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

[Plash]

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]);

[EDDY]

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

[Plash]

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.

[Eddy]

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

[Plash]

See reply in Execute command topic