| From Sybase to Oracle [message #270566] |
Thu, 27 September 2007 09:42  |
pkrasny
Messages: 1
Registered: September 2007
|
Junior Member |
|
|
Good morning, I am trying to convert a procedure from Sybase to Oracle and can't get over the data input:
In Sybase it works like this:
CREATE PROCEDURE dbo.test (@push_cs char(8))
AS
set nocount on
BEGIN
declare @ret int
if @push_cs = 'Yes'
select @ret=0
else
select @ret=-11
select @ret
set nocount off
END
I believe in Oracle the '@' character is not used, but I am not able to make it work. Anybody can help please?
Thanks
Prokop
[Updated on: Thu, 27 September 2007 09:43] Report message to a moderator |
|
|
|
| Re: From Sybase to Oracle [message #270568 is a reply to message #270566] |
Thu, 27 September 2007 09:46  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
So you posted your sybase code. How about you post your attemot at the oracle version along wit an explanation of exactly what it is you are trying to do (so that there is no confusion)
Also, please read the stick at the top of the forum list which will show you how to correctly format a post.
Cheers
jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
