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;