Devart Forums

Posted: **Fri 23 Jun 2006 07:23**

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

Posted: **Fri 23 Jun 2006 13:01**

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.

Posted: **Mon 26 Jun 2006 23:06**

challenger wrote: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]

Posted: **Tue 27 Jun 2006 12:34**

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

Code: Select all

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

Posted: **Wed 28 Jun 2006 05:27**

plash wrote: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

Posted: **Fri 30 Jun 2006 08:05**

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.

Devart Forums

Execute command

Execute command

OraQuery vs ORaPacket

OraSql , OraPacket