I am trying to get a set of data from oracle by using store procedure with a reference cursor. I got the following err msg:
ORA-06550: line 1, column 7: PLS-00801: internal error  ORA-06550: line 1, column 7: PL/SQL: Statement ignored
There was an exact same question posted last year on EE. However, when I tried the solution, I still get the same err.
Here is my code:
dim connOra as New OracleConnection(strConn)
dim oOraCmd as New OracleCommand(String.Empty
oOraCmd.CommandType = Data.CommandType.StoredPro
oOraCmd.CommandText = "HDWPD001.myPkg.mySP()"
ion = ParameterDirection.Output
dim oDA as New OracleDataAdapter(oOraCmd)
dim oDS as New DataSet
Here is my oracle procedure(Ref_Cursor has been defined in spec):
CREATE OR REPLACE PACKAGE BODY HDWPD001.myPkg AS
PROCEDURE mySP(cur OUT Ref_CURSOR)
OPEN CUR FOR select * from myTbl;
I am using oracle 8i and ASP.net 2.0 (VS2005 beta 2). Thanks!