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

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

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