Home » SQL & PL/SQL » SQL & PL/SQL » From Sybase to Oracle
From Sybase to Oracle [message #270566] Thu, 27 September 2007 09:42 Go to next message
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 Go to previous message
pablolee
Messages: 2836
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
Previous Topic: Send a mail with automatic
Next Topic: LOB, BLOB, CLOB (merged by LF)
Goto Forum:
  


Current Time: Fri Dec 09 13:55:39 CST 2016

Total time taken to generate the page: 0.11513 seconds