topic Store Procedures? in Application Development and Automation Discussions

Store Procedures?

Former Member — Fri, 02 Apr 2004 17:33:32 GMT

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.

Re: Store Procedures?

Former Member — Mon, 05 Apr 2004 09:27:41 GMT

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

Re: Store Procedures?

Former Member — Wed, 21 Apr 2004 13:42:48 GMT

Hi Alberto,

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

Cheers.

Re: Store Procedures?

Former Member — Wed, 21 Apr 2004 19:46:45 GMT

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.

Re: Store Procedures?

Former Member — Fri, 23 Apr 2004 09:42:53 GMT

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

Re: Store Procedures?

Former Member — Fri, 23 Apr 2004 15:58:07 GMT

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 ?

Re: Store Procedures?

Former Member — Fri, 23 Apr 2004 16:14:36 GMT

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.

Re: Store Procedures?

Former Member — Mon, 26 Apr 2004 08:48:50 GMT

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.

Re: Store Procedures?

Peter_Inotai — Wed, 28 Apr 2004 15:47:33 GMT

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