aspose file tools*
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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle Procedure problem
 
Similar Threads
Cannot get Oracle CURSOR from Oracle procedure
Determine the Callable Statements Parameters at runtime
Cannot get Oracle CURSOR from Oracle procedure in Websphere
java.sql.SQLException: Pls Help
HELP!!! - inner exception : java.sql.SQLException: ORA-06550: