Devart Forums

Shalex wrote:The SqlCacheDependency class is designed to work with SQL Server only.

Thanks for your clarification. But just for be sure that you understand me , the SqlCacheDependency that I'm refering is the one that apears as a option in the Properties Windows of the OracleDatasource Component in Design Time in the Visual Studio 2008, that's why I was thinking that it should work with oracle, or maybe that property shouldn't be available.

I'm using the Oradirect/OracleDataSource visual component, the SelectCommandType is in StoredProcedure, and SelectQuery is pointing to a Function in a Oracle Server that the returnvalue is a Cursor

Code of the function in the Oracle Server
CREATE OR REPLACE PACKAGE Test_pck AS
TYPE TCursor IS REF CURSOR;

FUNCTION Method(p_idIN integer) Return TCursor;

END Test_pck ;

I go to the OracleDataSource component visualy, search and find the function, It regenerate the Parameters Collection:
RESULT:
Data Type: Blank(Null)
Direction: ReturnValue
Default Value: CoreLab.Oracle.OracleCursor
P_ID:
Data Type: Number
Direction: Input
Default Value: 1
I press the Execute button for test, It works perfect, it shows a popup named Preview Data with a table inside with the result of the function.

Then I accept all the changes made and when I Start Debugging(F5) in the Visual Studio 2008 the page give me this error:

Exception Details: CoreLab.Oracle.OracleException: ORA-06550: line 2, column 14:
PLS-00382: expression is of wrong type
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

It's very strange, it's work well while I use the OracleDataSource component in Design Time for the first time, but when i finish and accept the changes is fails.

Please any help, or tip that you could give I will thanks a lot

I'm using the Oradirect/OracleDataSource visual component. I'm connecting to an Oracle 9i server, but I could also work with a Oracle 11g. The component works very good; but when I try to use the SqlCacheDependency it fails.

If I put the oracle esquema name and the table name at the SqlCacheDependency "esquema1:table1" this is the error:

The 'esquema1:table1' SqlDependency attribute for OutputCache directive is invalid.

Detailed error message: Cannot find the 'esquema1' database in the configuration.


If I put just the table name at the sqlcachedependency "table1" this is the error:
The 'table1' SqlDependency attribute for OutputCache directive is invalid.

For SQL Server 7.0 and SQL Server 2000, the valid format is "database:tablename", and table name must conform to the format of regular identifiers in SQL. To specify multiple pairs of values, use the ';' separator between pairs. (To specify ':', '\ or ';', prefix it with the '\ escape character.)

I need help with that. I'm I using something wrong? Do I have to write that diferent? Does the sqlcachedependecy doesn't works with an Oracle Server?

thanks for any help you can give me