Skip to Content
avatar image
Former Member

Store Procedures?

Hi, i have one locking about the Store Procedures and

SAP, i use the SP with Access and ASP, SQL Server, but with SAP, abap 4.6c and Oracle, i don't see:

1; Where i create?

2; Where i check it?

3; Where i save the SP?

On the help, i only see how i call the SP, but don't see on wich transactions i can do all the things above.

Hope some can help with these topic, Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Apr 05, 2004 at 09:27 AM

    Being an SAP developer all my life, I know nothing about stored procedures except that they are not a technology that the ABAP workbench directly supports.

    Of course, I imagine you can always embed native SQL within your ABAP to invoke the stored procedure directly.

    Scott

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2004 at 01:42 PM

    Hi Alberto,

    I agree with Scott, you can still make use of Stored procedure using the EXEC SQL in ABAP.

    Cheers.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2004 at 07:46 PM

    Yes, i see that instruction, but...

    Where in workbench i make the SP?

    Where i save my SP?

    I see that is not to normal to use the SP on ABAP, i want to, because i know that they are more faster than make the query directly on the program.

    But well lets do it like all the people.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2004 at 09:42 AM

    Alberto,

    It seems tempting to create SP in the database. However this is not recommended. SAP provides an abstract layer between the SAP system and the underlying database.

    Is there a performance problem with one of the queries? Which one?

    Regards,

    Harald

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2004 at 03:58 PM

    Alberto.

    I'm agree with the others. Performance in a SQL stament isn´t reason enough to try more than:

    EXEC.

    • Native SQL

    select....

    ....

    ENDEXEC.

    What is the real performance problem in your ABAP program ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2004 at 04:14 PM

    Well, like i tell you, iam new to ABAP, i can from ASP with SQL SERVER, and is normal to use SP to accelerate the QUERYS to the database and Paging the results. Paging is the main reason, and i was thinking that if i can apply the same logic in ABAP?

    There is way i was asking about. Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You can still create your SP using the Query Analyser/PL*SQL and call/pass parameters using the EXEC SQL command in ABAP (do it outside of SAP). I also came from the same developement background as yours few years back. What I can tell you is that life is easier using ABAP. No need to code so much and sometimes, simple standard SQL statement will do the trick. Beside, SAP also discourage developers to use SQL stmts that are specific to a single RDBMS due to cross platform issues.

      Cheers.

  • Apr 28, 2004 at 03:47 PM

    I wouldn't create/call stored procedure.

    The main reason, that we usually delete them as part of system maintenance, since the standard/system stored procedures will be recreated by the kernel.

    From the otherhand I don't think there would be any SAP support for this.

    Incho

    Add comment
    10|10000 characters needed characters exceeded