Yaerox has asked for the wisdom of the Perl Monks concerning the following question:

Developing in an CGI-Environment

# ========== my ( $hDB, $hStatement ); my ( $sDBId, $sDBStatus ); $hDB = &MyPackage::_OracleConnect( ); $hStatement = $hDB->prepare(" SELECT id, status FROM certificates WHERE url = ? "); ( $sDBId, $sDBStatus ) = $hStatement->execute( $p_sURL ); $hStatement->finish; $hDB->disconnect; # ========== print "Content-type: text/html\n\n"; print "p_sURL: #$p_sURL#<br>"; print "sDBId: #$sDBId#<br>"; print "sDBStatus: #$sDBStatus#<br>";
Output:
p_sURL: #sdsdfsfsdfsf# sDBId: #0E0# sDBStatus: ##
URL is simply an parameter and is correct. Same statement used on SQLDeveloper - Output:
ID STATUS ---------- ---------- 6 0

What is going on here?

Replies are listed 'Best First'.
Re: Perl DBI - Weird result set
by Yaerox (Scribe) on Aug 26, 2015 at 07:24 UTC
    Nevermind, I'm such a douchebag :D

    Better use fetch to get some results :D