| Author |
Oracle Procedure problem
|
Manish Khindri
Greenhorn
Joined: Oct 28, 2003
Posts: 3
|
|
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
|
 |
Manish Khindri
Greenhorn
Joined: Oct 28, 2003
Posts: 3
|
|
There is slight modification of error About to execute "{ call PTS.EMPLOYEEDETAILS.EMPLOYEEDETAILS( ? ,?,?,?,?)}" inputParameter #1="1" (class java.lang.Integer) java.sql.SQLException: ORA-06550: line 1, column 27: PLS-00225: subprogram or cursor 'EMPLOYEEDETAILS' reference is out of scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored
|
 |
Felix Anohene
Greenhorn
Joined: Oct 28, 2003
Posts: 1
|
|
Oracle is having a problem resolving your procesdure name. In the call of the procedure use <your schema name>.EMPLOYEEDETAILS. The error code "pls-00225, subprogram or cursor reference '%EMPLOYEEDETAILS' is out of scope. " means there is a problem resolving a object reference or variable name in the plsql program. Check for duplicate variable declarations, or objects on the sys, system and the user schema, for any possible conflicts. Select object_name, object_type, owner from dba_objects where object_name like '%<problem reference%>'; should help you identify the different objects existent in your system and the different schemas with the same name and that may be causing the reference conflict.
|
 |
 |
|
|
subject: Oracle Procedure problem
|
|
|