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_Use r_sp", conn);
comm.CommandType = CommandType.StoredProcedur e;
comm.Parameters.Add("crs", OracleType.Cursor);
comm.Parameters["crs"].Dir ection = ParameterDirection.Output;
da = new OracleDataAdapter(comm);
ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
return ds;
}
any ideas.
thanks
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_Use
comm.CommandType = CommandType.StoredProcedur
comm.Parameters.Add("crs",
comm.Parameters["crs"].Dir
da = new OracleDataAdapter(comm);
ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
return ds;
}
any ideas.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry man, i didn't mean too
please request this point reduction in the community support topic area.