Link to home
Start Free TrialLog in
Avatar of SirReadAlot
SirReadAlot

asked on

ORA-06550: line 1, column 7: PLS-00201: identifier 'GET_ALL_USER_SP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Hi Experts,

I have the error above.

Here is the  sp

CREATE OR REPLACE PROCEDURE get_All_User_sp(crs OUT types_pck.refCursor) AS
BEGIN
  OPEN crs FOR
    SELECT user_id AS "User ID",
               signatoryname AS "Signatory Name",
                  email AS "email",
                  phone AS "Phone",
                  fax AS "Fax",
                  jobtitle AS "Job Title",
                  location AS "Location"
      FROM users_vw
      
END;
/

and i called it like this

public DataSet dsUsers()
            {

                  comm = new OracleCommand("get_All_User_sp", conn);
                  comm.CommandType = CommandType.StoredProcedure;
                  comm.Parameters.Add("crs", OracleType.Cursor);
              comm.Parameters["crs"].Direction = ParameterDirection.Output;
                  da = new OracleDataAdapter(comm);
                  ds = new DataSet();
                  conn.Open();
                  da.Fill(ds);
                  conn.Close();
                  return ds;

            }

any ideas.

thanks

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I see that you posted with 500 points in the Oracle topic area, so you should make this q a pointer question (20 points).
please request this point reduction in the community support topic area.
Avatar of SirReadAlot
SirReadAlot

ASKER

sorry man, i didn't mean too