Stored Procedure

From: Boah <boah123_at_hotmail.com>
Date: 6 Nov 2001 11:27:39 -0800
Message-ID: <8202c755.0111061127.69b9837a@posting.google.com>

Hello,

I have a stored procedure in my microsoft sql server 2000. This is the code:

CREATE PROCEDURE GetPortalSettings
(

    @PortalAlias   nvarchar(50),
    @TabID         int,
    @PortalID      int OUTPUT,
    @PortalName    nvarchar(128) OUTPUT,
    @AlwaysShowEditButton bit OUTPUT,
    @TabName       nvarchar (50)  OUTPUT,
    @TabOrder      int OUTPUT,
    @MobileTabName nvarchar (50)  OUTPUT,
    @AuthRoles     nvarchar (256) OUTPUT,
    @ShowMobile    bit OUTPUT

)
AS

/* First, get Out Params */
IF @TabID = 0

    SELECT TOP 1
@PortalID = Portals.PortalID,
@PortalName = Portals.PortalName,
@AlwaysShowEditButton = Portals.AlwaysShowEditButton,
@TabID = Tabs.TabID,
@TabOrder = Tabs.TabOrder,
@TabName = Tabs.TabName,
@MobileTabName = Tabs.MobileTabName,
@AuthRoles = Tabs.AuthorizedRoles,
@ShowMobile = Tabs.ShowMobile

    FROM
        Tabs
    INNER JOIN

        Portals ON Tabs.PortalID = Portals.PortalID
        
    WHERE
        PortalAlias=@PortalAlias
        
    ORDER BY
        TabOrder

ELSE
    SELECT
@PortalID = Portals.PortalID,
@PortalName = Portals.PortalName,
@AlwaysShowEditButton = Portals.AlwaysShowEditButton,
@TabName = Tabs.TabName,
@TabOrder = Tabs.TabOrder,
@MobileTabName = Tabs.MobileTabName,
@AuthRoles = Tabs.AuthorizedRoles,
@ShowMobile = Tabs.ShowMobile

    FROM
        Tabs
    INNER JOIN

        Portals ON Tabs.PortalID = Portals.PortalID
        
    WHERE
        TabID=@TabID

/* Get Tabs list */
SELECT
    TabName,
    AuthorizedRoles,
    TabID,
    TabOrder     

FROM
    Tabs     

WHERE
    PortalID = @PortalID     

ORDER BY
    TabOrder

/* Get Mobile Tabs list */
SELECT
    MobileTabName,
    AuthorizedRoles,
    TabID,
    ShowMobile     

FROM
    Tabs     

WHERE
    PortalID = @PortalID
  AND
    ShowMobile = 1     

ORDER BY
    TabOrder

/* Then, get the DataTable of module info */ SELECT
    *     

FROM
    Modules
  INNER JOIN
    ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID     

WHERE
    TabID = @TabID     

ORDER BY
    ModuleOrder

GO

Now I want to convert this to an oracle stored procedure. I do not have any experience with this.

First question: Is it possible to convert this stored procedure?

If yes, could somebody do this for me? (Offcourse, only this one)

Many Thanks!

Boah Received on Tue Nov 06 2001 - 13:27:39 CST