Convert stored procedure

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

CREATE PROCEDURE GetPortalSettings
(

    _at_PortalAlias   nvarchar(50),
    _at_TabID         int,
    _at_PortalID      int OUTPUT,
    _at_PortalName    nvarchar(128) OUTPUT,
    _at_AlwaysShowEditButton bit OUTPUT,
    _at_TabName       nvarchar (50)  OUTPUT,
    _at_TabOrder      int OUTPUT,
    _at_MobileTabName nvarchar (50)  OUTPUT,
    _at_AuthRoles     nvarchar (256) OUTPUT,
    _at_ShowMobile    bit OUTPUT

/* First, get Out Params */
IF _at_TabID = 0

    SELECT TOP 1
_at_PortalID = Portals.PortalID,
_at_PortalName = Portals.PortalName,
_at_AlwaysShowEditButton = Portals.AlwaysShowEditButton,
_at_TabID = Tabs.TabID,
_at_TabOrder = Tabs.TabOrder,
_at_TabName = Tabs.TabName,
_at_MobileTabName = Tabs.MobileTabName,
_at_AuthRoles = Tabs.AuthorizedRoles,
_at_ShowMobile = Tabs.ShowMobile

    FROM
        Tabs
    INNER JOIN

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

ELSE
    SELECT
_at_PortalID = Portals.PortalID,
_at_PortalName = Portals.PortalName,
_at_AlwaysShowEditButton = Portals.AlwaysShowEditButton,
_at_TabName = Tabs.TabName,
_at_TabOrder = Tabs.TabOrder,
_at_MobileTabName = Tabs.MobileTabName,
_at_AuthRoles = Tabs.AuthorizedRoles,
_at_ShowMobile = Tabs.ShowMobile

    FROM
        Tabs
    INNER JOIN

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

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

FROM
    Tabs     

WHERE
    PortalID = _at_PortalID     

ORDER BY
    TabOrder

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

FROM
    Tabs     

WHERE
    PortalID = _at_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 = _at_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 - 20:28:35 CET