OracleDataSource - StoredProcedure

OracleDataSource - StoredProcedure

Postby fbenavidesd » Thu 28 May 2009 14:02

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
fbenavidesd
 
Posts: 3
Joined: Wed 27 May 2009 11:44

Postby Shalex » Tue 02 Jun 2009 10:46

This problem occurs because the DbType.Cursor type is not available in ASP.NET.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle