• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1504
  • Last Modified:

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.


  • 2
1 Solution
Guy Hengel [angelIII / a3]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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now