Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
N

newbie net

@newbie net
About
Posts
1
Topics
1
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Oracle error ORA-06550. PLS-00306
    N newbie net

    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??

    ASP.NET database help csharp sharepoint oracle
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups