Hi ! I am generating the script for creating an oracle procedure in a java program. the generated script looks like String buff="CREATE OR REPLACE PROCEDURE ALERTS_EX (ALERTS_cur OUT types.ref_cursor,BeginTimeStamp IN TimeStamp) AS BEGIN OPEN ALERTS_cur FOR SELECT * from ALERTS END;" thereafter i connect to database and create a statement etc as stmt=conn.createStatement(); then int x=stmt.executeUpdate(buff); However value of x comes as 0 and i am unable to create procedures in the database. Can anyone please suggest where i am going wrong? my email id is firstname.lastname@example.org Prashant
Prashant, please do not post the same question to multiple forums -- epecially inappropriate ones. It just wastes peoples' time when redundant conversation take place. Please contimue any discussion in the JDBC forum.