Stumped? Procedure Error [message #2819] |
Wed, 14 August 2002 14:54 |
Brett
Messages: 7 Registered: October 2001
|
Junior Member |
|
|
I'm not sure why but this will not compile for me at all in ORACLE 9i. Any help would be appreciated. What is missing?
Create OR Replace PROCEDURE dbo.SP_PCCGETID (@record_id int output)
AS
BEGIN
SELECT @record_id = @@IDENTITY
return 0
END ;
/
|
|
|
Re: Stumped? Procedure Error [message #2820 is a reply to message #2819] |
Wed, 14 August 2002 15:06 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Well, it is not PL/SQL code at all - that is why it isn't compiling. This looks like TSQL code that you are trying to port to Oracle.
If you can tell us what you are trying to do here, we can help you convert the code (or maybe there is a TSQL person hanging out here that can help with the translation).
|
|
|