Oracle error ORA-06550. PLS-00306
-
I am getting the error "ORA-06550: line 1, column 7: PLS-00306 Wrong number or type of arguments in call to SP_NAME. I am calling the procedure SP_NAME and i am giving the same number and type of arguments The stored procedure executes perfectly when i run in the sql plus Here is my .net code OraConn.Open() lCmd.Connection = OraConn lCmd.CommandText = "MADDIE.SP_NAME" lCmd.CommandType = CommandType.StoredProcedure Dim oParm As OracleParameter oParm = New OracleParameter("zInst", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pInst lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zTempId", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pTempId lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zRecCnt", OracleType.Int32) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExCode", OracleType.Number) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExMsg", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExDetail", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zCursor", OracleType.Cursor) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) Try Dim lDA As New OracleDataAdapter(lCmd) Dim lDS As New DataSet() lDA.Fill(xDataSet) OraConn.Close() The Stored procedure starting is as follows. CREATE OR REPLACE PROCEDURE "MADDIE"."SP_NAME" ( iInst IN VARCHAR2, iTempId IN VARCHAR2, ORecCount OUT INTEGER, OExceptionCode OUT NUMBER, OExceptionMsg OUT VARCHAR2, OExceptionDetail OUT VARCHAR2, OCursor OUT MADDIE.MADDIE_CURSOR.CURSOR_TYPES ) Is eExitNoException EXCEPTION; eExitWithException EXCEPTION; lRecCount integer; lExceptionCode NUMBER; lExceptionMsg VARCHAR2(500); lExceptionDetail VARCHAR2(500); lSPID varchar(50); lInvalidParm BOOLEAN; lCursor MADDIE.MADDIE_CURSOR.CURSOR_TYPES; begin sO ON.. Can anybody help me on this??
-
I am getting the error "ORA-06550: line 1, column 7: PLS-00306 Wrong number or type of arguments in call to SP_NAME. I am calling the procedure SP_NAME and i am giving the same number and type of arguments The stored procedure executes perfectly when i run in the sql plus Here is my .net code OraConn.Open() lCmd.Connection = OraConn lCmd.CommandText = "MADDIE.SP_NAME" lCmd.CommandType = CommandType.StoredProcedure Dim oParm As OracleParameter oParm = New OracleParameter("zInst", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pInst lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zTempId", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pTempId lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zRecCnt", OracleType.Int32) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExCode", OracleType.Number) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExMsg", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExDetail", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zCursor", OracleType.Cursor) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) Try Dim lDA As New OracleDataAdapter(lCmd) Dim lDS As New DataSet() lDA.Fill(xDataSet) OraConn.Close() The Stored procedure starting is as follows. CREATE OR REPLACE PROCEDURE "MADDIE"."SP_NAME" ( iInst IN VARCHAR2, iTempId IN VARCHAR2, ORecCount OUT INTEGER, OExceptionCode OUT NUMBER, OExceptionMsg OUT VARCHAR2, OExceptionDetail OUT VARCHAR2, OCursor OUT MADDIE.MADDIE_CURSOR.CURSOR_TYPES ) Is eExitNoException EXCEPTION; eExitWithException EXCEPTION; lRecCount integer; lExceptionCode NUMBER; lExceptionMsg VARCHAR2(500); lExceptionDetail VARCHAR2(500); lSPID varchar(50); lInvalidParm BOOLEAN; lCursor MADDIE.MADDIE_CURSOR.CURSOR_TYPES; begin sO ON.. Can anybody help me on this??
-
I am getting the error "ORA-06550: line 1, column 7: PLS-00306 Wrong number or type of arguments in call to SP_NAME. I am calling the procedure SP_NAME and i am giving the same number and type of arguments The stored procedure executes perfectly when i run in the sql plus Here is my .net code OraConn.Open() lCmd.Connection = OraConn lCmd.CommandText = "MADDIE.SP_NAME" lCmd.CommandType = CommandType.StoredProcedure Dim oParm As OracleParameter oParm = New OracleParameter("zInst", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pInst lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zTempId", OracleType.Varchar) oParm.Direction = ParameterDirection.Input oParm.Value = pTempId lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zRecCnt", OracleType.Int32) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExCode", OracleType.Number) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExMsg", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zExDetail", OracleType.Varchar,500) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) oParm = New OracleParameter("zCursor", OracleType.Cursor) oParm.Direction = ParameterDirection.Output lCmd.Parameters.Add(oParm) Try Dim lDA As New OracleDataAdapter(lCmd) Dim lDS As New DataSet() lDA.Fill(xDataSet) OraConn.Close() The Stored procedure starting is as follows. CREATE OR REPLACE PROCEDURE "MADDIE"."SP_NAME" ( iInst IN VARCHAR2, iTempId IN VARCHAR2, ORecCount OUT INTEGER, OExceptionCode OUT NUMBER, OExceptionMsg OUT VARCHAR2, OExceptionDetail OUT VARCHAR2, OCursor OUT MADDIE.MADDIE_CURSOR.CURSOR_TYPES ) Is eExitNoException EXCEPTION; eExitWithException EXCEPTION; lRecCount integer; lExceptionCode NUMBER; lExceptionMsg VARCHAR2(500); lExceptionDetail VARCHAR2(500); lSPID varchar(50); lInvalidParm BOOLEAN; lCursor MADDIE.MADDIE_CURSOR.CURSOR_TYPES; begin sO ON.. Can anybody help me on this??
Check the size also. Ram