*
The moose likes Java in General and the fly likes Oracle Procedure problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Oracle Procedure problem" Watch "Oracle Procedure problem" New topic
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Oracle Procedure problem
 
Similar Threads
Determine the Callable Statements Parameters at runtime
HELP!!! - inner exception : java.sql.SQLException: ORA-06550:
java.sql.SQLException: Pls Help
Cannot get Oracle CURSOR from Oracle procedure
Cannot get Oracle CURSOR from Oracle procedure in Websphere