how to convert SQLserver proc to work in Oracle?
Date: 15 Oct 2002 02:50:26 -0700
Message-ID: <4f31a2dc.0210150150.7dce2005_at_posting.google.com>
Hello
In SQL-server you can write a sp like this
/*********
How do you do this in Oralce?
/*********
but it doesn't work
CREATE PROCEDURE sp_tblname_add(
_at_in_name VARCHAR(50),
GO
_at_in_email VARCHAR(100),
_at_in_headline VARCHAR(200),
_at_in_text VARCHAR(1000))
AS
INSERT INTO tbl_name (name,email,headline,text)
VALUES(_at_in_name,_at_in_email,_at_in_headline,_at_in_text)
*************/
i tryed with: (im using T.O.A.D)
CREATE PROCEDURE sp_tblname_add(
in_name IN VARCHAR2(50),
in_email IN VARCHAR2(100),
in_headline IN VARCHAR2(200),
in_text IN VARCHAR2(1000))
AS
BEGIN
INSERT INTO tbl_name (name,email,headline,text)
VALUES(in_name,in_email,in_headline,in_text);
END sp_bbs_add;
*************/
you can also run a stored proc buy 'exec sp_name' how do you exec a proc in oracle?
thank you very much
keep on rockin'
-- Kind Regards Hakan Jakobsson System Developer LGESE IT DepartmentReceived on Tue Oct 15 2002 - 11:50:26 CEST