Hi All,
How can I call a Stored Procedure from another Stored Procedure?
Basic problem is that I have created a Stored Procedure with , which forces a SELECT statement just after
the , but before returning I need
some more processing with the result of .
I would like to call the another stored p
Hi Thomas,
It does not work.
Anhaus, Thomas wrote:
> QA wrote :
>
> >
> >Hi Elke,
> >
> >Thanks for the valuable suggestion.
> >
> >I wrote the following stored procedure onlines of your advice-
> >
> >CREATE DBPROC shortlist_month (IN
VIEW;
END;
This stored procedure compiles and works perfectly on MaxDB 7.5.00.15,
But on SapDB 7.4.3.30 it compiles but at runtime gives error -4024 and
if I put a try..catch in the stored procedure then it returns the error
-4004.
Why it is behaving like this?
Zabach, Elke wrote:
> QA
Hi SAP Team,
Is there any solution to this problem
QA wrote:
> Hi All,
>
> Can anybody provide a solution to my problem with RECURSIVE DECLARE
> STATEMENT.
>
> I am trying to explode bill of materials using Recursive DECLARE CURSOR
> statement explained in docs. Fo
n the second select the where condition is sub =
> B.main_item_code instead of main_item_code=B.sub_item_code?
The RECURSIVE CURSOR statement is directly lifted from the SAP DB docs.
Thanks for your response.
- Original Message -
From: "Matteo Gattoni" <[EMAIL PROTECTED]>
Hi All,
Can anybody provide a solution to my problem with RECURSIVE DECLARE
STATEMENT.
I am trying to explode bill of materials using Recursive DECLARE CURSOR
statement explained in docs. Following is the stored procedure-
CREATE DBPROC bom (IN main_item VARCHAR(25)) RETURNS CURSOR AS
$CUR
definition of the dbproc.
Platform- Win2K SP4.
Thanks,
- Original Message -
From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "'QA'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 05, 2004 4:19 PM
Subject: AW: Recursive DECLARE CURSOR st
> > (DECLARE keyword is highlighted in SQL Studio).
>
> > DECLARE :$CURSOR CURSOR FOR
> ^
> DECLARE $CURSOR
>
Hi Jean-Michel,
Thanks for your prompt reply, but it does not work.
I am using SAPDB 7.4.03.30 on W2K SP4.
Hi,
I am trying to explode bill of materials using Recursive DECLARE CURSOR
statement explained in docs. Following is the stored procedure-
CREATE DBPROC bom (IN main_item VARCHAR(25)) RETURNS CURSOR AS
$CURSOR = 'bom';
BEGIN
DECLARE :$CURSOR CURSOR FOR
WITH RECURSIVE PX (main
