Sybernet / Supplied Functions Reference
Release 3.00
Oct 14, 2002

HTTP.OBJECT_ID

This function returns the OBJECT_ID of any valid or invalid object. This function also recognizes both Sybase and Oracle naming conventions.

FUNCTION OBJECT_ID
(
    OBJECTNAME                    VARCHAR2
)
RETURN NUMBER;

Parameter	Description
objectname	The case-insensitive name of the object.

The OBJECT_ID of this object or NULL if not found.

The following example illustrates how to retrieve the object_id using Sybase naming conventions:

select http.object_id('HTTP.dbo.HTTP_REGISTER') from dual;

The following example illustrates how to retrieve the object_id using Oracle naming conventions:

select http.object_id('HTTP.HTTP_REGISTER@ORAPROD') from dual;