|
|
sybperl-l Archive
Up Prev Next
From: Ronald Page <Ron dot Page at asu dot edu>
Subject: RE: stored procedures
Date: Jan 8 1998 3:43PM
For some reason this question I sent and in fact no notes since 1/2/98
have come back to me.
However, after looking at Michael's home page, I figured out the using
ct_command, ct_send, and ct_param is the way to go.
Ronald Page
Voice: (602) 965-2986
Electronic Messaging Applications & Consulting Fax: (602)
965-0028
Arizona State University
Email: Ron.Page@asu.edu
Tempe, Arizona 85287-0101
http://www.public.asu.edu/~ronpage
> -----Original Message-----
> From: Ronald Page
> Sent: Tuesday, January 06, 1998 3:34 PM
> To: 'SYBPERL-L@trln.lib.unc.edu'
> Subject: stored procedures
>
> Is it possible to execute a stored procedure using "ct_sql"? Or
> perhaps I should ask, what is the correct way to execute stored
> procedures using ctlib?
>
>
> For example, using embedded SQL and C, the following works:
>
> EXEC SQL EXEC :rc = insert_identity :electronic_identity_key
> output,
> 1.0, :account_name, "sparky",
> :now;
>
> What I don't see is how one would specify the return and output
> variables in Perl/SybPerl. I've tried various combinations including
>
> $ref = $db->ct_sql("exec \$rc=insert_identity
> \$electronic_identity_key output, 1.0, \"sparky\", \"$now\"");
>
> Any pointers? Thanks in advance.
>
> --
> Ronald Page
> Information Technology
> Arizona State University
|
