Waring:oci_bind_by_name invalid variable used for bind #7792

lcp0578 · 2019-08-07T13:25:15Z

Bug Report

Q	A
BC Break	yes/no
Version	2.6.3

Summary

Current behavior

How to reproduce

entity:

namespace SwapBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**

PreApasinfo

@Orm\Table(name="PRE_APASINFO", options={"comment":"登记(申报)信息表"})

@Orm\Entity
/
class PreApasinfo
{
/*

@var string

@Orm\Column(name="PROJID", type="string", length=50, options={"comment":"申办号"})

@Orm\Id

@Orm\GeneratedValue(strategy="NONE")
*/
private $projid;

/**

@var integer

@Orm\Column(name="DATAVER", type="smallint", options={"comment":"数据库版本号,默认为1,信息变更,版本号递增"})
*/
private $dataver = '1';

/**

@var string

@Orm\Column(name="PROJPWD", type="string", length=6, nullable=false, options={"comment":"查询密码"})
*/
private $projpwd;

/**

@var string

@Orm\Column(name="ITEMNO", type="string", length=50, nullable=false, options={"comment":"申请事项编码"})
*/
private $itemno;

/**

@var integer

@Orm\Column(name="ITEMVERSION", type="integer", nullable=true, options={"comment":"事项版本号"})
*/
private $itemversion;

/**

@var string

@Orm\Column(name="ITEMNAME", type="string", length=200, nullable=false, options={"comment":"审批事项名称"})
*/
private $itemname;

/**

@var string

@Orm\Column(name="PROJECTNAME", type="string", length=200, nullable=false, options={"comment":"申报名称"})
*/
private $projectname;

/**

@var string

@Orm\Column(name="PROJECTSTATE", type="string", length=2, nullable=true, options={"comment":"办件状态"})
*/
private $projectstate;

/**

@var string

@Orm\Column(name="INFOTYPE", type="string", length=1, nullable=false, options={"comment":"办件类型,1办件,2承诺件,3联办件,4上报件"})
*/
private $infotype;

/**

@var string

@Orm\Column(name="APPLYNAME", type="string", length=100, nullable=false, options={"comment":"申报者名称,如为个人,则填写姓名;如为法人,则写单位名称"})
*/
private $applyname;

/**

@var string

@Orm\Column(name="APPLY_CARDTYPE", type="string", length=1, nullable=true, options={"comment":"申报者证件类型"})
*/
private $applyCardtype;

/**

@var string

@Orm\Column(name="APPLY_CARDTYPENUMBER", type="string", length=100, nullable=true, options={"comment":"申报者证件号码"})
*/
private $applyCardtypenumber;

/**

@var string

@Orm\Column(name="CONTACTMAN", type="string", length=500, nullable=false, options={"comment":"联系人/代理人姓名"})
*/
private $contactman;

/**

@var string

@Orm\Column(name="CONTACTMAN_CARDTYPE", type="string", length=1, nullable=true, options={"comment":"联系人/代理人证件类型"})
*/
private $contactmanCardtype;

/**

@var string

@Orm\Column(name="CONTACTMAN_CARDNUMBER", type="string", length=100, nullable=true, options={"comment":"联系人/代理人证件号码"})
*/
private $contactmanCardnumber;

/**

@var string

@Orm\Column(name="TELPHONE", type="string", length=18, nullable=true, options={"comment":"联系人手机号码"})
*/
private $telphone;

/**

@var string

@Orm\Column(name="POSTCODE", type="string", length=6, nullable=true, options={"comment":"邮编"})
*/
private $postcode;

/**

@var string

@Orm\Column(name="ADDRESS", type="string", length=200, nullable=true, options={"comment":"通讯地址"})
*/
private $address;

/**

@var string

@Orm\Column(name="LEGALMAN", type="string", length=30, nullable=true, options={"comment":"法人代表"})
*/
private $legalman;

/**

@var string

@Orm\Column(name="DEPTID", type="string", length=12, nullable=false, options={"comment":"收件部门编码"})
*/
private $deptid;

/**

@var string

@Orm\Column(name="DEPTNAME", type="string", length=50, nullable=true, options={"comment":"收件部门名称"})
*/
private $deptname;

/**

@var string

@Orm\Column(name="RECEIVE_USEID", type="string", length=50, nullable=true, options={"comment":"创建用户标识"})
*/
private $receiveUseid;

/**

@var string

@Orm\Column(name="RECEIVE_NAME", type="string", length=200, nullable=true, options={"comment":"创建用户名称"})
*/
private $receiveName;

/**

@var string

@Orm\Column(name="APPLYFROM", type="string", length=10, nullable=false, options={"comment":"申报来源,源头为网上,窗口,其它"})
*/
private $applyfrom;

/**

@var \DateTime

@Orm\Column(name="RECEIVETIME", type="date", nullable=false, options={"comment":"申报时间"})
*/
private $receivetime;

/**

@var string

@Orm\Column(name="APPROVE_TYPE", type="string", length=2, nullable=false, options={"comment":"审批类型"})
*/
private $approveType;

/**

@var string

@Orm\Column(name="REGION_ID", type="string", length=6, nullable=false, options={"comment":"行政区划"})
*/
private $regionId = '370100';

/**

@var string

@Orm\Column(name="DATASTATE", type="string", length=1, nullable=false, options={"comment":"数据状态,0为作废,1为有效"})
*/
private $datastate = '1';

/**

@var string

@Orm\Column(name="CREATE_TIME", type="string", length=20, nullable=false, options={"comment":"数据产生时间"})
*/
private $createTime;

/**

@var \DateTime

@Orm\Column(name="MAKETIME", type="date", nullable=false, options={"comment":"数据存库时间"})
*/
private $maketime = 'SYSDATE';

/**

@var string

@Orm\Column(name="SIGNSTATE", type="string", length=1, nullable=false, options={"comment":"标志位,数据推送置为0,已被获取后置为1"})
*/
private $signstate = '0';

/**

@var string

@Orm\Column(name="BUSINESS_SUBJECT_TYPE", type="string", length=1, nullable=false, options={"comment":"主体类型"})
*/
private $businessSubjectType;

/**

@var string

@Orm\Column(name="BUSINESS_SUBJECT_INFO", type="text", nullable=false, options={"comment":"主体基本信息"})
*/
private $businessSubjectInfo;

/**

@var string

@Orm\Column(name="ITEM_ROWGUID", type="string", length=50, nullable=true, options={"comment":"权利内部编码"})
*/
private $itemRowguid;

/**

Set projid

@param string $projid

@return PreApasinfo
*/
public function setProjid($projid)
{
$this->projid = $projid;

return $this;
}

/**

Get projid

@return string
*/
public function getProjid()
{
return $this->projid;
}

/**

Set dataver

@param integer $dataver

@return PreApasinfo
*/
public function setDataver($dataver)
{
$this->dataver = $dataver;

return $this;
}

/**

Get dataver

@return integer
*/
public function getDataver()
{
return $this->dataver;
}

/**

Set projpwd

@param string $projpwd

@return PreApasinfo
*/
public function setProjpwd($projpwd)
{
$this->projpwd = $projpwd;

return $this;
}

/**

Get projpwd

@return string
*/
public function getProjpwd()
{
return $this->projpwd;
}

/**

Set itemno

@param string $itemno

@return PreApasinfo
*/
public function setItemno($itemno)
{
$this->itemno = $itemno;

return $this;
}

/**

Get itemno

@return string
*/
public function getItemno()
{
return $this->itemno;
}

/**

Set itemversion

@param integer $itemversion

@return PreApasinfo
*/
public function setItemversion($itemversion)
{
$this->itemversion = $itemversion;

return $this;
}

/**

Get itemversion

@return integer
*/
public function getItemversion()
{
return $this->itemversion;
}

/**

Set itemname

@param string $itemname

@return PreApasinfo
*/
public function setItemname($itemname)
{
$this->itemname = $itemname;

return $this;
}

/**

Get itemname

@return string
*/
public function getItemname()
{
return $this->itemname;
}

/**

Set projectname

@param string $projectname

@return PreApasinfo
*/
public function setProjectname($projectname)
{
$this->projectname = $projectname;

return $this;
}

/**

Get projectname

@return string
*/
public function getProjectname()
{
return $this->projectname;
}

/**

Set projectstate

@param string $projectstate

@return PreApasinfo
*/
public function setProjectstate($projectstate)
{
$this->projectstate = $projectstate;

return $this;
}

/**

Get projectstate

@return string
*/
public function getProjectstate()
{
return $this->projectstate;
}

/**

Set infotype

@param string $infotype

@return PreApasinfo
*/
public function setInfotype($infotype)
{
$this->infotype = $infotype;

return $this;
}

/**

Get infotype

@return string
*/
public function getInfotype()
{
return $this->infotype;
}

/**

Set applyname

@param string $applyname

@return PreApasinfo
*/
public function setApplyname($applyname)
{
$this->applyname = $applyname;

return $this;
}

/**

Get applyname

@return string
*/
public function getApplyname()
{
return $this->applyname;
}

/**

Set applyCardtype

@param string $applyCardtype

@return PreApasinfo
*/
public function setApplyCardtype($applyCardtype)
{
$this->applyCardtype = $applyCardtype;

return $this;
}

/**

Get applyCardtype

@return string
*/
public function getApplyCardtype()
{
return $this->applyCardtype;
}

/**

Set applyCardtypenumber

@param string $applyCardtypenumber

@return PreApasinfo
*/
public function setApplyCardtypenumber($applyCardtypenumber)
{
$this->applyCardtypenumber = $applyCardtypenumber;

return $this;
}

/**

Get applyCardtypenumber

@return string
*/
public function getApplyCardtypenumber()
{
return $this->applyCardtypenumber;
}

/**

Set contactman

@param string $contactman

@return PreApasinfo
*/
public function setContactman($contactman)
{
$this->contactman = $contactman;

return $this;
}

/**

Get contactman

@return string
*/
public function getContactman()
{
return $this->contactman;
}

/**

Set contactmanCardtype

@param string $contactmanCardtype

@return PreApasinfo
*/
public function setContactmanCardtype($contactmanCardtype)
{
$this->contactmanCardtype = $contactmanCardtype;

return $this;
}

/**

Get contactmanCardtype

@return string
*/
public function getContactmanCardtype()
{
return $this->contactmanCardtype;
}

/**

Set contactmanCardnumber

@param string $contactmanCardnumber

@return PreApasinfo
*/
public function setContactmanCardnumber($contactmanCardnumber)
{
$this->contactmanCardnumber = $contactmanCardnumber;

return $this;
}

/**

Get contactmanCardnumber

@return string
*/
public function getContactmanCardnumber()
{
return $this->contactmanCardnumber;
}

/**

Set telphone

@param string $telphone

@return PreApasinfo
*/
public function setTelphone($telphone)
{
$this->telphone = $telphone;

return $this;
}

/**

Get telphone

@return string
*/
public function getTelphone()
{
return $this->telphone;
}

/**

Set postcode

@param string $postcode

@return PreApasinfo
*/
public function setPostcode($postcode)
{
$this->postcode = $postcode;

return $this;
}

/**

Get postcode

@return string
*/
public function getPostcode()
{
return $this->postcode;
}

/**

Set address

@param string $address

@return PreApasinfo
*/
public function setAddress($address)
{
$this->address = $address;

return $this;
}

/**

Get address

@return string
*/
public function getAddress()
{
return $this->address;
}

/**

Set legalman

@param string $legalman

@return PreApasinfo
*/
public function setLegalman($legalman)
{
$this->legalman = $legalman;

return $this;
}

/**

Get legalman

@return string
*/
public function getLegalman()
{
return $this->legalman;
}

/**

Set deptid

@param string $deptid

@return PreApasinfo
*/
public function setDeptid($deptid)
{
$this->deptid = $deptid;

return $this;
}

/**

Get deptid

@return string
*/
public function getDeptid()
{
return $this->deptid;
}

/**

Set deptname

@param string $deptname

@return PreApasinfo
*/
public function setDeptname($deptname)
{
$this->deptname = $deptname;

return $this;
}

/**

Get deptname

@return string
*/
public function getDeptname()
{
return $this->deptname;
}

/**

Set receiveUseid

@param string $receiveUseid

@return PreApasinfo
*/
public function setReceiveUseid($receiveUseid)
{
$this->receiveUseid = $receiveUseid;

return $this;
}

/**

Get receiveUseid

@return string
*/
public function getReceiveUseid()
{
return $this->receiveUseid;
}

/**

Set receiveName

@param string $receiveName

@return PreApasinfo
*/
public function setReceiveName($receiveName)
{
$this->receiveName = $receiveName;

return $this;
}

/**

Get receiveName

@return string
*/
public function getReceiveName()
{
return $this->receiveName;
}

/**

Set applyfrom

@param string $applyfrom

@return PreApasinfo
*/
public function setApplyfrom($applyfrom)
{
$this->applyfrom = $applyfrom;

return $this;
}

/**

Get applyfrom

@return string
*/
public function getApplyfrom()
{
return $this->applyfrom;
}

/**

Set receivetime

@param \DateTime $receivetime

@return PreApasinfo
*/
public function setReceivetime($receivetime)
{
$this->receivetime = $receivetime;

return $this;
}

/**

Get receivetime

@return \DateTime
*/
public function getReceivetime()
{
return $this->receivetime;
}

/**

Set approveType

@param string $approveType

@return PreApasinfo
*/
public function setApproveType($approveType)
{
$this->approveType = $approveType;

return $this;
}

/**

Get approveType

@return string
*/
public function getApproveType()
{
return $this->approveType;
}

/**

Set regionId

@param string $regionId

@return PreApasinfo
*/
public function setRegionId($regionId)
{
$this->regionId = $regionId;

return $this;
}

/**

Get regionId

@return string
*/
public function getRegionId()
{
return $this->regionId;
}

/**

Set datastate

@param string $datastate

@return PreApasinfo
*/
public function setDatastate($datastate)
{
$this->datastate = $datastate;

return $this;
}

/**

Get datastate

@return string
*/
public function getDatastate()
{
return $this->datastate;
}

/**

Set createTime

@param string $createTime

@return PreApasinfo
*/
public function setCreateTime($createTime)
{
$this->createTime = $createTime;

return $this;
}

/**

Get createTime

@return string
*/
public function getCreateTime()
{
return $this->createTime;
}

/**

Set maketime

@param \DateTime $maketime

@return PreApasinfo
*/
public function setMaketime($maketime)
{
$this->maketime = $maketime;

return $this;
}

/**

Get maketime

@return \DateTime
*/
public function getMaketime()
{
return $this->maketime;
}

/**

Set signstate

@param string $signstate

@return PreApasinfo
*/
public function setSignstate($signstate)
{
$this->signstate = $signstate;

return $this;
}

/**

Get signstate

@return string
*/
public function getSignstate()
{
return $this->signstate;
}

/**

Set businessSubjectType

@param string $businessSubjectType

@return PreApasinfo
*/
public function setBusinessSubjectType($businessSubjectType)
{
$this->businessSubjectType = $businessSubjectType;

return $this;
}

/**

Get businessSubjectType

@return string
*/
public function getBusinessSubjectType()
{
return $this->businessSubjectType;
}

/**

Set businessSubjectInfo

@param string $businessSubjectInfo

@return PreApasinfo
*/
public function setBusinessSubjectInfo($businessSubjectInfo)
{
$this->businessSubjectInfo = $businessSubjectInfo;

return $this;
}

/**

Get businessSubjectInfo

@return string
*/
public function getBusinessSubjectInfo()
{
return $this->businessSubjectInfo;
}

/**

Set itemRowguid

@param string $itemRowguid

@return PreApasinfo
*/
public function setItemRowguid($itemRowguid)
{
$this->itemRowguid = $itemRowguid;

return $this;
}

/**

Get itemRowguid

@return string
*/
public function getItemRowguid()
{
return $this->itemRowguid;
}
}

command

$preApasinfo = new PreApasinfo();
$preApasinfo->setProjid('10');
$preApasinfo->setProjpwd('234765');
$preApasinfo->setItemno('1000200010000');
$preApasinfo->setItemname('律师执业许可');
$preApasinfo->setProjectname('关于宋家辉的律师执业许可');
$preApasinfo->setProjectstate('05');
$preApasinfo->setInfotype('4');
$preApasinfo->setApplyname('宋家辉');
$preApasinfo->setApplyCardtype('1');
$preApasinfo->setApplyCardtypenumber('140721199507130033');
$preApasinfo->setContactman('宋家辉');
$preApasinfo->setDeptid('140100');
$preApasinfo->setDeptname('小店区司法局');
$preApasinfo->setApplyfrom('网上');
$preApasinfo->setReceivetime(new \DateTime());
$preApasinfo->setApproveType('01');
$preApasinfo->setBusinessSubjectType('1');
$preApasinfo->setBusinessSubjectInfo('{1}');
$preApasinfo->setDatastate('1');
$preApasinfo->setCreateTime(new \DateTime());
$preApasinfo->setMaketime(new \DateTime());
$preApasinfo->setDataver(1);
$em = $this->getOracleEm();
$em->persist($preApasinfo);
$em->flush();

Expected behavior

lcp0578 · 2019-08-07T13:50:15Z

debug.
vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/OCI8/OCI8Statement.php

/**
* {@inheritdoc}
*/
public function bindParam($column, &$variable, $type = ParameterType::STRING, $length = null)
{
$column = $this->_paramMap[$column] ?? $column;

    if ($type === ParameterType::LARGE_OBJECT) {
        $lob = oci_new_descriptor($this->_dbh, OCI_D_LOB);
        $lob->writeTemporary($variable, OCI_TEMP_BLOB);

        $variable =& $lob;
    }

    $this->boundValues[$column] =& $variable;
    
    dump($type);
    dump($column);
    dump($variable);
    return oci_bind_by_name(
        $this->_sth,
        $column,
        $variable,
        $length ?? -1,
        $this->convertParameterType($type)
    );
}

output:

Doctrine\DBAL\Schema\Table {#1299
#_name: "PRE_APASINFO"
#_columns: array:34 [
"projid" => Doctrine\DBAL\Schema\Column {#1259 …16}
"projpwd" => Doctrine\DBAL\Schema\Column {#1261 …16}
"itemno" => Doctrine\DBAL\Schema\Column {#1260 …16}
"itemversion" => Doctrine\DBAL\Schema\Column {#1263 …16}
"itemname" => Doctrine\DBAL\Schema\Column {#1264 …16}
"projectname" => Doctrine\DBAL\Schema\Column {#1265 …16}
"projectstate" => Doctrine\DBAL\Schema\Column {#1266 …16}
"infotype" => Doctrine\DBAL\Schema\Column {#1267 …16}
"applyname" => Doctrine\DBAL\Schema\Column {#1268 …16}
"apply_cardtype" => Doctrine\DBAL\Schema\Column {#1269 …16}
"apply_cardtypenumber" => Doctrine\DBAL\Schema\Column {#1270 …16}
"contactman" => Doctrine\DBAL\Schema\Column {#1271 …16}
"contactman_cardtype" => Doctrine\DBAL\Schema\Column {#1272 …16}
"contactman_cardnumber" => Doctrine\DBAL\Schema\Column {#1273 …16}
"telphone" => Doctrine\DBAL\Schema\Column {#1274 …16}
"postcode" => Doctrine\DBAL\Schema\Column {#1275 …16}
"address" => Doctrine\DBAL\Schema\Column {#1276 …16}
"legalman" => Doctrine\DBAL\Schema\Column {#1277 …16}
"deptid" => Doctrine\DBAL\Schema\Column {#1278 …16}
"deptname" => Doctrine\DBAL\Schema\Column {#1279 …16}
"receive_useid" => Doctrine\DBAL\Schema\Column {#1280 …16}
"receive_name" => Doctrine\DBAL\Schema\Column {#1281 …16}
"applyfrom" => Doctrine\DBAL\Schema\Column {#1282 …16}
"receivetime" => Doctrine\DBAL\Schema\Column {#1283 …16}
"approve_type" => Doctrine\DBAL\Schema\Column {#1284 …16}
"region_id" => Doctrine\DBAL\Schema\Column {#1285 …16}
"datastate" => Doctrine\DBAL\Schema\Column {#1286 …16}
"create_time" => Doctrine\DBAL\Schema\Column {#1287 …16}
"dataver" => Doctrine\DBAL\Schema\Column {#1288 …16}
"maketime" => Doctrine\DBAL\Schema\Column {#1289 …16}
"signstate" => Doctrine\DBAL\Schema\Column {#1290 …16}
"business_subject_type" => Doctrine\DBAL\Schema\Column {#1291 …16}
"business_subject_info" => Doctrine\DBAL\Schema\Column {#1292 …16}
"item_rowguid" => Doctrine\DBAL\Schema\Column {#1293 …16}
]
-implicitIndexes: []
#_indexes: array:1 [
"primary" => Doctrine\DBAL\Schema\Index {#1296 …8}
]
#_primaryKeyName: "primary"
#_fkConstraints: []
#_options: []
#_schemaConfig: null
#_namespace: null
#_quoted: false
}
]
2
":param1"
"10"
1
":param2"
1
2
":param3"
"234765"
2
":param4"
"1000200010000"
1
":param5"
null
2
":param6"
"律师执业许可"
2
":param7"
"关于宋家辉的律师执业许可"
2
":param8"
"05"
2
":param9"
"4"
2
":param10"
"宋家辉"
2
":param11"
"1"
2
":param12"
"140721199507130033"
2
":param13"
"宋家辉"
2
":param14"
null
2
":param15"
null
2
":param16"
null
2
":param17"
null
2
":param18"
null
2
":param19"
null
2
":param20"
"140100"
2
":param21"
"小店区司法局"
2
":param22"
null
2
":param23"
null
2
":param24"
"网上"
2
":param25"
"2019-08-07 00:00:00"
2
":param26"
"01"
2
":param27"
"370100"
2
":param28"
"1"
2
":param29"
DateTime @1565183438 {#1224
date: 2019-08-07 13:10:38.433565 UTC (+00:00)
}

In OCI8Statement.php line 290:

[Symfony\Component\Debug\Exception\ContextErrorException]
Warning: oci_bind_by_name(): Invalid variable used for bind

Ocramius · 2019-08-08T11:48:16Z

We'd likely need a test scenario to reproduce this issue. I suggest isolating this first to a single column/field that leads to a failure.

lcp0578 · 2019-08-08T12:47:24Z

@Ocramius
I will use the exclusion method to test and find the place where there may be problems.

SenseException · 2019-08-14T11:41:41Z

@lcp0578 Did you proceed to find where the problems may occur?

lcp0578 · 2019-08-15T00:38:44Z

@SenseException @Ocramius thanks.

/**
     * @var string
     *
     * @ORM\Column(name="CREATE_TIME", type="string", length=20, nullable=false, options={"comment":"数据产生时间"})
     */
    private $createTime;

where i set

$preApasinfo->setCreateTime(date('Y-m-d H:i:s')); // correct
$preApasinfo->setCreateTime(new \DateTime()); // report warning

This is what I got wrong.

lcp0578 closed this as completed Aug 15, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Waring:oci_bind_by_name invalid variable used for bind #7792

Waring:oci_bind_by_name invalid variable used for bind #7792

lcp0578 commented Aug 7, 2019

Expected behavior

lcp0578 commented Aug 7, 2019

Ocramius commented Aug 8, 2019

lcp0578 commented Aug 8, 2019

SenseException commented Aug 14, 2019

lcp0578 commented Aug 15, 2019

Waring:oci_bind_by_name invalid variable used for bind #7792

Waring:oci_bind_by_name invalid variable used for bind #7792

Comments

lcp0578 commented Aug 7, 2019

Bug Report

Summary

Current behavior

How to reproduce

Expected behavior

lcp0578 commented Aug 7, 2019

Ocramius commented Aug 8, 2019

lcp0578 commented Aug 8, 2019

SenseException commented Aug 14, 2019

lcp0578 commented Aug 15, 2019