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

SirReadAlotAsked:
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?
0
 
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.
0
 
SirReadAlotAuthor Commented:
sorry man, i didn't mean too
0
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.