Re: how to convert SQLserver proc to work in Oracle?

Get educated on ORACLE before you start coding with it. A couple of quick pointers. You don't need precision for the procedure arguments. You use trigger and sequence to get the same result as the the SQL server "identifyer". Migration Work Bench, a free tool from ORACLE can do a lot of conversion for you and is a quick way to learn the differences and similarities between ORACLE and SQL server.

• Jusung Yang

hakan_at_lge.com (Hakan Jakobsson) wrote in message news:<4f31a2dc.0210150150.7dce2005_at_posting.google.com>...
> Hello
>
> In SQL-server you can write a sp like this
> /*********
> CREATE PROCEDURE sp_tblname_add(
> _at_in_name VARCHAR(50),
> _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)
> GO
> *************/
>
> How do you do this in Oralce?
> 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;
> *************/
>
> but it doesn't work
> when i do 'drop procedure sp__tblname_add'
> it says 'SP_TBL NAME_ADD doesn't exist'
>
> you can also run a stored proc buy 'exec sp_name'
> how do you exec a proc in oracle?
>
> and how do you create auto id (SQLserver's Identifyer) in Oracle?
>
> i mean an id that increases itself and your not suppose to
> add id when you're inserting rows into the table.
>
> thank you very much
>
> keep on rockin'
Received on Tue Oct 15 2002 - 19:40:18 CEST