Datawindow stored procedure retrieval argument

[rashuk]

HI,
I am using stored proecdure to build datawindow. Stored procedure takes one argument and returns ref cursor. However, when I try retrieve in datawindow, it does not pass the argument value correctly. It always sends zero.

I am using Oracle 8.1.7 and powerbuilder 7.

Here is the code from datawindow export.

table(column=(type=char(8) updatewhereclause=yes name=accid dbname="accid" )
column=(type=char(4) updatewhereclause=yes name=poolid dbname="poolid" )
column=(type=number updatewhereclause=yes name=txna dbname="txna" )
procedure="1 execute CITI_FIRECALL.SHOW_TAXBASIS_DETAILS;0 ACCID_IN='0'" arguments=(("ACCID_IN", string)) )


You can see that it has hardcoded argument value.

Thanks.

 

[royjimenezcampos]

I 'd like to see your pb source.

and does sp create #tables ?
'cause it's important.

i hope your answer.
My mail is royjimcam@hotmail.com