locked
Calling an oracle plsql procedure RRS feed

  • Question

  • User-2037497074 posted

    Hi,

    i am trying to call an Oracle plsql stored procedure from my page

    but i keep getting the error:

    ERROR [42000] [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

    here's my code

     

            OdbcConnection odbcConn = new OdbcConnection(connstring);
            string connstring = "Dsn=LDEV2;uid=PWRUSER;dbq=LDEV2;pwd=pwruser123";
            comm = "XX_FC_DATA_UPDATE_SUBTYPE";
    
            OdbcCommand odbcproc = new OdbcCommand(comm, odbcConn);
            odbcproc.CommandType = CommandType.StoredProcedure;
            odbcproc.Parameters.Add("P_UIDFCENTITY", OdbcType.Int).Value = uidfcent;
            odbcproc.Parameters.Add("P_YEAR", OdbcType.Int).Value = baseyear;
            odbcproc.Parameters.Add("P_UIDFCSUBSTATION", OdbcType.Int).Value = uidsubstn;
            odbcproc.Parameters.Add("P_UIDACCSUBTYPE", OdbcType.Int).Value = uidaccsubtype;
            odbcproc.Parameters.Add("P_UIDACCOUNT", OdbcType.Int).Value = 21;
            odbcproc.ExecuteScalar();


    please, help

    Thanks

    Thursday, May 16, 2013 4:48 AM

Answers

All replies