我用的是ESQL
首先:
EXEC SQL DECLARE myCur3 CURSOR FOR SELECT MYDATE,WTSJ,HTXH,GDDM,SCDM,ZQDM,ZQMC,MMLB,WTSL,WTJG,BZXX
FROM CT_ORDER WHERE SCDM = :selwtcx_scdm and GDDM = :selwtcx_gddm and KHDM = selwtcx_khdm ORDER BY gddm;
然后:
EXEC SQL OPEN myCur3;
最后:
EXEC SQL FETCH myCur3 INTO :selwtcx_mydate,:selwtcx_wtsj,:selwtcx_htxh,:selwtcx_gddm,
:selwtcx_scdm,:selwtcx_zqdm,:selwtcx_zqmc,:selwtcx_mmlb,
:selwtcx_wtsl,:selwtcx_wtjg_s,:selwtcx_bzxx;
这时就会有错
首先:
EXEC SQL DECLARE myCur3 CURSOR FOR SELECT MYDATE,WTSJ,HTXH,GDDM,SCDM,ZQDM,ZQMC,MMLB,WTSL,WTJG,BZXX
FROM CT_ORDER WHERE SCDM = :selwtcx_scdm and GDDM = :selwtcx_gddm and KHDM = selwtcx_khdm ORDER BY gddm;
然后:
EXEC SQL OPEN myCur3;
最后:
EXEC SQL FETCH myCur3 INTO :selwtcx_mydate,:selwtcx_wtsj,:selwtcx_htxh,:selwtcx_gddm,
:selwtcx_scdm,:selwtcx_zqdm,:selwtcx_zqmc,:selwtcx_mmlb,
:selwtcx_wtsl,:selwtcx_wtjg_s,:selwtcx_bzxx;
这时就会有错
解决方案 »
- !!!在线等待!!!SQL*Loader-404 错误,如何解决!请大侠帮忙,多谢!!
- 连接数据库提示oracle initialization or shutdown in process
- 多主体复制:帮助中说可以用Replication Management API在不静默主题站点的情况下来实现增加主体站点,请问如何实现?
- 国内著名电子商务网站诚聘DBA,大家速度报名啦
- 请给我客户端访问ORACLE需要的几个动态连接库.100分.
- 散分,主管不喜歡用produre,trigger...
- 新用户的问题
- 两表的联合查询问题?
- union 关键字及 rownum 排序问题
- what're the frequently used packages and data dictionaries.
- 怎样把序列号清零?
- 无法正常启动服务的问题
FROM CT_ORDER WHERE SCDM = :selwtcx_scdm and GDDM = :selwtcx_gddm and KHDM = :selwtcx_khdm ORDER BY gddm;
into 后的变量与对应的字段长度类型要一致!