Sybernet / Supplied Functions Reference
Release 3.00
Oct 14, 2002

HTTP.DB_NAME

This function returns the schema name of the procedure that called it. Normally, stored procedures do not need to qualify object names with the schema name that created it (since they are both one in the same). When creating HTML form screens, however, object names within the form need to be fully qualified so that Sybernet can invoke the specified object. You can hard-wire the schema name, or use db_name to determine it at run-time.

note A procedure or function that calls db_name should not be declared with authid current_user.

Syntax

FUNCTION DB_NAME
(
)
RETURN VARCHAR2;

Parameters

Parameter	Description

Returns

A schema name.

Example

The following example illustrates how to call db_name.

http.sp_html_input
(
    type => 'HIDDEN'
,   name => 'PROCEDURE'
,   value => http.db_name() || '.' || 'SP_HTML_P1'
)   ;