Sybernet / Supplied Procedures Reference
Release 3.00
Oct 14, 2002

HTTP.SP_RECOMPILE

This application program recompiles all invalid objects in the current schema. It loops until all objects that can be compiled are compiled.

Syntax

Procedure SP_RECOMPILE
(
    OWNER                         VARCHAR2
,   DEBUG                         VARCHAR2
)   ;

Parameters

Parameter	Description
owner	Determines what schema is recompiled. If unspecified, compiles in the local schema. If specified, compiles in that schema. If NULL, compiles all schemas. If you are running this through Sybercron to recompile all schemas, leave this blank.
debug	Determines what to do if a compilation error occurs. FALSE (just say object did not compile). TRUE (show errors why object did not copile). The default is FALSE.

Example

The following example illustrates the output of sp_recompile:

SP_RECOMPILE (OWNER=>'HTTP')



Compiling HTTP.EXAMPLE3...

Compiling HTTP.SP_HTML_ADDUSER...

Compiling HTTP.SP_HTML_CRON_MONITOR...

Compiling HTTP.SP_HTML_CRON_REGISTER...

Compiling HTTP.SP_HTML_GRANT...

Compiling HTTP.SP_HTML_HELPTEXT...

Compiling HTTP.SP_HTML_ISQL_NEW...

Compiling HTTP.SP_HTML_LEIBNITZ...

Compiling HTTP.SP_HTML_LOAN_CALCULATOR...

Compiling HTTP.SP_HTML_PREFERENCES_FORM...

Compiling HTTP.SP_HTML_PROCMAN...

Compiling HTTP.SP_HTML_UPLOAD_EXAMPLE_2...

Compiling HTTP.SP_HTML_UPLOAD_EXAMPLE_3...

Compiling HTTP.SP_HTML_UPLOAD_EXAMPLE_4...

Compiling HTTP.SP_HTML_WHITEPAGES...

Compiling HTTP.VI...



End of pass 1 (16 invalid objects and 0 did not compile)





Success!