Link to home
Create AccountLog in
Avatar of xeondxb
xeondxbFlag for United Arab Emirates

asked on

9i STORED PROCEDURE in JSP?

My Stored procedure not  giving any Error while im compiling  in oracle 91.  I want pass TID for example 189  it should return record set it could be 1 record or more then 1..
well This is my PROCEDURE:


--------------------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE GETMSGRECSET
(TH_ID   IN ESSE.TID%TYPE)
         
         
IS
         cursor ET_cursor IS
      select EM.MSGID,EMT.PID,EM.SUT,EM.CDATE
                     FROM ESSE EM, ESST EMT
                     WHERE
                     EM.TID=TH_ID AND
                     EMT.CID=EM.MSGID AND
                     EMT.APPROVED=1 ;
begin
     
      COMMIT;
     
     
end GETMSGRECSET;
/
-----------------------------------------------------------------------------------------------------------

How can I get all
I need 2 no how I can get all fields  in jsp ?
ASKER CERTIFIED SOLUTION
Avatar of onlyamir007
onlyamir007

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of xeondxb

ASKER

Thanks