var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: executing stored procedure from powerbuilder 9
I'm trying to execute simple stored procedure on SQL Server from Powerbuilder 9 development environment and procedure returns 0 in output parameter, not what I was expecting.
Stored procedure is:
create procedure manta_sequence_proc
@sequence_id numeric(19,9) OUTPUT
SET NOCOUNT ON
Begin Tran seq
update manta_squrence set sequence_id=sequence_id+1 where sequence_name = @sequence_name
Commit Tran seq
select @sequence_id = sequence_id from manta_sequence where sequence_name = @sequence_name
-- print 'name' + @sequence_name
-- print 'id' + str(@sequence_id)
SET NOCOUNT OFF /* Enable all rows affected messages */
Power builder call to procedure is:
ls_sequence_name = 'TEST'
declare manta_sequence procedure for manta_sequence_proc
@sequence_name = :ls_sequence_name,
@sequence_id = :ll_sequence_id output;
// it shows 0 not en expected number
Can anyone help?