How to execute sybase stored procedure in SQL Developer with input and out put params?

Asked Nov 02 '17 at 12:15

Active Nov 28 '20 at 02:22

Viewed 2,144 times

I am working on a new Database in Sybase. I am not sure how to run sybase stored procedures from SQL Developer. I have used SQL developer before with Oracle.

my stored procedure look like this. IT is working stored procedure.

create proc stored_proc_name @string_input varchar(20)
as
declare
@ temp_string varchar(20)
select @temp_string from table where conduction
return 0
fail:
....

exec db_schema..stored_proc_name 'string_input'

Output

db_schema..stored_proc_name 'string_input' succeeded.

ITs not printing the actual output. Please help me fix my issue.

edited Nov 28 '20 at 02:22

markp-fuso

28,790
4
16
36

asked Nov 02 '17 at 12:15

VSRSarma Chinta

I am not allowed to use any other non approved softwares – VSRSarma Chinta Nov 02 '17 at 12:20
your synthax for sybase is wrong – Stivan Nov 02 '17 at 12:21
My example stored proc syntax is wrong. I am trying to run working stored proc in my test env – VSRSarma Chinta Nov 02 '17 at 12:26
If you want useful help you need to indicate everything you tried to eliminate various possible reasons for the problem. Without thay there can only be guessing. – RobV Nov 02 '17 at 23:57
Your table may have zero qualifying rows? – RobV Nov 02 '17 at 23:57
Its returning results. It has 10 rows in resultset. – VSRSarma Chinta Nov 06 '17 at 11:57
How is [PL/SQL Developer](https://www.allroundautomations.com/plsqldev.html) related to the question? – William Robertson Jan 10 '18 at 12:33

How to execute sybase stored procedure in SQL Developer with input and out put params?

0 Answers0