Sybernet / Supplied Procedures Reference Release 3.00 Mar 12, 2005

HTTP.SP_HTML_UPLOAD

Sybernet Upload allows you submit batch files or scripts to Oracle and Sybase. Usually what this means is you are working on a stored procedure in your favorite editor. You would then use this application to upload your changes each time you make and save your changes. Alter scripts created by Application Designer are suitable for upload as well.

Batch commands can be separated by go or a forward slash. The former is a Sybase convention; the latter is an Oracle convention. Comments (either C-style comments or PL/SQL comments) are unconditionally stripped from the beginning of each command. Redundant batch separators (go or /) are allowed. GO immediately followed by an exclamation mark (go!) means continue to the next command even if the last command failed.

Input Fields

Browse

Submit

Example

The following example illustrates a typcial batch file for Sybase:

use http
go
drop procedure sp_html_HelloWorld
go
create procedure sp_html_HelloWorld
as
begin
    select 'Hello World'
    return
end
go
grant execute on sp_html_HelloWorld to public
go

See Also