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
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))
set nocount on

declare @ret int
if @push_cs = 'Yes'
select @ret=0
select @ret=-11
select @ret
set nocount off

I believe in Oracle the '@' character is not used, but I am not able to make it work. Anybody can help please?



[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
Messages: 2844
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.

Previous Topic: Send a mail with automatic
Next Topic: LOB, BLOB, CLOB (merged by LF)
Goto Forum:

Current Time: Sun Jul 23 12:14:14 CDT 2017

Total time taken to generate the page: 0.05776 seconds