Execute command

[EDDY]

Execute dbms_xxxx' cannot run with oraSql or OraQuery ?
i try and become : ORA:00900: invalid SQL statement

[Challenger]

We couldn't reproduce this error. Please send to ODAC support address complete sample that demonstrates this problem and include script to create server objects.

[Eddy]

We couldn't reproduce this error. Please send to ODAC support address complete sample that demonstrates this problem and include script to create server objects.

With Orapacket is very slow the executing
DBMS_SNAPSHOT.REFRESH('list','ESQUEM.TABLE','method','C');

How ist with oraSql or OraQuery ?

OraQuery.sql('DBMS_SNAPSHOT.REFRESH('list','ESQUEM.TABLE','method','C'));

OraQuery.Execute.

ist so fast ?[/img]

[Plash]

Try to use TOraSQL component. Assign the following text to SQL property:

Code: Select all

BEGIN
  DBMS_SNAPSHOT.REFRESH('ESQUEM.TABLE', 'C');
END;

[Eddy]

Try to use TOraSQL component. Assign the following text to SQL property:

Code: Select all

BEGIN
  DBMS_SNAPSHOT.REFRESH('ESQUEM.TABLE', 'C');
END;

Run Ok , but is as slow as sqlplus more 120%

OraSql , OraPacket are snail Component

Thank plash

[Plash]

We have tested the execution of procedure DBMS_SNAPSHOT.REFRESH and found out that in ODAC it takes no longer than in SQL Plus. But time that server spends to execute this procedure can differ depending on presence of data in the server cache.