Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

EMBEDDED SQL STORE PROCEDURE CALL

2 posts in General Discussion Last posting was on 2003-10-28 14:20:54.0Z
M. Ravari Posted on 2003-10-27 23:29:56.0Z
From: "M. Ravari" <majid@lablogics.com>
Newsgroups: ianywhere.public.general
Subject: EMBEDDED SQL STORE PROCEDURE CALL
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
NNTP-Posting-Host: acc0ca78.ipt.aol.com
X-Original-NNTP-Posting-Host: acc0ca78.ipt.aol.com
Message-ID: <3f9db884$1@forums-1-dub>
Date: 27 Oct 2003 16:29:56 -0700
X-Trace: forums-1-dub 1067300996 172.192.202.120 (27 Oct 2003 16:29:56 -0700)
X-Original-Trace: 27 Oct 2003 16:29:56 -0700, acc0ca78.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1929
Article PK: 4164

I am using the following statement to call stored procedure:
sp_invoiceBreakDown(long invid) where
it returns no results:

EXEC SQL CALL sp_invoiceBreakDown(:q_invID);

where q_invID is a long holding the invoice id.

but when i run it the information is not added to table
invoiceTransInfo.
however, when I run it from dbisql it works as follows:

call sp_invoicebreakdown '326183'


Greg Fenton Posted on 2003-10-28 14:20:54.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: EMBEDDED SQL STORE PROCEDURE CALL
References: <3f9db884$1@forums-1-dub>
In-Reply-To: <3f9db884$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3f9e8956$1@forums-1-dub>
Date: 28 Oct 2003 07:20:54 -0700
X-Trace: forums-1-dub 1067354454 172.31.140.253 (28 Oct 2003 07:20:54 -0700)
X-Original-Trace: 28 Oct 2003 07:20:54 -0700, gfenton-xp.sybase.com
Lines: 32
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1933
Article PK: 4172


M. Ravari wrote:
>
> EXEC SQL CALL sp_invoiceBreakDown(:q_invID);
>

Please, always post the version and build number of ASA that you are
using (e.g. use the command "dbeng9 -v" for ASA 9.0)

Can you add a "MESSAGE" statement to your stored procedure to see what
value(s) it has when you are executing it? Assuming your parameter is
called "@invID", then you might try:

MESSAGE 'invID is ' || @invID TO CONSOLE;

This output will appear in the database console window whenever the
stored procedure is run. You might want to prepend that string a NOW()
call so you can see the date/time the msg was printed.

Alternatively, you can you use the database object debugger to trace
through the stored procedure as it is running to see if the right data
is getting to the stored procedure.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/