db_blob_get (public)

 db_blob_get [ -dbn dbn ] statement_name sql [ args... ]

Defined in packages/acs-tcl/tcl/00-database-procs.tcl

PostgreSQL only.

Switches:
-dbn (optional)
The database name to use. If empty_string, uses the default database.
Parameters:
statement_name
sql
Source code:
    ad_arg_parser { bind } $args
    set proc_name {db_blob_get}
    set driverkey [db_driverkey $dbn]

    switch $driverkey {

        postgresql {
            set full_statement_name [db_qd_get_fullname $statement_name]
            db_with_handle -dbn $dbn db {
                set data [db_exec_lob blob_get $db $full_statement_name $sql]
            }
            return $data
        }

        oracle {
            set pre_sql $sql
            set full_statement_name [db_qd_get_fullname $statement_name]
            set sql [db_qd_replace_sql $full_statement_name $pre_sql]

            # insert Tcl variable values (borrowed from Dan W - olah)
            if {$sql ne $pre_sql } {
                set sql [uplevel 2 [list subst -nobackslashes $sql]]
            }

            set data [db_string dummy_statement_name $sql]
            return $data
        }

        nsodbc -
        default {
            error "$proc_name is not supported for this database."
        }
    }
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: