how to get OUtPUT value from stored procedure. 1

[kmsam2]

I code like below, but I can't get the value. I had tested my stored procedure, it can return value, but not in PB.
Please help!
Sam.

string ls_output=''

DECLARE xp_get_user PROCEDURE FOR xp_get_user @@username=:ls_output output
using sqlca;
execute xp_get_user;

messagebox('ls_output',ls_output)


Sam.

 

[leyka]

Try this:

http://sybooks.sybase.com/onlineboo...@Generic__BookTextView/12059;pt=12644;lang=de

----------
gruss aus Deutschland

 

[mbalent]

A very easy way to retrieve results from a stored proc is to create a datawindow which uses it. No messy Powerscript declare or execute statements, etc - just a simple dw.retrieve().

 

[bubbly]

Else wat u could do is

string ls_output=''

initialize the variable as
string ls_output= space(255)

this would do the needful

 

[NoahsArk]

add this after the execute
FETCH xp_get_user INTO :ls_output;