Store Procedures?

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Alberto,

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

Cheers.

[Former Member]

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.

[Former Member]

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

[Former Member]

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 ?

[Former Member]

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.

[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.

[Peter_Inotai]

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