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

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();
                  return ds;


any ideas.


Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
did you connect with the same user as the owner of the procedure?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
SirReadAlotAuthor Commented:
sorry man, i didn't mean too
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.