Manish Khindri

Greenhorn
+ Follow
since Oct 28, 2003
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
In last 30 days
0
Forums and Threads

Recent posts by Manish Khindri

Hi Everbody,
I am new to struts. and the problem i am facing is that I have got one search screen from which when i click the link.I am submitting the form and setting the mode to update and setting the relevent criteria through hidden fields. Now my problem is that before loading the form i have to process some logic to fetch the information relevent to that criteria. Now i m checking the mode in my Action class and if it is 'update' mode then i am forwarding it to the action of my second Jsp's Action.
But i am getting the following exception
java.lang.IllegalArgumentException: No bean specified

i have stated the form-bean tag for both the Jsp.
Thanx in advance

Regards,
Manish
21 years ago
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
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
21 years ago