Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

pass BOuser to Oracle SP

I create a stored procedure in SQL server and write a Crystal report off this. And the user does not get asked for BOUSER it just automatically does it. I can not get the same to work in Oracle. Can someone tell me what I'm doing wrong in Oracle. Or is it a limitation. I do not want the user to be prompted. This is for row level security. Oracle 10g, SQL Server 2005. Crystal 2008

SQL Server

ALTER PROCEDURE [dbo].[sp_test123]

@BOUSER varchar(50)

AS

SELECT *

FROM

dbo.TEST

where @BOUSER=BOuser

Oracle

create or replace PROCEDURE Test_Procedure (

Test_Cursor IN OUT Test_Package.Test_Type,

BOuser in varchar2)

AS

BEGIN

OPEN Test_Cursor FOR

SELECT *

FROM Test

WHERE Test.BUSER = BOuser;

END Test_Procedure;

Not what you were looking for? View more on this topic or Ask a question