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