MySQL Procedure to Oracle Procedure conversion
444294Jul 25 2006 — edited Jul 26 2006Hi All ,
I am facing difficulty in converting mysql procedures to oracle procedures . Since I am new to Oracle can anybody help me in sorting out the problem .
MS SQL procedure is as follows :
DELIMITER $$
DROP PROCEDURE IF EXISTS `ilms_3`.`sp_get_session_presenter` $$
CREATE PROCEDURE `sp_get_virtual_session_presenter`(session_id INT)
BEGIN
SELECT presenter_id FROM lms_virtual_session WHERE pk_virtual_session_id=session_id;
END $$
DELIMITER ;
In Oracle I have made this as :
CREATE OR REPLACE PROCEDURE sp_get_session_presenter (session_id IN NUMBER)
IS
BEGIN
SELECT presenter_id FROM lms_virtual_session WHERE pk_virtual_session_id=session_id;
END;
/
But when executing in oracle it shows like
Warning : Procedure created with compilation errors .
Thanking you in advance
Dinny