prorm API Reference
    Preparing search index...

    Interface CreateProcedureOptions

    Enhanced stored procedure options with full PL/SQL support

    interface CreateProcedureOptions {
        name: string;
        schema?: string;
        params?: StoredProcedureParam[];
        body: string;
        replace?: boolean;
        ifNotExists?: boolean;
        comment?: string;
    }
    Index
    name schema? params? body replace? ifNotExists? comment?
    name: string

    Procedure name

    schema?: string

    Schema where the procedure belongs

    params?: StoredProcedureParam[]

    Parameters

    body

    body: string

    Procedure body (SQL statements)

    replace?: boolean

    If true, drops existing procedure first

    ifNotExists?: boolean

    If true, does not throw if already exists

    comment?: string

    Optional comment

    Settings
    Member Visibility

    On This Page
    Properties