有关OCIBindByName的奇怪问题

net_wolf 2000-07-05 06:15:00
源程序:
----------------------------------------------------------------
<?php
putenv("LD_LIBRARY_PATH=/oracle/app/oracle/product/8.1.5/lib");
putenv("NLS_LANG=american.america.ZHS16CGB231280");
putenv("ORACLE_BASE=/oracle/app/oracle");
putenv("ORACLE_HOME=/oracle/app/oracle/product/8.1.5");
putenv("ORACLE_SID=ora8");
putenv("ORA_NLS33=/oracle/app/oracle/product/8.1.5/ocommon/nls/admin/d
ata ");
$conn = OCILogon("scott", "tiger");
$stmt = OCIParse($conn,"insert into emp (empno, ename) "." values (no,
name) ");
$empno=2001;
$ename="中文字符";
OCIBindByName($stmt, "NO", &$empno, 32);
OCIBindByName($stmt, "NAME", &$ename, 32);
OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
----------------------------------------------------------------

出错信息:
----------------------------------------------------------------

Warning: OCIBindByName: ORA-01036: illegal variable name/number in /we
b/lhf.php on line 12

Warning: OCIBindByName: ORA-01036: illegal variable name/number in /we
b/lhf.php on line 13

Warning: OCIStmtExecute: ORA-00984: column not allowed here in /web/lh
f.php on line 14

----------------------------------------------------------------
刷新几次后出错信息变成了:
----------------------------------------------------------------

Warning: OCISessionBegin: ORA-12705: invalid or unknown NLS parameter
value specified in /web/lhf.php on line 8

Warning: Supplied argument is not a valid OCI8-Connection resource in
/web/lhf.php on line 9

Warning: Supplied argument is not a valid OCI8-Statement resource in /
web/lhf.php on line 12

Warning: Supplied argument is not a valid OCI8-Statement resource in /
web/lhf.php on line 13

Warning: Supplied argument is not a valid OCI8-Statement resource in /
web/lhf.php on line 14

Warning: Supplied argument is not a valid OCI8-Statement resource in /
web/lhf.php on line 15

----------------------------------------------------------------
只有重新启动netscape web server 才能出现最先的出错信息.

奇怪.
web server 目前以oracle的身份运行.
...全文
368 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
net_wolf 2000-07-11
  • 打赏
  • 举报
回复
已经搞定
zgq 2000-07-10
  • 打赏
  • 举报
回复
用ORA函数

21,886

社区成员

发帖
与我相关
我的任务
社区描述
从PHP安装配置,PHP入门,PHP基础到PHP应用
社区管理员
  • 基础编程社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧