Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Sybase > OpenServer ques...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 2407 of 2506
Post > Topic >>

OpenServer question (returning parameters)

by "Hans" <hans.kramer@[EMAIL PROTECTED] > Feb 23, 2008 at 12:34 AM

Hi,

I am trying to write an extended store procedure that returns its data via
an
output parameter, similar to what one can do with regular stored
procedures.
However, I've had no luck with it. Perhaps somebody with a better
understand
of the Sybase internals can help me out. It seems it ain't possible (wish
ASE
was open source) but I cannot believe that (I am using ASE 12.5.3)
Anyway, I get stuck with the first call to srv_descfmt. The server
replies:
"XP Server Error: 16165/10/0: srv_descfmt(): CS_SET for SRV_RPCDATA not
valid"

Here an exceprt of my code.
First I create the xp_test in ASE:

create procedure xp_test @[EMAIL PROTECTED]
 INTEGER OUTPUT AS external name "test.so"

The call I make:
declare @[EMAIL PROTECTED]
 integer 
select @[EMAIL PROTECTED]
 
exec xp_test @[EMAIL PROTECTED]
 OUTPUT 
select @[EMAIL PROTECTED]
 ESP code:
    
    CS_DATAFMT  paramfmt;
    memset(&paramfmt, (CS_INT) 0, (CS_INT) sizeof(CS_DATAFMT));

    CS_INT data = 23;

    paramfmt.namelen   = 0;
    paramfmt.datatype  = CS_INT_TYPE;
    paramfmt.format    = 0;
    paramfmt.maxlength = 4;
    paramfmt.count     = 1;
    paramfmt.locale    = NULL;
    paramfmt.status    = CS_RETURN;

    srv_descfmt(srvproc, CS_SET, SRV_RPCDATA, 1, &paramfmt);
    
    CS_INT      len = sizeof(CS_INT);
    CS_SMALLINT outlen = CS_GOODDATA;

srv_bind(srvproc, roc, CS_SET, SRV_RPCDATA, q, &paramfmt, (CS_BYTE *)
&data,
&len, &outlen);

    srv_xferdata(srvproc, CS_SET, SRV_RPCDATA)

Thanks
 




 1 Posts in Topic:
OpenServer question (returning parameters)
"Hans" <hans  2008-02-23 00:34:49 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 1:43:46 CDT 2008.