posted 21 years ago
Hi all,
I am using Style Report Enterprise Edition 5.0.In that i am calling a Oracle Stored procedure with a 1 IN parameter and 3 OUT Parameter.
The procedure is given below
CREATE OR REPLACE PROCEDURE Employeedetails(
i_emIDINEMPLOYEE.em_id%TYPE,
o_FirstName OUT EMPLOYEE.em_first_name%TYPE,
o_LastNameOUTEMPLOYEE.em_last_name%TYPE,
o_SalaryOUTEMPLOYEE.em_salary%TYPE,
o_StartDateOUTEMPLOYEE.em_start_date%TYPE)
IS
BEGIN
SELECT em_first_name,
em_last_name,
em_salary,
em_start_date
INTO o_FirstName,
o_LastName,
o_Salary,
o_StartDate
FROM EMPLOYEE
WHERE em_id = i_emID;
END Employeedetails;
/
And I am setting the IN parameter as a prompt Value which i specify but after that i get this error
About to execute "{ call PTS.EMPLOYEE1.EMPLOYEE1( ? ,?)}"
inputParameter #1="1" (class java.lang.Integer)
java.sql.SQLException: ORA-06550: line 1, column 21:
PLS-00225: subprogram or cursor 'EMPLOYEE1' reference is out of scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Can anybody help me even if u dont know the Style report. Whats will be the main cause of such type of errors